19C DG 应用lag快捷恢复
2023-05-19 16:00 明朝散发 阅读(24) 评论(0) 编辑 收藏 举报--standby db:
SELECT thread#, group#, sequence#, bytes, archived, status FROM v$standby_log order by thread#, group#;
--lack of archivelogs
--solution
--stop MRP
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
---recovery
#!/bin/ksh
echo ""Running DG recovery ...""
$ORACLE_HOME/bin/rman nocatalog << ! | tee /tmp/yan_recdg.log
connect target
run {
RECOVER STANDBY DATABASE FROM SERVICE XXXXX;
}
exit
nohup ./dgfix.sh > /tmp/yan_dgfixsh.log 2>&1 &