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
this post really helpful. thanks for sharing.
ReplyDeleteoceanapart technologies - databackup & transfer
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.
ReplyDeleteoracle 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