第一章:日志管理
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">第一章:日志管理
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; [更多]