Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

Oracle Database 11g Release 2 Data Guard Setup using Oracle Grid Control

This article describes the creation of a standby database using Oracle Database 11g Release 2 and the Oracle Grid Control. The article assumes the following servers are present.

With this setup in place, the standby database is created and managed from Oracle Grid Control as follows.

Related articles.

Standby Database Creation

Navigate to the "Availability" tab of the primary database server (Targets > Databases > (Primary Database Name) > Availability). Click on the "Add Standby Database" link under the "Data Guard" section of the page.

Availability

On the resulting page, click on the "Add Standby Database" link.

Data Guard

Accept the "Create a new physical standby database" option by clicking the "Continue" button.

Add Standby Database

Accept the "Perform an online backup of the primary database" and "Use Recovery Manager (RMAN) to copy the files" options by clicking the "Next" button.

Backup Type

Enter the "Primary Host Credentials", if they have not already been defaulted as a preferred credentials, then click the "Next" button.

Backup Options

Enter the name of the standby host and its host credentials, then click the "Next" button.

Database Location

Select the "Keep file names and locations the same as primary database" option, then click the "Next" button.

File Locations

Enter a "Database Unique Name" and "Target Name" and select the "Use SYSDBA monitoring credentials" option, then click the "Next" button. Notice the "Use Data Guard Broker" option is checked.

Configuration

If you are happy with the information on the review page, then click the "Finish" button.

Review

Wait while the first section of processing completes.

Processing

Once the basic processing is complete, you are presented with the Data Guard "Setup and Manage" screen. Towards the bottom of the screen is a list of available standby databases, with the new standby database listed. The status of the new database is "Creation in process". Clicking on this status link gives a breakdown of the current processing.

Creation In Progress

Expand the "Task: DBClone" node for a more detailed status of the operation.

Job Activity

The image below shows an example of the expanded progress.

Job Activity Expanded

When the standby database creation is complete, the "Setup and Manage" screen will display a status of "Normal" for the standby database.

Creation Complete

The "Availability" tab now includes several new links in the "Data Guard" section.

Data Guard

Switchover

To perform a switchover, navigate to the "Setup and Manage" screen, select the standby server you wish to become the new primary server, then click the "Switchover" button.

Switchover

Accept the "Swap Monitoring Settings" and "Transfer Jobs" options by clicking the "OK" button.

Switchover Confirmation

Wait while the switchover processing takes place.

Processing

Once complete, the "Setup and Manage" screen shows the primary and standby roles have been reversed.

Switchover Complete

Performance

The "Data Guard" section of the "Availability" tab includes a "Performance" link. Click on this link to monitor the performance of the standby database.

Data Guard

If the database load is too low to stress the standby server, a built in test application can be run to stress test it. The test application is started by clicking the "Start" button under the "Test Application" section.

Performance

Clicking on the graphs drills down into additional information. When you have finished monitoring the standby performance click the "Stop" button to stop the test application.

Performance Run

Once the test application is stopped, the performance information gathered is still available.

Performance Stop

For more information see:

Hope this helps. Regards Tim...

Back to the Top.