database creation time question
MSKJan 13 2011 — edited Jan 13 2011BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Solaris: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
I think this would be accurate query to find out the actual db creation time after refresh
select RESETLOGS_TIME , PRIOR_RESETLOGS_TIME , status from v$database_incarnation
where status = 'CURRENT';
Also, I saw a database in which v$database.created < v$database_incarnation.resetlogs_time.
What I did for this database was this
(a) refresh from production
(b) renamed the database using nid
and I notice the above. Any idea why in this case control file create time is less than the resetlogs_time
Thank you
MSK