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

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@]