RE: Dataguard Incremental Restore.
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