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;

---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 &