Re: Data guard physical standby
- From: Nassyam Basha <nassyambasha@xxxxxxxxx>
- To: Tiran Harutyunyan <mufc01666@xxxxxxxxx>
- Date: Thu, 6 Feb 2014 21:06:30 +0530
Hi Tiran,
It looks me that there is no archive sequence of number 4279 and where
standby is requesting for the recovery.
You basically have to check whether 4279 and later sequences is available
or not, Also it is belongs to thread 2 and you need to have ensure the
sequences available of thread 1 as well.
If in case there are no archives, backup of archives available then you
have only option to use incremental rollforward to perform the recovery
below is URL.
http://www.oracle-ckpt.com/rman-incremental-backups-to-roll-forward-a-physical-standby-database-2/
Am not sure what is the version you are using, If 12c then you can use cool
feature :)
RMAN> Recover database from service "net service of primary" using backupset
;
Hope this helps.
Thank you,
Nassyam Basha.
On Thu, Feb 6, 2014 at 8:03 PM, Outsider <mufc01666@xxxxxxxxx> wrote:
> Dear all,
>
> I want to create Data guard physical standby but some of archive log are
> deleted from primary so my active database duplication failing. I tried to
> restore from backup but I can't....
>
> log from duplication
> --------------------------------------------------------------------
> unable to find archived log
> archived log thread=2 sequence=4279
> Oracle Error:
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> below
> ORA-01152: file 1 was not restored from a sufficiently old backup
> ORA-01110: data file 1: '+DATA/tosprddgd/datafile/system.312.838742663'
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of Duplicate Db command at 02/06/2014 13:09:09
> RMAN-05501: aborting duplication of target database
> RMAN-03015: error occurred in stored script Memory Script
> RMAN-06054: media recovery requesting unknown archived log for thread 2
> with sequence 4279 and starting SCN of 216548454
> --------------------------------------------------------------------------
> is there any workaround , please help.
>
> thanks
>
> *-----------------*
> *Tiran*
>
> *Best Regards Stay in touch...*
>
--
Thanks & Regards,
Nassyam Basha.
www.oracle-ckpt.com
Other related posts:
