Re: Data guard physical standby

May be the duplicate is returned errors because auxiliary neeeds sequence 4279, But if you have already configured all DataGuard parameters then it should fix by itself by fetching required archives from primary database(Based on FAL settings & Service name from primary and other parameters as well) and you no need to create standby again and again. may be you spent additional time to do duplicate again.

Regarding your question on expire archive log, i believe that archive log may be not accessible or physically not exist, If you are sure the archvie log sequence is not available and then you should see them from output of(delete expired archivelog all) as you are already ran crosscheck. After you run "delete expired archivelog" you need to ensure that it is not showing any more and you can also take a look on how to use force/noprompt options to delete in such cases.

Thank you
Nassyam Basha

On Fri, Feb 7, 2014 at 5:21 PM, Outsider <mufc01666_at_gmail.com> wrote:

> 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 Regards Stay 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
>>
>
>

-- 
Thanks & Regards,
Nassyam Basha.
www.oracle-ckpt.com

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