Wednesday, December 4, 2019

How to find when we opened the database in resetlog mode?

we can check it using the below 3 method.

1.using alert_SID.log search the date of "alter database open resetlog " issued date
2.using rman.

RMAN> LIST INCARNATION;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TESTDB1 1740129829       PARENT  1          17-MAY-11
2       2       TESTDB1 1740129829       CURRENT 1572286395 11-APR-19

3.using rman

1* select * from v$database_incarnation
SQL> /

INCARNATION# RESETLOGS_CHANGE# RESETLOGS PRIOR_RESETLOGS_CHANGE# PRIOR_RES STATUS  RESETLOGS_ID PRIOR_INCARNATION# FLASHBACK_DATABASE_ALLOWED
------------ ----------------- --------- ----------------------- --------- ------- ------------ ------------------ --------------------------
           1                 1 17-MAY-11                       0           PARENT     751390373                  0 NO

           2        1.5723E+13 11-APR-19                       1 17-MAY-11 CURRENT   1005338426                  1 NO

2 comments:

  1. Good post and informative. Thank you very much for sharing this good article, it was so good to read and useful to improve my knowledge as updated, keep blogging. Thank you for sharing wonderful information with us to get some idea about that content.
    oracle training in chennai

    oracle training institute in chennai

    oracle training in bangalore

    oracle training in hyderabad

    oracle training

    oracle online training

    hadoop training in chennai

    hadoop training in bangalore

    ReplyDelete