RE: Recovering primary DB

No, no flashback set up in this environment. We may consider it for the future, but that won't help us now.

I looked at the documentation a bit but was not able to find that - do you happen to have a link for it? The more official-looking an answer I can get, the better off I am with management...

Thanks!

Stephan Uzzell

-----Original Message-----
From: Laimutis.Nedzinskas_at_seb.lt [mailto:Laimutis.Nedzinskas_at_seb.lt] Sent: Tuesday, 26 July, 2011 11:44
To: Uzzell, Stephan
Subject: Re: Recovering primary DB

do you have flashback swichted on ?

else, according to what we did with standby backups and oracle documentation that is doable.

Please consider the environment before printing this e-mail

                                                                                                                                                   
  From:       "Uzzell, Stephan" <SUzzell_at_MICROS.COM>                                                                                               
                                                                                                                                                   
  To:         "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>                                                                                    
                                                                                                                                                   
  Date:       2011.07.26 18:24                                                                                                                     
                                                                                                                                                   
  Subject:    Recovering primary DB                                                                                                                
                                                                                                                                                   

Hi listers,

Looking for a quick confirmation here - I think this should be possible, but like to confirm it before I start down this route.

We had a SAN failure on a primary DB (10.2.0.3 RAC). Failed over to (physical) standby as the quickest way to get the system going again. Looking at the backup history of the primary, the most recent full backup is several days ago. The bandwidth between the two datacenters where primary and standby reside is - well, transferring a full backup of standby to primary might well take 96 hours or so.

I'm hoping to do the following as a way to get the system back to its normal state:
1) Restore the full backup of primary now that the SAN issue has been resolved.
2) Take an incremental backup of standby (which is now running as primary) and use that to recover primary - obviously there are transactions occurring in standby now that would need to be applied to primary before we could switch back.
3) Switch back

I can't imagine any reason this wouldn't work, but I've never tried in this direction before. Applying incremental backups of primary to standby is something I've had to do more times than I like to think about - so I'm familiar with the process.

Can someone confirm this will work? Any caveats?

Thanks!

Stephan Uzzell

--
http://www.freelists.org/webpage/oracle-l