RMAN Backup Duplicate Not Finding Archive Log
Date: Fri, 23 Jun 2017 10:57:34 -0500
Message-ID: <CAFH+ifdoVqme5g1K+bv7VcxY2vk0hcB+ys2B8vW8rqjJU2c3qg_at_mail.gmail.com>
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=DISKstep 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-lReceived on Fri Jun 23 2017 - 17:57:34 CEST