常用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 lo