Saturday, June 02, 2018

RMAN-06023: no backup or copy of datafile found to restore

Symptom:

 We took backup and catalog backupset in the DB, We try to restore backup on rman. Error out with
RMAN-06023: no backup or copy of datafile 23 found to restore

Reasons:

  The backupset is in place in controlfile, however due to source db was open resetlogs. It is with different incarnation.  We need to make sure the target DB has the same incarnation

Solution:

rman>list incarnation;
rman>reset database to incarnation XXX ;   ( same in carnation of source DB)
rman>restore database from tag 'XXX';

No comments: