DataGuardGapDetectionandResolution(DocID232649.1)(三)

2014-11-24 11:00:34 · 作者: · 浏览: 1
HERE NEXT_CHANGE# NOT IN 3> (SELECT FIRST_CHANGE# FROM DBA_LOGSTDBY_LOG WHERE L.THREAD# = THREAD#) 4> ORDER BY THREAD#,SEQUENCE#; THREAD# SEQUENCE# FILE_NAME ---------- ---------- ----------------------------------------------- 1 451 /u01/oradata/logical_stby/arch/arch_1_451.arc 1 453 /u01/oradata/logical_stby/arch/arch_1_453.arc Copy the missing logs to the logical standby system and register them using the ALTER DATABASE REGISTER LOGICAL LOGFILE statement on your logical standby database. SQL>
ALTER DATABASE REGISTER LOGICAL LOGFILE /u01/oradata/logical_stby/arch/arch_1_452.arc; After you register these logs on the logical standby database, you can restart log apply services.