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# […]