19C DG 应用lag快捷恢复
--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;
#!/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 &