Friday, January 23, 2015

RMAN DUPLICATE: Errors In Krbm_getDupCopy found in alert.log

Issue.

Executing active duplicate for standby:
duplicate target database for standby from active database ...

In the alert.log appear messages like this:
RMAN DUPLICATE: Errors in krbm_getDupCopy
Errors in file /u02/app/oracle/diag/rdbms/odocdr/odOCDR/trace/odOCDR_ora_27666.trc:
ORA-19625: error identifying file +DATA/orcl/datafile/users_ts.895.787168577
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/datafile/users_ts.895.787168577
ORA-15012: ASM file '+DATA/orcl/datafile/users_ts.895.7871685777' does not exist
 
Solution:
 
As files have already been deleted from auxiliary destination, ignore those messages.

When the files already copied can be used by next duplicate trial then don't remove the files. If you don't delete the files after a failed duplicate then krbm_getDupCopy will find the files and you will see no errors.

If you don't want to see those messages in alert.log but datafiles have already been deleted, on
Auxiliary host, delete the file $ORACLE_HOME/dbs/_rm_dup_<dup_db>.dat  where dup_db is the name of the clone instance.

Inside this file rman finds the name of the datafiles already copied to auxiliary host.