RE: Dataguard Incremental Restore.

From: Asif Momen <asif_oracle_at_yahoo.com>
Date: Thu, 11 Jun 2009 21:43:14 -0700 (PDT)
Message-ID: <953075.45130.qm_at_web56605.mail.re3.yahoo.com>



Hi Martin,

I faced this issue sometime back and thought on blogging (it is still in the pipe).

One critical step is missing from the document. You need create a new standby controlfile on the primary and replace the existing standby controlfile (at the Standby side) with the new one. That's it and you are done.

Regards

Asif Momen
http://momendba.blogspot.com

  • On Thu, 6/11/09, Martin Brown <martinfbrown_at_hotmail.com> wrote:

From: Martin Brown <martinfbrown_at_hotmail.com> Subject: RE: Dataguard Incremental Restore. To: oracle-l_at_freelists.org
Date: Thursday, June 11, 2009, 7:59 AM

#yiv165320913 .hmmessage P { margin:0px;padding:0px;} #yiv165320913 { font-size:10pt;font-family:Verdana;}  Sorry, I meant to say that I/m using the SCN from my production system minus a couple thousand. From: martinfbrown_at_hotmail.com
To: oracle-l_at_freelists.org
Subject: Datagueard Incremental Restore. Date: Thu, 11 Jun 2009 10:53:48 -0400

#yiv165320913 .ExternalClass .EC_hmmessage P {padding:0px;} #yiv165320913 .ExternalClass body.EC_hmmessage {font-size:10pt;font-family:Verdana;} I'm trying to complete an incremental restore on one of my physical standby databases. I'm following: http://www.filibeto.org/sun/lib/nonsun/oracle/10.2.0.1.0/B19306_01/backup.102/b14191/rcmdupdb007.htm  
My understanding was to get a SCN from my standby and run the incremental backup from my primary a couple thousand SCN's prior to what the current scn is in the standby. I keep getting "datafile 1 must be restored". I know what that usually means, but in this case, I don't see the relavence. Datafile1 should be current past the SCN number I am using. Am I misreading or misunderstanding the proceedure? Anyone else use this method?  
Thanks for your time.
Martin

Insert movie times and more without leaving Hotmail®. See how. Lauren found her dream laptop. Find the PC that’s right for you.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 11 2009 - 23:43:14 CDT

Original text of this message