Setting up Data Guard through OEM

One of the common tasks for an Oracle DBA is to set up an existing Oracle instance in Data Guard. Many DBA’s have struggled through the task of setting it up using many different sets of step by step instructions on the internet. However, perhaps the simplest method of setting up Data Guard is to set it up through OEM Grid Control or OEM Cloud Control.

This blog entry contains the step by step instructions for setting it up through OEM Cloud Control.

  1. Create an Oracle Home on the standby server. If the primary database uses ASM, create an ASM instance on the standby server. The version on the standby instance must be the same Oracle version as the Primary.
  2. Make sure that both the Primary instance and the standby Oracle Home and ASM instance (if required) are registered in OEM Grid Control/OEM Cloud Control
  3. In OEM Cloud Control go to the Source database page:

 

 

 

  1. Under the availability, choose ‘Add Standby Database’, then create new physical standby database, then continue.

 

  1. Choose online backup, use recovery manager (defaults), then continue.

  1. Choose the default under backup options, and enter the Primary host credentials, typically these will already be set up.

 

 

  1. Enter the standby location information.

 

 

 

  1. Enter the standby database file location information. If you use a file system, you can customize the file locations. OEM Cloud Control requires you to go to ASM when the source is ASM.

 

  1. Choose the appropriate options for Oracle restart configuration. Its fairly rare that you want automatic Oracle restart. Typically you do not want automatic restart.
  2. I prefer to use Data Guard broker. Also, OEM Cloud Control expects to use Data Guard broker, so it is probably best to use the broker.

  1. Review the information provided, and if all looks right, choose Finish.

  1. At that point, OEM will submit a job to complete the setup of the standby database.

 

You can monitor the job through grid control. Once the job is complete, you will see a Data Guard administration page under the ‘Availability’ tab and there you can check on the status of your standby.

 

 

Remember to go back and set up the standby target in OEM Cloud Control/OEM Grid Control once complete.

2 Responses to “Setting up Data Guard through OEM”

  1. stephan uzzell Says:

    Hi Andrew,

    This sounds much simpler than the manual process we’ve been following. One question, please – since I can’t tell from your screenshots – can you configure where the backup gets stored? Does it take a local backup (to the default backup location?)?

    Thanks,
    stephan

    • dbakerber Says:

      Yes, you can. In Oracle 11, no staging area is required, but when doing this for Oracle 10gR2 and below, it will prompt you for a location for the files. It will also allow you to move one file at a time, so the staging area only has to be as large as your largest DB file, or to move the whole backup.

      Sorry about the quality of the screen shots, you can hit ctl-+ to zoom in, but in the example I use it does not use a staging area.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: