ORACLE DG 环境下添加redo组

记一次DG环境下的添加redo操作。

分别查看主库、备库online redo信息是否一致（主备库都查看）

select a.members, a.status, a.bytes / 1024 / 1024, b.type, b.member, b.group# from v$log a, v$logfile b where a.group# = b.group#;

分别查看主库、备库standby_log 信息是否一致（主备库都查看）

select a.member, a.status, b.bytes / 1024 / 1024, b.group#, b.used / 1024 / 1024, b.status from v$logfile a, v$standby_log b where a.group# = b.group#;

在主备库信息一致的情况下继续操作下面的步骤

主库添加日志组

添加online redo组 alter database add logfile group 4 '/opt/app/oracle/oradata/msishr/redo04.log' size 200m; alter database add logfile group 5 '/opt/app/oracle/oradata/msishr/redo05.log' size 200m; 添加standby log组（如果没有standby 日志可以忽略此步） alter database add standby logfile group 4 '/opt/app/oracle/oradata/msishr/standby04.log' size 100M; alter database add standby logfile group 5 '/opt/app/oracle/oradata/msishr/standby05.log' size 100M;

备库操作

添加日志组前操作 —取消主备传送

alter database recover managed standby database cancel;

—改为备库文件改为手动模式

alter system set standby_file_management=manual; 添加onlie redo组 alter database add logfile group 4 '/opt/app/oracle/oradata/msishr/redo04.log' size 200m; alter database add logfile group 5 '/opt/app/oracle/oradata/msishr/redo05.log' size 200m; 添加standby log组（如果没有standby 日志可以忽略此步） alter database add standby logfile group 4 '/opt/app/oracle/oradata/msishr/standby04.log' size 100M; alter database add standby logfile group 5 '/opt/app/oracle/oradata/msishr/standby05.log' size 100M;

–改为备库文件改为自动模式

alter system set standby_file_management=auto;

–开启主备传输

alter database recover managed standby database disconnect from session;