Tag Archive: archive

Problem affecting rman and redolog
  • 30
    Set

Problem affecting rman and redolog

  I have worked on a db  were a rman configured to make a backup every 2 hour that means every two hours we found in the alert.log ALTER SYSTEM ARCHIVE LOG and the db suddenly slows. The problem was...

Read More
Archive for the ‘DataGuard’ Category
  • 12
    Feb

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;...

Read More