Re: RMAN Backup as Copy - Active Duplicate

Are you sure the archive log is registered with the production control file?

LIST ARCHIVELOG SEQUENCE 29639 THREAD 1; Seth Miller

On Fri, Mar 27, 2015 at 12:46 PM, David Barbour <david.barbour1_at_gmail.com> wrote:

> 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?
>

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