参考文档：http://www.eygle.com/digest/2010/10/oracle_dataguard_redo_changing.
html
Metalink 473442.1 号文档
近期客户的DATAGUARD环境中主库出现有 checkpoint not complete警告，当前
系统只有3组REDO大小各100M，需要增加REDO日志组。
1.在主库和备库设置standby_file_management 为manual
在主库的设置
SQL> show parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
alter system set standby_file_management='manual';
SQL> show parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string manual
在备库上的停止恢复应用并设置参数：
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> show parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> alter system set standby_file_management='manual';
System altered.
SQL> show parameter standby_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string MANUAL
#############################################################################
2.检查当前REDO日志组号及大小、位置--主备都检查。 SQL> select a.group#,a.bytes/1024/1024 mb,b.member from v$log a,v$logfile b where a.group#=b.group#;
GROUP# MB MEMBER
---------- ---------- ----------------------------------------
1
100
/u01/app/oracle/prod/disk1/redo01.log
2 100 /u01/app/oracle/prod/disk1/redo02.log
3 100 /u01/app/oracle/prod/disk1/redo03.log
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/app/oracle/prod/disk1/redo01.log
2 /u01/app/oracle/prod/disk1/redo02.log
3 /u01/app/oracle/prod/disk1/redo03.log
4 /u01/app/oracle/prod/disk1/standbylog1.log
5 /u01/app/oracle/prod/disk1/standbylog2.log
6 /u01/app/oracle/prod/disk1/standbylog3.log
7 /u01/app/oracle/prod/disk1/standbylog4.log
7 rows selected.
################################################################
3.增加REDO组并检查-参考上步查出的REDO日志位置、大小、成员数。
在主库上增加REDO组及STANDBY REDOLOG（根据系统目前是否创建STANDBY REDOLOG决定）
SQL> alter database add logfile group 11 '/u01/app/oracle/prod/disk1/redo11.log' size 100m;
Database altered.
SQL> alter database add standby logfile '/u01/app/oracle/prod/disk1/standbylog11.log' size 100m;
Database altered.
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/app/oracle/prod/disk1/redo01.log
2 /u01/app/oracle/prod/disk1/redo02.log
3 /u01/app/oracle/prod/disk1/redo03.log
4 /u01/app/oracle/prod/disk1/standbylog1.log
5 /u01/app/oracle/prod/disk1/standbylog2.log
6 /u01/app/oracle/prod/disk1/standbylog3.log
7 /u01/app/oracle/prod/disk1/standbylog4.log
11 /u01/app/oracle/prod/disk1/redo11.log
8 /u01/app/oracle/prod/disk1/standbylog11.log
############################################################
在备库上增加REDO组及STANDBY REDOLOG（根据系统目前是否创建STANDBY REDOLOG决定）
SQL> alter database add logfile group 11 '/u01/app/oracle/prod/disk1/redo11.log' size 100m;
Database altered.
SQL> alter database add standby logfile '/u01/app |