« How to Synchronize the Standby When there is a Big gap, and all Required Archived Logs are Lost | Main | Oracle Open World Call for Papers »

How To Manually Open The Standby Database When The Primary Is Lost

This post explains how to manually convert the Physical Standby into the Primary database, when the Primary is not available anymore.

The procedure is very simple, still is convenient to have it available so that in the stress situation of a production crash we can implement it without problems.

Personally I prefer to work harder at the implementation stage and build an infrastructure strong enough to be configured using DG Broker, Observer and Fast Start Failover.

Step by Step details of manually converting the standby into the new primary can be found on this file How to open the standby when the primary is lost

TrackBack

TrackBack URL for this entry:
http://blogs.oracle.com/mte1521/mt-tb.cgi/9838

Comments (1)

Pavan:

Hello Alejandro,

This doc is really helpful. Its absolutely a good work.

I have a question here..

Is there any way to take the backup and recover the standby database with diffrence of two scn's. It would be great if this works.


Please let us know if this is possible


Regards,
Pavan

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on February 4, 2009 5:33 AM.

The previous post in this blog was How to Synchronize the Standby When there is a Big gap, and all Required Archived Logs are Lost .

The next post in this blog is Oracle Open World Call for Papers.

Many more can be found on the main index page or by looking through the archives.

Top Tags

Powered by
Movable Type and Oracle