| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recover Primary DB from Standby DB
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 disk or two.
BTW, I finally found mention in the docs that Oracle sanctions using datafiles from the Standby to recover the Primary database. It's the very last bullet point in the section "Additions to Compatibility and Operational Requirements" in chapter 12 ("Standby Database") of "Oracle8i Documentation Addendum Release 3 (8.1.7)". It's not mentioned in the "Compatibility and Operational Requirements" in chapter 1 ("Standby Database Concepts") in the 8.1.6 Standby docs.
Jack
-----Original Message-----
Wilton
Sent: Friday, January 04, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L
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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: japplewhite_at_inetprofit.com 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).Received on Mon Jan 07 2002 - 16:41:23 CST
 |
 |