Archive for the ‘DataGuard’ Category
DATAGUARD:Verifying synchronization between the primary and standby databases By using the following steps, you can control whether the standby database is synchronized with primary: 1. STANDBY DATABASE For the last archived sequence, use the following: SQL> SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG; MAX(SEQUENCE#) ————– 195 For the last applied sequence, use the following: SQL> SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG WHERE APPLIED=’YES’; MAX(SEQUENCE#) ————– 194 From the preceding two queries, we see that the latest sequence, 195, is being archived or written into the standby redo logfiles. There’s expected to be a lag of one sequence between archived and applied columns. 2. STATUS OF...