ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Step By Step How to Recreate Dataguard Broker Configuration [ID 808783.1]

Step By Step How to Recreate Dataguard Broker Configuration [ID 808783.1]

原创 Linux操作系统 作者:rongshiyuan 时间:2013-06-28 00:28:04 0 删除 编辑
Step By Step How to Recreate Dataguard Broker Configuration [ID 808783.1]
 

In this Document


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 28-Aug-2012***


Goal

Step By Step How to Recreate Dataguard Broker Configuration.

Fix

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/;
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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17252115/viewspace-764982/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-11-24

  • 博文量
    798
  • 访问量
    3198651