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

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 ASM. In the series of demonstration, we will build a standby RAC from a primary RAC, so four nodes in totals come to play.

There are so many common features to build a physical standby database across various database versions, from the top to view these features, the key feature is the sequence, if the steps in the sequence is misplaced, the result could be wrong or hard to fix. The concepts of the sequence are quite simple.

• From bottom to top while preparation.
• From top to bottom while creation.

Four major parts involve in the sequence, they are:

1. Infrastructure preparation.
2. Database preparation.
3. Database creation.
4. Data guard broker enablement.

Here are the steps to achieve the goal, for readability, I divide them into the four major parts as above.

A. Infrastructure preparation.

1. Install an empty database on standby
2. Prepare configuration files on both sides
3. Prepare pfile for both primary and standby database

B. Database preparation.

4. Enable force logging and archivelog on primary database
5. Create standby redo logs on primary database
6. Prepare standby controlfile on primary database
7. Prepare data files on primary database

C. Database creation.

8. Copy data files into standby database
9. Copy standby controlfile into standby database
10. Create standby redo logs on standby database
11. Create spfile for both primary and standby database
12. Recover managed standby database

D. Data guard broker enablement.

13. Configure data guard broker
14. Verify all settings are correct

For further details, please refer to the following posts:

• Building a Physical Standby Database (01/14) - Install an empty database on standby
• Building a Physical Standby Database (02/14) - Prepare configuration files on both sides
• Building a Physical Standby Database (03/14) - Prepare pfile for both primary and standby database
• Building a Physical Standby Database (04/14) - Enable force logging and archivelog on primary database
• Building a Physical Standby Database (05/14) - Create standby redo logs on primary database
• Building a Physical Standby Database (06/14) - Prepare standby controlfile on primary database
• Building a Physical Standby Database (07/14) - Prepare data files on primary database
• Building a Physical Standby Database (08/14) - Copy data files into standby database
• Building a Physical Standby Database (09/14) - Copy standby controlfile into standby database
• Building a Physical Standby Database (10/14) - Create standby redo logs on standby database
• Building a Physical Standby Database (11/14) - Create spfile for both primary and standby database
• Building a Physical Standby Database (12/14) - Recover managed standby database
• Building a Physical Standby Database (13/14) - Configure data guard broker
• Building a Physical Standby Database (14/14) - Verify all settings are correct