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';

1 comment:

Anonymous said...

Caesars Casino Incheon - Ground has not been damaged on the planned $739 million built-in resort and on line casino. In addition to gaming amenities, three lodge towers will feature 1,350 luxurious rooms and suites. A Paramount Studios theme park and an ecology-themed adventure park are also planned along with a 15,000-seat arena, the most important live event venue in South Korea. Retail shops will occupy 20,000 sq m along with 20 food and beverage 카지노 사이트 shops. There may even be 4,500 sq m of house devoted to Korean cosmetics and beauty. Gambling has been one of many fastest-growing industries in any nation the place it is allowed, each on-line and offline.