linux下 oracle里常用命令.docVIP

第一章：日志管理 　　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 management local uniform size 10m; 　　3.temporary tablespace 　　sql create temporary t