oracle的命令大全.docVIP

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:\oracle\oradb\log); c. sql; execute dbms_logmnr_add_logfile(c:\oracle\oradata\oradb\redo01.log, sql; dbms_logmnr.new); d. sql; execute dbms_logmnr.add_logfile(c:\oracle\oradata\oradb\redo02.log, sql; dbms_logmnr.addfile); e. sql; execute dbms_logmnr.start_logmnr(dictfilename=;c:\oracle\oradb\log\oradb.ora); f. sql; select * from v$logmnr_contents(v$logmnr_dictionary,v$logmnr_parameters sql; v$logmnr_logs); g. sql; execute dbms_logmnr.end_logmnr;第二章：表空间管理1.create tablespaces sql; create tablespace tablespace_name datafile c:\oracle\oradata\file1.dbf size 100m, sql; c:\oracle\oradata\file2.dbf size 100m minimum extent 550k [logging/nologging] sql; default storage (initial 500k next 500k maxextents 500 pctinccease 0) sql; [online/offline] [permanent/temporary] [extent_management_clause]2.locally managed tablespace sql; create tablespace user_data datafile c:\oracle\oradata\user_data01.dbf sql; size 500m extent