There can be situation , in dataguard setup, where archive logs are missing from primary , before it was being shipped to standby  . Till 11g , we can make standby db sync with primary by taking an incremental […]

In dataguard setup, we can make primary database as physical standby database and standby as primary . This is known as switch over. STEPS: TEST1 – Primary TEST2- STANDBY Before doing switchover, we have to make sure that the existing standby setup is fine and the archives are getting shipped and applied properly on standby. […]

                 To apply psu patch on  physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps.  Download patch from oracle support. 1.Check the database_role for both dbs PRIMARY> select database_role from v$database; DATABASE_ROLE —————- PRIMARY STANDBY> select database_role […]

      Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary .But due to intermittence error or human error, the archives has been deleted from primary. So without those archives, standby can’t be in sync with primary.   In […]

What is snapshot standby: Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database.  i. e we can convert the physical standby database to snapshot standby. On that, we can do all types of testing or can be used as a development database (which is an exact […]

                 Here will build a physical standby setup. Our assumption is primary database is already up and running fine And ORACLE_HOME is installed on standby server.   PRIMARY STANDBY SERVER primary-host standby-host DB_UNIQUE_NAME PROD PRODSBY   PRIMARY: Make sure database is archive log mode, and enable force logging. […]

The main features of Oracle data guard is 1. High availablity 2. Data protection 3. Disaster Recovery             A Dataguard configuration consists of one primary database and one or more standby database. The standby databases will be always in sync  with primary database. If primary production database is unavailable due […]

FIND THE ARCHIVE LAG BETWEEN PRIMARY AND STANDBY:   select LOG_ARCHIVED-LOG_APPLIED “LOG_GAP” from (SELECT MAX(SEQUENCE#) LOG_ARCHIVED FROM V$ARCHIVED_LOG WHERE DEST_ID=1 AND ARCHIVED=’YES’), (SELECT MAX(SEQUENCE#) LOG_APPLIED FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND APPLIED=’YES’);   CHECK THE STATUS OF DIFFERENT PROCESS:     SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY ; PROCESS STATUS THREAD# SEQUENCE# […]