Re: Datagueard Incremental Restore.
From: jason arneil <jason.arneil_at_gmail.com>
Date: Thu, 11 Jun 2009 16:51:12 +0100
Message-ID: <fda4898f0906110851k40e7d3f7pc06dafac98d6d427_at_mail.gmail.com>
Hi Martin,
Date: Thu, 11 Jun 2009 16:51:12 +0100
Message-ID: <fda4898f0906110851k40e7d3f7pc06dafac98d6d427_at_mail.gmail.com>
Hi Martin,
Have you applied your incremental backup to your standby?
You need to recreate the standby controlfile as the incremental backup does not update what scn the standby controlfile is at. I've documented this here:
http://jarneil.wordpress.com/2008/06/03/applying-an-incremental-backup-to-a-physical-standby/
cheers,
jason.
-- http://jarneil.wordpress.com 2009/6/11 Martin Brown <martinfbrown_at_hotmail.com>:Received on Thu Jun 11 2009 - 10:51:12 CDT
> 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.
-- http://www.freelists.org/webpage/oracle-l