Tag Archives: Data Guard

Recover Gaps in Standby Database from primary Using incremental backups

Recovering a Standby database from a missing archives log Recover Gaps in Standby Database from primary Using incremental backups A Physical Standby database synchs with Primary by continuous apply of archivelogs from a Primary Database. In case of an archivelog … Continue reading

Posted in Data Guard | Tagged | 1 Comment

Recover Gaps in Standby Database from primary Using incremental backups

Recovering a Standby database from a missing archives log A Physical Standby database synchs with Primary by continuous apply of archivelogs from a Primary Database. In case of an archivelog gone missing or corrupt you have to rebuild the standby … Continue reading

Posted in Data Guard | Tagged | Leave a comment

Recovering a Standby database from a missing archives log

Recover Gaps in Standby Database from primary Using incremental backups A Physical Standby database synchs with Primary by continuous apply of archivelogs from a Primary Database. In case of an archivelog gone missing or corrupt you have to rebuild the … Continue reading

Posted in Standby database Data Guard missing archives GAP - thread 1 sequence | Tagged | Leave a comment

Managing Archive Gaps Manually on Standby Database Setup

To determine if there is an archive gap on your physical standby database SQL> SELECT * FROM V$ARCHIVE_GAP; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# ———– ————- ————– 1 12499 12511 In this case, Standby database is waiting for archive log 12499 SQL> select … Continue reading

Posted in Data Guard | Tagged | 4 Comments

How to setup transparent Switchover / Failover to application and clients

If there is a failover or switchover and if user(s) are trying to connect to database with same connect string, end up with below error message C:\>sqlplus system/password@trg1 SQL*Plus: Release 10.2.0.1.0 – Production on Fri Jul 17 12:29:25 2009 Copyright … Continue reading

Posted in Data Guard, oracle Dataguard transparently Connectivity standby | Tagged | Leave a comment

Step by step Data Guard implementation

Step by step Data Guard implementation (On Oracle 10gR2) Assuming that PRIMARY Database is up and running and Oracle s/w is installed on STANDY Server. Oracle_home=/oracle/ora10g Oracle_base=/oracle PRIMARY Server: Host name : traindb1 Database name (db_name): trg Database Unique Name … Continue reading

Posted in ORACLE DATAGUARD STANDBY INSTALLATION | Tagged | Leave a comment