ORA-19612 Error Trying To Duplicate Database With Rman
(Doc ID 1361914.1)
Last updated on APRIL 21, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [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.
To be able to DUPLICATE a database, 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-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:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!