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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s