ORA-01139: RESETLOGS option only valid after an incomplete database recovery
Cause:
After database restore , i was trying to open the database using resetlogs. Then i got the error below.
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 08/05/2021 23:29:21
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
Workaround:
As i have not performed an incomplete recovery because i have the latest controlfile and no transactions were updated before the restore. If you are able to mount the database without restore of controlfile, then you perform complete recovery without scn reset. So issue only open
RMAN> alter database open ;
Statement processed
Check the database incarnation
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL19X 4048647388 PARENT 1594143 05-DEC-20
2 2 ORCL19X 4048647388 PARENT 9733094 27-DEC-20
3 3 ORCL19X 4048647388 PARENT 23503444 28-JUL-21
4 4 ORCL19X 4048647388 PARENT 23504617 29-JUL-21
5 5 ORCL19X 4048647388 PARENT 23504618 29-JUL-21
6 6 ORCL19X 4048647388 PARENT 23630256 30-JUL-21
7 7 ORCL19X 4048647388 PARENT 23631057 30-JUL-21
8 8 ORCL19X 4048647388 PARENT 23632427 30-JUL-21
9 9 ORCL19X 4048647388 PARENT 23633218 30-JUL-21
10 10 ORCL19X 4048647388 PARENT 23633219 30-JUL-21
11 11 ORCL19X 4048647388 PARENT 23633220 30-JUL-21
12 12 ORCL19X 4048647388 CURRENT 23633221 31-JUL-21