| Monu |
Posted: Mar 08, 2008 12:39:25 PM |
Total Post: 26
Joined: Jan, 2008
|
Could you please tell me the steps to switchover to standby database once your primary database fails in Oracle 9i Release 9.2.0.1.0.
Thank you.....
|
|
|
 Mohammed Taj |
| Posted: Mar 10, 2008 02:34:06 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/role_management.htm#i1033702
|
|
|
|
|
| MOH_DBA |
| Posted: Aug 30, 2008 03:04:56 AM | |
|
Total Post: 161
Joined: Nov, 2007
|
You Can Use Dataguard Broker, but you must set it's parameter in the dataguard databases.
dgmgrl
DGMGRL> connect sys/Not4U
DGMGRL> create configuration 'MyDR' as
>primary database is 'Orlando'
>connect identifier is Orlando_hasun1;
DGMGRL> show configuration
DGMGRL> add database 'Nashville' as
>connect identifier is Nashville_hasun2
>maintained as physical;
DGMGRL> enable configuration;
DGMGRL> show configuration;
Configuration
Name: MyDR
Enabled: YES
Protection Mode: MaxPerformance
Databases:
Orlando - Primary database
Nashville - Physical standby database
Current status for "DRSolution":
SUCCESS
DGMGRL> edit database 'Nashville' set state='READ-ONLY';
Succeeded.
DGMGRL> EDIT DATABASE 'Nashville' SET STATE='ONLINE';
Succeeded.
DGMGRL> SWITCHOVER TO "Nashville";
Switchover succeeded. New primary is "Nashville"
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
