[go: up one dir, main page]
Scribd
Upload
30 views2 pages

DR Fail Over in Oracle

Dr fail

Uploaded by

egfoundationindia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
30 views2 pages

DR Fail Over in Oracle

Dr fail

Uploaded by

egfoundationindia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

********* Data Guard Broker Failover *********

A failover is when you have lost primary database. It’s very simple to perform
failover using data guard broker.

*** ***Crash Primary Database (Simulate) *** ***

Let us simulate failure. We will kill the PMON process at OS level on primary

********** Failover to Standby *** *******

Connect to standby database proddb_st (as primary crashed or not available) and failover
to standby proddb_st
********** Rebuild Primary After Failover **********

Post failover, there are two methods of rebuilding your failed primary

Method 1: Rebuild from scratch –> RMAN duplicate

Method 2: Flashback database –> only if Flashback was enabled


Reinstate failed primary: When you use data guard broker, with just one command,
the primary can be rebuilt. Start the failed primary server, in this case start proddb
server

Verify proddb post reinstate: The best part is broker will automatically
recover earlier failed primary proddb, mount the database and start
MRP too

Switchover to get original configuration: At this stage, you can perform switchover to again
get back original configuration

You might also like