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

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.

  • Grid Control (10.2.0.5). An example installation can be found here.
  • A primary database server, with Oracle Database 11g Release 2 software installed and an existing database present. An example installation can be found here.
  • A standby database server with a software-only installation of Oracle Database 11g Release 2. Setup and installation is the same as the previous server, with the exception of the software-only installation.
  • Both database servers should have a Grid Control agent installed. An example installation can be found here.

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:

Sobre Alexandre Pires

ORACLE OCS Goldengate Specialist, OCE RAC 10g R2, OCP 12C, 11g, 10g , 9i e 8i - Mais de 25 anos de experiência na área de TI. Participei de projetos na G&P alocado na TOK STOK, EDINFOR alocado na TV CIDADE "NET", 3CON Alocado no PÃO DE AÇUCAR, DISCOVER alocado na VIVO, BANCO IBI e TIVIT, SPC BRASIL, UOLDIVEO alocado no CARREFOUR e atualmente na ORACLE ACS atendendo os seguintes projetos: VIVO, CLARO, TIM, CIELO, CAIXA SEGUROS, MAPFRE, PORTO SEGURO, SULAMERICA, BRADESCO SEGUROS, BANCO BRADESCO, BASA, SANTANDER, CNJ, TSE, ELETROPAULO, EDP, SKY, NATURA, ODEBRESHT, NISSEI, SICREDI, CELEPAR, TAM, TIVIT, IBM, SMILES, CELEPAR, SERPRO,OKI,BANCO PAN, etc
Esse post foi publicado em DATAGUARD, GRID CONTROL, ORACLE 11gR2, TUTORIAL. Bookmark o link permanente.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s