Monday, September 20, 2010

Find the last recovery time/date of the Oracle database when "resetlogs" option was used to open the database (or when incarnation took place)?


Have you ever been asked when was the database restored/reopened (with resetlog options)? It is a simple thing but sometimes a time consuming task especially if you are not very familiar with Oracle DBA dictionary or if you are a Jr. DBAs. Well, the answer can be found here. Hope this comes handy to someone in need.



Last recovery date
Last restore date
Last recovery time
last restore time

No comments:

Post a Comment