Analysis of recovery of oracle dg Archive Log

This article focuses on "oracle dg archive log recovery analysis", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "oracle dg Archive Log recovery Analysis"!

-- DB 11.2

-- check the protection mode set by the database and the current protection level

Select database_role,GUARD_STATUS,open_mode,protection_mode,protection_level from v$database

-- query whether the archive log is sent to and applied to the DG side in the main database. Log generation time and recovery completion time

Select l. "RECID", l. "NAME", l. "ARCHIVED", l. "APPLIED", l. "NEXT_TIME", l. "COMPLETION_TIME"

From v$archived_log l

Where l. "STANDBY_DEST" = 'YES'

And l. "NEXT_TIME" > (sysdate-0.5)

Order by l. "RECID" desc

-- check the application of archived logs on the DG side, log generation time and recovery time

-- if REGISTRARRFSAPPLIEDNO, the log file has been received but has not been applied.

If REGISTRARRFSAPPLIEDIN-MEMORY, the log file has been applied to memory, but the data has not been updated.

-- if REGISTRARRFSAPPLIEDYES, the log file has been applied and the data has been updated.

Select l. "RECID", l. "NAME", l. "ARCHIVED", l. "APPLIED", l. "NEXT_TIME", l. "COMPLETION_TIME"

From v$archived_log l

Where l. "NEXT_TIME" > (sysdate-0.5)

Order by l. "RECID" desc

At this point, I believe that everyone on the "oracle dg archive log recovery analysis" have a deeper understanding, might as well come to the actual operation! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!