Data Guard

Building a Physical Standby Database (02/14) - Prepare configuration files on both sides

by Ed Chen
November 14, 2012January 11, 2021

Building a Physical Standby Database (01/14) - Install an empty database on standbyThere are four configuration files needs to be prepared on both sides, the… Read More »

Building a Physical Standby Database (01/14) - Install an empty database on standby

by Ed Chen
November 13, 2012August 5, 2020

Go Back to Overview Page - Building a Physical Standby Database (00/14) - An OverviewAssuming the db_name is already there for the running primary database,… Read More »

Building a Physical Standby Database (00/14) - An Overview

by Ed Chen
November 12, 2012August 5, 2020

Building a standby database will adopt various Oracle database technologies, such as Oracle Net, RMAN backup and recovery, duplication, startup and shutdown, data guard and… Read More »

How Standby Change Apply Instance

by Ed Chen
November 11, 2012April 5, 2022

Apply Instance If you have not assign a preferred apply instance in the broker configuration in advance, the broker will choose one of running instances… Read More »

How to Resolve ORA-16649 after a Fast-Start Failover

by Ed Chen
November 6, 2012January 12, 2021

After a fast-start failover, the broker will try to reinstate the standby database (former primary database) for sustaining data guard architecture. While reinstating, the broker… Read More »

How to Implement Fast-Start Failover 11g

by Ed Chen
November 5, 2012August 5, 2020

Before enabling fast-start failover in data guard broker, the only required precondition is enabling Flashback Database. But before enabling Flashback Database, you must enable Flash… Read More »

How to Failover to a Standby Database Manually and Rebuild Data Guard - By Example

by Ed Chen
November 4, 2012January 19, 2021

Since a fast-start failover (automatic failover) could become a false failover when the observer or the standby database cannot connect to the primary database within… Read More »

SRVCTL Modify Database Startup Option

by Ed Chen
November 2, 2012May 22, 2022

SRVCTL Start Database Mount standby In some cases, you would like to change the default startup option of srvctl other than OPEN, for example, after… Read More »

How to Write Control File into Raw Device

by Ed Chen
October 25, 2012August 10, 2021

Control File in Raw Device? Since raw devices cannot be read/write as a normal file operation, you cannot write a controlfile directly into a raw… Read More »