| Oracle 9i Database Failover [message #246000] |
Tue, 19 June 2007 09:34  |
kaustubh
Messages: 26
Registered: June 2007
|
Junior Member |
|
|
Hi,
We have a Primary and Physical Standby Oracle Databases. We need to understand the exact scenarios when Data Guard Failover should be used.
I did some search on web and following is the brief info I got:
Data Guard Failover should be used only when:
1) Switchover is not possible
2) Site disasters
3) Data Failures.
Could please give me more details on when the Data Guard Failover should be used?
Also let me the exact commands that should be used to perform a Data Guard Failover.
Thanks and regards,
Kaustubh Kane.
|
|
|
|
| Re: Oracle 9i Database Failover [message #246013 is a reply to message #246000] |
Tue, 19 June 2007 10:17  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | ROLE TRANSITION
In Dataguard configuration, two roles are defined; Primary and Standby. Primary database is the production database which is used by the users. For high availability purpose, the dataguard provides a standby database which remains available side by side to the primary database. Standby databases can be more than one and can be at remote locations as well.
Oracle Data Guard supports two role transition operations:
Switchover:
Switchover allows the primary database to switch roles with one of its standby databases. There is no data loss during a switchover. After a switchover, each database continues to participate in the Data Guard configuration with its new role.
Failover:
Failover transitions a standby database to the primary role in response to a primary database failure. If the primary database was not operating in either maximum protection mode or maximum availability mode before the failure, some data loss may occur. After a failover, the failed database no longer participates in the Data Guard configuration. It needs to be reinstated to become an active part of Data Guard configuration.
|
Hope Attached document would help you in FAILOVER and SWITCHOVER.
|
|
|
|
| Re: Oracle 9i Database Failover [message #246046 is a reply to message #246013] |
Tue, 19 June 2007 11:33 |
kaustubh
Messages: 26
Registered: June 2007
|
Junior Member |
|
|
Hi,
Thanks for the quick reply.
We perform the Failover if the switchover could not be performed.
Failover will also be required in case of Primary database failure as you suggested. How should we check for the Primary Database failure?
In this case we will need a continous monitor to be running which checks the Primary Database and if failure is detected then Failover is performed.
We need to know what kind of checks should we perform to check the Primary Database?
Thanks and regards,
Kaustubh Kane
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
