RE: Recover Primary DB from Standby DB

2002-01-07 Thread Jack C. Applewhite
Jeremiah, Thanks for the info. It's nice not to be an idiot! ;-) ...and so much easier to copy up-to-date datafiles from the Standby than to restore from tape backup in the event of a disk failure on the Primary. We'll use our Standby only in the event of a failure more catastrophic than a

RE: Recover Primary DB from Standby DB

2002-01-05 Thread Rachel Carmichael
--- Jeremiah Wilton [EMAIL PROTECTED] wrote: If you perform graceful failover, A.K.A. role reversal, you can have the former primary pick up as the standby immediately after failover without recopying. I cover this topic in my Openworld paper on my site. the problem is, you usually

RE: Recover Primary DB from Standby DB

2002-01-05 Thread Kimberly Smith
Actually, even something like Hp's ServiceGuard is not so graceful, depending on the app using the database. I have had a database fail and know one know and a different database fail and everyone know. You really have to take into account with the app that it might lose connection. You need

Recover Primary DB from Standby DB

2002-01-04 Thread Jack C. Applewhite
Am I an Idiot? I've maintained a Managed Standby database (8.1.6 under Win2k) for a year now. We've now moved to new servers (8.1.7.2.5 under Win2k) and will again have both Primary (Production) and Managed Standby databases. In planning a new backup stragegy, it occurs to me (why not ever

RE: Recover Primary DB from Standby DB

2002-01-04 Thread Martin Kendall
Hi Jack, I don't think that you really want to use the online redo logs in this scenario. The problem is that the SCN at the exact time of failure may be different on the Standby and therefore the Primary DB's Control File will not be correct for the given Datafiles being copied over from the

RE: Recover Primary DB from Standby DB

2002-01-04 Thread Grabowy, Chris
: rofit.com Subject: Recover Primary DB from Standby DB Sent by: [EMAIL PROTECTED] 01/04/02 07:30 AM Please respond to ORACLE-L Am I