RMAN Backup as Copy - Active Duplicate

  • From: David Barbour <david.barbour1@xxxxxxxxx>
  • To: oracle-l mailing list <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 27 Mar 2015 12:46:52 -0500

Oracle 11gR2 on Linux 6.4 using ASM

I'm missing something ......

Performing an active duplicate of our production database.  We changed the
archive log destination on the test system to use the FRA rather than the
specific duplexed archive log destinations on production.

All the datafiles are copied, and MOST of the archivelogs.  The duplicate
log is reporting:

channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=29639
channel ORA_AUX_DISK_1: reading from backup piece
+P00FRA/p00/backupset/p00xxxxx_1469727213_875440811_s115685_p1_c1
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece
+P00FRA/p00/backupset/p00xxxxx_1469727213_875440811_s115685_p1_c1
ORA-19505: failed to identify file
"+P00FRA/p00/backupset/p00xxxxx_1469727213_875440811_s115685_p1_c1"
ORA-17503: ksfdopn:2 Failed to open file
+P00FRA/p00/backupset/p00xxxxx_1469727213_875440811_s115685_p1_c1
ORA-15001: diskgroup "P00FRA" does not exist or is not mounted
ORA-15001: diskgroup "P00FRA" does not exist or is not mounte
failover to previous backup

During the duplicate process, a couple of archivelog bacups were made to
disk on the production system to +P00FRA/p00/backupset/

Those files are on the +P00FRA diskgroup.

Additionally, the archivelogs the duplicate is looking to find have not
been deleted from the archivelog destination.  So I figured I'd just copy
them over.  But regardless of how I do it, I get a 'skipping backup' as
follows:

RMAN> backup as copy reuse archivelog like
"+P00ARCH01/p00/archivelog/2015_03_27/thread_1_seq_29639.509.875426153"
2> auxiliary format "+S00FRA";

Starting backup at 27-MAR-15 12:33:32
using channel ORA_DISK_1
skipping archived log of thread 1 with sequence 29639; already backed up
Finished backup at 27-MAR-15 12:33:32

I reset the parameter CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE
DISK but still get the error.

Any ideas?

Other related posts: