RE: Recover Primary DB from Standby DB

There is no problem with using the standby as a source of good files in the event a file on the primary becomes media corrupt. Once stopped, you can use a standby just like a good backup of the database. The primary will not reject the file. This is particularly useful for single tablespace complete recoveries.

It is not advisable to use the standby as the *only* backup of a database. If you discover that for whatever reason you need to recover to a point in time prior to the standby, you will have to restore from a prior physical backup and roll forward.

On another topic:

On Fri, 4 Jan 2002, Grabowy, Chris wrote:

> Errr...what's the point in having a standby database then? If you
> have a media failure then you fail over to your standby database,
> and your up. Once the standby database comes up then you will have
> to rebuild the old primary database from the old standby anyway,
> since you now have all these new transactions hitting the old
> standby server.

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.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton


---- Original message ----


> From: Jack C. Applewhite

>

> 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

> before?)  that I should be able to use the datafiles of my Standby

> DB (along with the Primary's archived and online redo logs) to

> recover my Primary DB in the event of media failure.

>

> In the event of a drive failure on the Primary server, shouldn't I

> be able to shutdown the Standby DB and copy it's relevant datafiles

> to the Primary, then use the Primary's archived and online redo logs

> to recover those datafiles to the point of drive failure?

>

> It makes sense to me, but nowhere in the docs have I found mention

> that this is an appropriate action.  Am I missing something?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).