Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Graceful Switchover

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-05-2011, 09:05 AM
melissaf melissaf is offline
Junior Member
 
Join Date: Dec 2011
Posts: 1
Default Flashback Database and Graceful Switchover

We are using Oracle 11.2.0.2.2 with DBVisit 5.3.04.5045, and are looking to establish our second standby database to aid with a cutover to a new server.

Currently we have dbvisit configured and working between the primary (A) and the secondary (B). Upon implementing our second standby database (C) we will be synching between A -> B and A-> C.

For the Cutover, we are wanting to perform a graceful switch over from A to C using the following plan:
  • Ensure A,B,C all are at the same SCN
  • Stop all DBVisit Scheduled jobs
  • Perform a shutdown on Standby database B
  • Create a guaranteed restore point on Primary Database A
  • Perform a Graceful Switchover from A to C (now C is the Primary, A Standby )
  • Copy the DDC file from Standby B to Primary C and edit the SOURCE variable to reflect we are now running on Primary Database C
  • Cutover Application to Primary Database C
  • Restart all DBVisit Scheduled jobs

As a back out plan (ie C doesn't work), then the plan is to:
  • Flashback Primary Database A to the guaranteed restore point
  • Startup Standby Database B
  • Restart DBVisit Sync between primary A and secondary B

We understand that this will leave C in a state of requiring to be rebuilt.

Now the question is:

The manual (http://docs.oracle.com/cd/E11882_01/...b.htm#CFHFIBGH) states that one of the limitations of Flashback database is:
If the database control file is restored from backup or re-created, all accumulated flashback log information is discarded. You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file.
When performing the initial Graceful Switchover from A to C... will it leave the database control file in such a state that FLASHBACK DATABASE back to the guaranteed restore point can still be used?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 09:33 AM.