10G DATAGUARD增加REDO日志组、删除日志组、删除日志成员实验
参考文档：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
---------- --------------------------------------------------