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博客

oracle 重建redolog 后者增加redolog大小方法

最新文章