ADG新建redo

ADG环境主库加redo,redo standby 流程，再把之前使用的redo group，redo standby group删掉
1.使用以下命令添加redo（下面是例子，实际磁盘路径需要确认再替换）
alter database add logfile thread 1 group 111 ('/dev/vgdp1/rlvol41','/dev/vgdp2/rlvol41') size 2000M;
alter database add logfile thread 1 group 118 ('/dev/vgdp1/rlvol42','/dev/vgdp2/rlvol42') size 2000M;
alter database add logfile thread 1 group 211 ('/dev/vgdp1/rlvol43','/dev/vgdp2/rlvol43') size 2000M;
alter database add logfile thread 1 group 218 ('/dev/vgdp1/rlvol44','/dev/vgdp2/rlvol44') size 2000M;
2.使用以下命令查看current状态的redo group
sql>@?/ORAMON/log
3.非current状态的redo group可以用以下命令把之前旧的redo group删掉
例：alter database drop logfile group 101;
4.current状态的旧redo group可以先用命令切换几次，等状态变成非current，再用命令删掉
例：
sql>alter system switch logfile;
或者在主库的当前实例
alter system archive log current;
5.使用以下命令添加redo standby（下面是例子，实际磁盘路径需要确认再替换）
alter database add standby logfile thread 1 group 311 ('/dev/vgrdp/rlvo141') size 2000M;
alter database add standby logfile thread 1 group 319 ('/dev/vgrdp/rlvo142') size 2000M;
alter database add standby logfile thread 1 group 411 ('/dev/vgrdp/rlvo143') size 2000M;
alter database add standby logfile thread 1 group 419 ('/dev/vgrdp/rlvo144') size 2000M;
6.使用以下命令可以确认redo standby group
select group#,sum(bytes/1024/1024) "size in MB" from v$standby_log group by group#;
7.可以使用以下命令把旧的redo standby group 删除掉
alter database drop standby logfile group 1;

ADG环境备库加redo，redo standby流程，再把之前使用的redo group，redo standby group 删掉
1.备库先打了数据库补丁，所以现在应该是ADG已经停掉的状态。
2.使用以下命令把下面参数变成manual
alter system set standby_file_management='manual';
3.使用以下命令在备库添加redo
注意：需要改成生产的路径（注意裸设备的数组和权限）
alter database add logfile thread 1 group 111 ('/dev/vgrdp1/rlvol41','/dev/vgrdp2/rlvo141') size 2000M;
alter database add logfile thread 1 group 118 ('/dev/vgrdp1/rlvol42','/dev/vgrdp2/rlvo142') size 2000M;
alter database add logfile thread 1 group 211 ('/dev/vgrdp1/rlvol43','/dev/vgrdp2/rlvo143') size 2000M;
alter database add logfile thread 1 group 218 ('/dev/vgrdp1/rlvol44','/dev/vgrdp2/rlvo144') size 2000M;
4.使用以下命令查看current状态的redo group
sql>@?/ORAMON/log
5.非current状态的redo group先用下面命令clear然后再drop命令删除
alter database clear logfile group 101;
alter database drop logfile group 101;
6.使用以下命令在备库添加redo standby
alter database add standby logfile thread 1 311 ('/dev/vgrdp/rlvol41') size 2000M;
alter database add standby logfile thread 1 319 ('/dev/vgrdp/rlvol41') size 2000M;
alter database add standby logfile thread 1 411 ('/dev/vgrdp/rlvol41') size 2000M;
alter database add standby logfile thread 1 419 ('/dev/vgrdp/rlvol41') size 2000M;
7.使用以下命令确认redo standby group
select group#,sum(bytes/1024/1024) "size in MB" from v$standby_log group by group#;
8.使用以下命令把旧的redo standby group 删掉
alter database drop standby logfile group 1;
9.ADG启动
10.在主库使用以下命令切换，让备库之前current状态的redo，切换到我们新库加的redo组里。
alter system switch logfile;
或者在主库当前实例
alter system archive log current;
11停止ADG
alter database recover managed standby database cancel;
12.把变成非current状态的旧redo group 先用下面命令clear然后再用drop命令删掉
alter database clear logfile group 105;
alter database clear logfile group 203;
alter database drop logfile group 105;
alter database drop logfile group 203;
13.启动ADG，并把下面参数变成AUTO
alter system set standby_file_management='AUTO';
--备库启动real-time apply;
alter database recover managed standby database using current logfile disconnect from session;