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@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:
@@@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@@@
Why is it failing to open the file? Any ideas?