oracle 常用命令新.pdf

Oracle 命令全集 第一章：日志管理 第二章：表空间管理 第三章：表 第四章：索引 第五章：约束 第六章：LOAD 数据 第七章：reorganizing data 第八章： managing password security and resources 第九章：Managing users 第十章：managing privileges 第十一章： manager role 第十二章: BACKUP and RECOVERY Oracle 命令全集 第一章：日志管理 1.forcing log switches sql alter system switch logfile; 2.forcing checkpoints sql alter system checkpoint; 3.adding online redo log groups sql alter database add logfile [group 4] sql (/disk3/log4a.rdo,/disk4/log4b.rdo) size 1m; 4.adding online redo log members sql alter database add logfile member sql /disk3/log1b.rdo to group 1, sql /disk4/log2b.rdo to group 2; 5.changes the name of the online redo logfile sql alter database rename file c :/oracle/oradata/oradb/redo01.log sql to c :/oracle/oradata/redo01.log; 6.drop online redo log groups sql alter database drop logfile group 3; 7.drop online redo log members sql alter database drop logfile member c :/oracle/oradata/redo01.log; 8.clearing online redo log files sql alter database clear [unarchived] logfile c :/oracle/log2a.rdo; 9.using logminer analyzing redo logfiles a. in the init.ora specify utl_file_dir = b. sql execute dbms_logmnr_d.build(oradb.ora,c :oracleoradblog); c. sql execute dbms_logmnr_add_logfile(c :oracleoradataoradbredo01.log, sql dbms_lo