Re: Data guard physical standby

From: Outsider <mufc01666_at_gmail.com>
Date: Fri, 7 Feb 2014 12:51:15 +0100
Message-ID: <CAO6u0Xb9-NZxsmz2JAJmQOxRup6QYr_VF6XFhbRsQeqwgeTgDw_at_mail.gmail.com>

Thanks guys for help, I fixed it by re creating the standby database, active db duplication, before that I did crosscheck archive logs and delete the expired.
The interesting thing which I did't understood , why after each time running command *backup archivelog all; *it found only one expired log and like this 55 times , so I had to run command in this order a lot of time.

*backup archivelog all;*
*crosscheck archivelog  all;*
*delete expired archivelog all;*

Every time I found and can delete only one log which is requested for backup but not found.
And finally my backup works and after that I can do duplication.....

*-----------------*

*Tiran*

*Best RegardsStay in touch...*

On 6 February 2014 16:36, Nassyam Basha <nassyambasha_at_gmail.com> wrote:

> 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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 07 2014 - 12:51:15 CET