典藏之作oracle常用命令大汇总.doc

典藏之作: 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 dat