1、增加新日志组
2、切换日志,并完成归档alter system switch logfile;
3、删除group 1 2 3 ……
4、增加group 1 2 3 ……
alter database add logfile group 5('/home/oracle/oracle/product/10.2.0/oradata/oracle/redo50.log','/home/oracle/oracle/product/10.2.0/oradata/oracle/redo51.log') size 50M;
alter database drop logfile group 5;(当)
alter system switch logfile;
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 29 YES INACTIVE
2 30 YES ACTIVE
3 28 YES INACTIVE
4 31 NO CURRENT
select group#,status,member from v$logfile;
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/70612/viewspace-1020279/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/70612/viewspace-1020279/