Previously, we have set up the PAA environment for rac and data guard of a single instance database (see). To facilitate the switchover operation, we have configured data guard broker for the operation here! In the rac environment, you need to store the configuration file of data guard broker on shared storage!
1. modify the configuration file parameters of data guard broker to start the dmon process.
[Oracle @ rac1 ~] $ SqlplusSys/123456 @ racAs sysdba
SQL * Plus: Release 10.2.0.5.0-Production on Sat Jan 14 21:11:34 2012
Copyright (c) 1982,201 0, Oracle. All Rights Reserved. Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options SQL> show parameter dg_broker_config; NAME TYPE
---------------------------------------------------------------------
VALUE
------------------------------
Dg_broker_config_file1 string
+ DATA/rac/dgbroker/dg_config_f
Ile1.dat
Dg_broker_config_file2 string
+ FRA/rac/dgbroker/dg_config_fi
Le2.dat SQL> alter system set dg_broker_start = true;
System altered. SQL> connSys/123456 @ orclAs sysdba
Connected. SQL> show parameter dg_broker_config; NAME TYPE
---------------------------------------------------------------------
VALUE
------------------------------
Dg_broker_config_file1 string
/U01/app/oracle/product/10.2.0
/Db1/dbs/dg_config_file1.dat
Dg_broker_config_file2 string
/U01/app/oracle/product/10.2.0
/Db1/dbs/dg_config_file2.dat SQL> alter system set dg_broker_start = true;
System altered. |
Ii. Use the srvctl command to modify the startup options of the rac database. If the standby database is also in the rac environment, modify the settings accordingly.
[Oracle @ rac1 ~] $ Srvctl modify database-d rac-s open-r primary-o $ ORACLE_HOME
[Oracle @ rac1 ~] $ Srvctl stop database-d rac-o immediate
[Oracle @ rac1 ~] $ Srvctl start database-d rac
3. Create a configuration file for the dg broker
[Oracle @ server49 ~] $ DgmgrlSys/123456 @ rac
DGMGRL for Linux: Version 10.2.0.5.0-64bit Production
Copyright (c) 2000,200 5, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> create configuration PAA as primary database is rac connect identifier is rac;
Configuration "Paa" created with primary database "rac" DGMGRL> add database orcl as connect identifier is orcl maintained as physical;
Database "orcl" added DGMGRL> show configuration; Configuration
Name: PAA
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
Rac-Primary database
Orcl-Physical standby database Current status for "Paa ":
DISABLED DGMGRL> show database verbose rac; Database
Name: rac
Role: PRIMARY
Enabled: NO
Intended State: ONLINE
Instance (s ):
Rac2
Rac1 Properties:
InitialConnectIdentifier = 'rac'
ObserverConnectIdentifier =''
LogXptMode = 'async'
Dependency =''
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '000000'
NetTimeout = '000000'
LogShipping = 'on'
PreferredApplyInstance =''
ApplyInstanceTimeout = '0'
ApplyParallel = 'auto'
StandbyFileManagement = 'auto'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '5'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+ DATA/rac,/u01/app/oracle/oradata/orcl'
LogFileNameConvert = '+ FLASH/rac,/u01/app/oracle/flash_recover_area/orcl, + DATA/rac, /U01/app/oracle/oradata/orcl'
FastStartFailoverTarget =''
StatusReport = '(monitor )'
InconsistentProperties = '(monitor )'
InconsistentLogXptProps = '(monitor )'
SendQEntries = '(monitor )'
LogXptStatus = '(monitor )'
RecvQEntries = '(monitor )'
HostName (*)
SidName (*)
LocalListenerAddress (*)
StandbyArchiveLocation (*)
AlternateLocation (*)
LogArchiveTrace (*)
LogArchiveFormat (*)
LatestLog (*)
TopWaitEvents (*)
(*)-Please check specific instance for the property value Current status for "rac ":
DISABLED |
