Recreate Dataguard Broker Configuration

分类: Linux

In this Document
  Goal
  Solution
  References


Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 22-Mar-2011***

Goal

Step By Step How to Recreate Dataguard Broker Configuration.

Solution

Step 1. Stop broker in both of primary and standby databases (in all instances in case of RAC): 

SQL>ALTER SYSTEM SET DG_BROKER_START=FALSE; 

Step 2. Drop old broker configuration files from both primary and standby: 

Check the location of files using : "show parameter dg_broker_config_file" 
By default the broker configuration files will be in "$ORACLE_HOME/dbs" in Unix and "$ORACLE_HOME/database" in Windows. 

SQL> show parameter dg_broker_config_file 

NAME                   TYPE   VALUE 
---------------------- ------ ---------------------------------------- 
dg_broker_config_file1 string \oracle\product\10.2.0\dbs\dr1PROD10G.dat 
dg_broker_config_file2 string \oracle\product\10.2.0\dbs\dr2PROD10G.dat

Drop the files using ASMCMD if files are on ASM

ASMCMD> cd DATA/PROD10G/
ASMCMD> rm dr1PROD10G.dat 
ASMCMD> rm dr2PROD10G.dat 

Drop the files using : 

Unix 

$cd $ORACLE_HOME/dbs 
$ rm dr1PROD10G.dat 
$ rm dr2PROD10G.dat

Windows 

c:\>cd $ORACLE_HOME/database 
D:\oracle\product\10.2.0\db_2\database> del dr1PROD10G.dat 
D:\oracle\product\10.2.0\db_2\database> del dr2PROD10G.dat 

Step 3. Start broker in both of primary and standby (in all instances in case of RAC): 

SQL>ALTER SYSTEM SET DG_BROKER_START=TRUE; 

Step 4. Connect to DGMGRL on primary: (from instance one in case of RAC) 

$dgmgrl 
DGMGRL for Linux: Version 10.2.0.3.0 - Production 

Copyright (c) 2000, 2005, Oracle. All rights reserved. 

Welcome to DGMGRL, type "help" for information. 

DGMGRL> CONNECT sys/<password>; 
Connected. 

Step 5. Create configuration on primary: 

DGMGRL> CREATE CONFIGURATION 'PRODCONF' AS PRIMARY DATABASE IS 'PROD10G' CONNECT IDENTIFIER IS PROD10G; 

Configuration "PRODCONF" created with primary database "PROD10G" 

Step 6. Add standby in the configuration: 

DGMGRL> ADD DATABASE 'STDBY10G' AS CONNECT IDENTIFIER IS STDBY10G MAINTAINED AS PHYSICAL; 

Database "STDBY10G" added

Step 7. Enable Configuration: 

DGMGRL> ENABLE CONFIGURATION; 
Enabled. 

Use the SHOW command to verify that the configuration and its databases were successfully enabled and brought online: 

DGMGRL> SHOW CONFIGURATION; 

Configuration 
Name: PRODCONF 
Enabled: YES 
Protection Mode: MaxPerformance 
Fast-Start Failover: DISABLED 

Databases: 
PROD10G - Primary database 
STDBY10G - Physical standby database 

Current status for "PRODCONF" 
SUCCESS


References

NOTE:454418.1 - Unable To Recreate Data Guard Fast Start Failover Configuration With DGMGRL
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页