Oracle 11g Data Guard: Grid Control Management - Page 2

June 25, 2009

Verifying the Data Guard Configuration

Grid Control also allows me to easily verify the existing Data Guard environment with one simple mouse click. By selecting the Verify Configuration link under the Additional Administration section near the bottom of the Data Guard panel shown in Figure 3-13 previously, Grid Control initiates a complete verification of the current Data Guard “stack”:

Click for larger image
Launching the Data Guard Configuration Verification Tool

Figure 3-21. Launching the Data Guard Configuration Verification Tool

Once the verification is complete, Grid Control details its findings in a report, as well as offering suggestions for configuration of standby redo logging to insure the highest level of data protection, as shown in Figure 3-22 below:

Click for larger image
Data Guard Configuration Verification Report

Figure 3-22. Data Guard Configuration Verification Report

Finally, here’s the complete text of the verification report I created against my current Data Guard environment using Grid Control:

Initializing
Connected to instance 11gPrimary:orcl
Starting alert log monitor...
Updating Data Guard link on database homepage...

Data Protection Settings:
  Protection mode : Maximum Performance
  Log Transport Mode settings:
    primary_db: ASYNC
    stdby_db: ASYNC
  Checking standby redo log files.....Done
   (Standby redo log files needed : 1)

Checking Data Guard status
  primary_db : Normal
  stdby_db : Normal
Checking Inconsistent Properties

Checking agent status
  primary_db ... OK
  stdby_db ... OK

Switching log file 162.Done
  Checking applied log on primary_db.......WARNING: 
Timed out after 60 seconds waiting for log to be applied.

Processing completed.

Performing Switchover Using EM Grid Control

Now that my Grid Control environment is configured and established, I’ll demonstrate how to perform the same switchover and switchback operations that I illustrated in the prior article via Data Guard Broker’s command line tool, DGMGRL. From the Data Guard Configuration panel (see Figure 3-13) I’ll select my standby database, stdby_db, as the target of the switchover operation and then click the Switchover button. Grid Control next asks me to confirm my intentions, as shown in Figure 3-31:

Confirming the Switchover Target
Figure 3-31. Confirming the Switchover Target

Once I confirm the switchover operation, Grid Control tracks the operation’s progress until it’s successfully completed, as shown in Figure 3-32:

Monitoring Switchover Progress
Figure 3-32. Monitoring Switchover Progress

After a few minutes, Grid Control confirms the successful transition between primary and standby databases. This is reflected in the information presented in Figure 3-33. Notice that the two databases have indeed reverted to their originally assigned roles:

A Successful Switchover
Figure 3-33. A Successful Switchover

I’ve captured the edited alert logs of the primary and standby databases in Listing 3.1 to confirm the successful switchover operation.

Performing Switchback Using EM Grid Control

Performing a switchback operation is also simple using Grid Control. Now that I’ve successfully completed the switchover operation, I’ll initiate a switchback operation as shown in Figure 3-41 below:

Initiating the Switchback Operation
Figure 3-41. Initiating the Switchback Operation

This time around, however, note that I’ll select my original primary database (primary_db) as the target of the switchback operation and then click the Switchover button. Grid Control once again asks me to confirm my intentions, as shown in Figure 3-42:

Confirming the Switchback Target
Figure 3-42. Confirming the Switchback Target

Once a few moments have elapsed, Grid Control once again confirms the successful transition between the original standby (now fulfilling the standby role once again) and the original primary (also now fulfilling the primary role again). This is reflected in the information presented in Figure 3-43:

A Successful Switchback
Figure 3-43. A Successful Switchback

The results of the successful switchback operation are confirmed in the edited alert logs of the primary and standby databases as shown in Listing 3.2.

Next Steps

In the next article in this series, I’ll explore how to:

  • Use a recovery catalog to catalog backups made on the standby database
  • Implement block change tracking on a standby database
  • Create incrementally updateable image copy backups from a standby database

References and Additional Reading

While I’m hopeful that I’ve given you a thorough grounding in the technical aspects of the features I’ve discussed in this article, I’m also sure that there may be better documentation available since it’s been published. I therefore strongly suggest that you take a close look at the corresponding Oracle documentation on these features to obtain crystal-clear understanding before attempting to implement them in a production environment. Please note that I’ve drawn upon the following Oracle Database 10g and 11g documentation for the deeper technical details of this article:

B28279-02 Oracle Database 11g New Features Guide

B28294-03 Oracle Database 11g Data Guard Concepts and Administration

B28295-03 Oracle Database 11g Data Guard Broker

B28320-01 Oracle Database 11g Reference Guide

B28419-02 Oracle Database 11g PL/SQL Packages and Types Reference

B28832-01 Oracle Database 10g Enterprise Manager Grid Control Agent Download Installation

Also, the following MetaLink documentation was extremely helpful after patching of the Enterprise Manager Grid Control agents was completed and I needed to synchronize the agents on the primary and standby database servers with the contents of the Enterprise Manager Grid Control management repository:

330932.1 Problem - Agent Upload Fails - OMS VERSION NOT CHECKED YET

389528.1 Problem: Agent Upload Fails: OMS VERSION NOT CHECKED YET => nmejcn: Received No Status Header From Repository

» See All Articles by Columnist Jim Czuprynski








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers