Graceful Switchover and Switchback activity in Dataguard !!!

In this article, we will see the steps of Graceful Switchover and Switchback activity in Dataguard. ======================================================================================================   • SWICTHOVER Activity – Check whether Primary and Standby databases are in sync or not On Primary database SQL> select name, open_mode, database_role from v$database; SQL> select thread#, max(sequence#) from v$archived_log where…

Dataguard configuration in 11gR2 Enterprise Edition !!!

In this article, I will show you the steps for Dataguard configuration in 11gR2 Enterprise Edition. I have another post showing Dataguard configuration using “duplicate target database for standby from active database” command. Here we will create the standby database by restoring the RMAN Backup on standby. Before proceeding, I assume here…

Recover Standby Database Using RMAN Incremental Backup !!!

In this article, we will show the steps that can be used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive log files gap. ======================================================================================================   Below are the steps to perform a Rolling forward for standby database using…