Re: RMAN Backup Duplicate Not Finding Archive Log

I'm not sure what you are showing us here.. RMAN is looking for archived log thread=2 sequence=89020 in file annnf0_arclogs_disk_0.5071.947271611. You've shown that archivelog sequence=97159 exists in file annnf0_arclogs_disk_0.10243.947271611, but that's neither the sequence that RMAN needs, nor the file it thinks it should be in..

     wanted: annnf0_arclogs_disk_0.*_5071_*.947271611

     we have: annnf0_arclogs_disk_0._*10243*_.947271611

I don't see where the log sequence 97159 comes from? What do you get on " list backup of archivelog sequence=89020 " ?

When you look in ASM with asmcmd, can you see the file?

     ASMCMD> ls -l +FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611

Cheers,
Tony

On 24/06/17 01:57, David Barbour wrote:
> Good Morning,
>
> This is Oracle 12.1.0.2 on RHEL 6.7.
>
> I'm trying to duplicate a database from backup. The restore completes but the recovery fails locating the archive log(s).
>
> The log shows:
>
> channel d1: starting archived log restore to default destination
> channel d1: restoring archived log
> archived log thread=2 sequence=89020
> channel d1: reading from backup piece +FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611
> channel d1: ORA-19870: error while restoring backup piece +FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611
> ORA-19505: failed to identify file "+FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611"
> ORA-17503: ksfdopn:2 Failed to open file +FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611
> ORA-15012: ASM file '+FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611' does not exis
>
> But RMAN has the log:
>
> RMAN> list backup of archivelog sequence=97159;
>
>
> List of Backup Sets
> ===================
>
>
> BS Key Size Device Type Elapsed Time Completion Time
> ------- ---------- ----------- ------------ --------------------
> 55243 367.62M DISK 00:00:29 21-JUN-2017 19:00:40
> BP Key: 55257 Status: AVAILABLE Compressed: YES Tag: ARCLOGS_DISK
> Piece Name: +FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.10243.947271611
>
> List of Archived Logs in backup set 55243
> Thrd Seq Low SCN Low Time Next SCN Next Time
> ---- ------- ---------- -------------------- ---------- ---------
> 1 97159 127632024461 20-JUN-2017 19:52:23 127635182471 21-JUN-2017 03:13:30
>
> NLS_DATE_FORMAT is set:
> PRDREP1_at_node1:/home/oracle/scripts/restore $ env |grep DATE
> NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS
>
> When I run the command with debug the disk channel finds work, e.g.:
> krmqgns: looking for work for channel clone_default (krmqgns)
> DBGRPC: krmqgns: commands remaining to be executed: (krmqgns)
> DBGRPC: CMD type=restoring and applying logs cmdid=1 status=NOT STARTED
> DBGRPC: 1 STEPstepid=2 cmdid=1 status=STARTED devtype=DISK step is for clone channel bs.stamp=947271692 step_size=616530944 Bytes
>
> But it fails without any better description:
> DBGRPC: krmxpoq - returning rpc_number: 28 with status: FINISHED40 for channel d1
> DBGRPC: krmxr - channel d1 calling peicnt
> DBGRPC: krmxrpc - channel d1 kpurpc2 err=19624 db=target proc=SYS.DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE excl: 512
> DBGRPC: krmxrpc - caloing krmxtrim: with message of length 512: _at__at__at_ORA-19624: operation failed, retry possible
> DBGRPC: ORA-19870: error while restoring backup piece +FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611
> DBGRPC: ORA-19505: failed to identify file "+FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611"
> DBGRPC: ORA-17503: ksfdopn:2 Failed to open file +FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611
> DBGRPC: ORA-15012: ASM file '+FRA/ORCL/BACKUPSET/2017_06_21/annnf0_arclogs_disk_0.5071.947271611' does not exist
> DBGRPC: ORA-06512: at "SYS.X$DBMS_BACKUP_RE_at__at_@
>
> Why is it failing to open the file? Any ideas?
>
>

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