Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database creation time question

MSKJan 13 2011 — edited Jan 13 2011
BANNER
--------------------------------------------------------------------------------
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
This post has been answered by Pierre Forstmann on Jan 13 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2011
Added on Jan 13 2011
8 comments
1,039 views