如果备库控制文件损坏,adg需要继续保持同步,那么如何修复
应该从主库拿最新的控制文件,然后配置一下
-
sqlplus / as sysdba
-
alter database create standby controlfile as '/tmp/prod_for_standby.ctl';
-
-
rman target /
-
backup format='/tmp/prod_standby.ctl' current controlfile for standby;
-
-
-
backup format='/tmp/prod_standby.ctl' as copy current controlfile for standby;
-
-
-
run {
-
allocate channel d1 device type disk format '/backup/%U';
-
allocate channel d2 device type disk format '/backup/%U';
-
sql 'alter system archive log current'
-
backup database include current controlfile for standby;
-
sql 'alter system archive log current';
-
backup archivelog all;
-
}
阅读(582) | 评论(0) | 转发(0) |