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
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