Process#
After starting the instance with parameters, restore the control file, bring the database to the mount state, and register backup files with the catalog starting with xx.
Phenomenon#
After executing "catalog start with xx", the alert log shows the following information:
Thu May 14 11:18:24 2020
Setting recovery target incarnation to 2
Setting recovery target incarnation to 2
Error validating file dummy (14) in piece xxx: missing header
Expanded controlfile section 14 from 245 to 490 records
Requested to grow by 245 records; added 3 blocks of records
After executing the restore script, the following errors occur and the process exits:
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+DATA/xxxx/datafile/system01.dbf'
Resolution Process#
Check the incarnation in RMAN:
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- ------ ------------------ ----------
1 1 ORCL 1446008355 PARENT 1 2014/12/26 14:31:00
2 2 ORCL 1446008355 CURRENT 17034938503292 2020/05/09 17:34:36
Reset the incarnation to 1:
RMAN> reset database to incarnation 1;
database reset to incarnation 1
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- ------ ------------------ ----------
1 1 ORCL 1446008355 CURRENT 1 2014/12/26 14:31:00
2 2 ORCL 1446008355 ORPHAN 17034938503292 2020/05/09 17:34:36
Observe the alert log:
Thu May 14 11:21:28 2020
Setting recovery target incarnation to 1
Execute the restore script, and the restore is successful.