My Oracle Support Banner

ORA-19612 Error Trying To Duplicate Database With Rman (Doc ID 1361914.1)

Last updated on JANUARY 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 to 12.1.0.2 [Release 9.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

To be able to DUPLICATE a database from BACKUSETS, the backuppieces generated by RMAN backup must be available on destination server where the AUXILIARY database will be created

After the backupsets are transferred to destination, RMAN duplicate fails on:


RMAN-03002: failure of Duplicate Db command at 09/23/2011 07:00:51
RMAN-03015: error occurred in stored script Memory Script
ORA-19612: datafile XX not restored due to missing or corrupt data



The alert.log file from the auxiliary DB shows some errors while duplicate is in process:

Fri Sep 23 05:12:29 2011
corrupt block 54613 found during reading backup piece,file=/export/oradata/PSMP_db_ijmn14s2_203_1, corr_type=2
Reread of blocknum=54613, file=/export/oradata/PSMP_db_ijmn14s2_203_1. found different data
corrupt block 54614 found during reading backup piece,file=/export/oradata/PSMP_db_ijmn14s2_203_1, corr_type=-2
Reread of blocknum=54614, file=/export/oradata/PSMP_db_ijmn14s2_203_1, found same data
...



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.