Recover a database using RMAN but failing to open redo


When using RMAN to restore and recover the database, it seems to work OK - no obvious errors during the restore / recovery, as far as I can see. The issue seems to be when I try to 'alter database open resetlogs'... after this the database shuts down. At this point, I don't really care about losing some of our data, this is just a test system, my main concern is how to get the database working again.

Oracle version 12.1.0.

1. I startup with nomount.

RMAN> startup nomount;

2. I restore the control file using the only one I have for SBID 2565339011, which is an old one.

RMAN> restore controlfile from '/oracle/oradata/FRA/ctl_file_2565339011_2015-07-01_tdqatvvk_1_1';

3. I then mount the database.

RMAN> alter database mount;

4. Now I restore the database - which finds the backup piece.

RMAN> restore database;
channel ORA_DISK_1: piece handle=/oracle/oradata/FRA/db_full_2565339011_2015-07-01_t7qatupl_1_1 tag=TAG20150701T030004
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:07:16
Finished restore at 20200219 113311

5. I then recover the database using the sequence number - which tells me its completed.


archived log file name=/u01/app/oracle/product/12.1.0/dbs/arch1_3885_864658371.dbf thread=1 sequence=3885
media recovery complete, elapsed time: 00:00:02
Finished recover at 20200219 111222

6. I now shutdown the database and open reset logs - which fails straight after.

shut immediate;
startup mount;

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-03114: not connected to ORACLE
RMAN-03002: failure of sql statement command
ORA-03114: not connected to ORACLE
BHAUSDEV01:aims:/home/aims >

I see errors like the below in alert log...

RESETLOGS after incomplete recovery UNTIL CHANGE 7834041545

ARCH: Logfile 1 is wrong incarnation (1:3539094264:02/19/2020 10:09:33 vs 0:1:11/26/2014 14:52:51)
ARCH: Logfile 2 is wrong incarnation (1:3539094264:02/19/2020 10:09:33 vs 0:1:11/26/2014 14:52:51)
Read of datafile '/oracle/oradata/test/temp01.dbf' (fno 81) header failed with ORA-01203
ORA-01186: file 81 failed verification tests
ORA-01122: database file 81 failed verification check
ORA-01110: data file 81: '/oracle/oradata/test/temp01.dbf'
ORA-01203: wrong incarnation of this file - wrong creation SCN

I only have one incarnation.

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 TEST 2565339011 CURRENT 1 20141126 145251


Any ideas on what I can do / check to recover my database?