OraFAQ Forum: Server Administration » Version

Home » RDBMS Server » Server Administration » Version_time in v$database (oracle10g / Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Version_time in v$database [message #512694]

Tue, 21 June 2011 09:22

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

Hello every body,

Plz, can some onE tell me what does mean VERSION_TIME column in V$DATABASE;
i know that there is an other column which is called CREATED which indicates when the database has been created and i think it will never change,
but, what about VERSION_TIME ? when does it change ?

THANKS.

Report message to a moderator

Re: Version_time in v$database [message #512734 is a reply to message #512694]

Tue, 21 June 2011 21:24

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

http://www.orafaq.com/forum/?t=msg&th=26707/0/
V$DATABASE displays information about the database from the control file.
And it it from "x$kccdi.divts"[kernel cache, controlfilemanagement database information}

Quote:

Each time a backup controlfile is mounted, the version_time is updated.

Report message to a moderator

Re: Version_time in v$database [message #512844 is a reply to message #512734]

Wed, 22 June 2011 08:33

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

thank you ramoradba

Report message to a moderator

Re: Version_time in v$database [message #512994 is a reply to message #512844]

Thu, 23 June 2011 03:24

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

So, can we deduce that if CREATED VALUE and VERSION_TIME VALUE are equals means that CONTROLFILE has never been restored i.e : it has always been the same one used by the database ?

Report message to a moderator

Re: Version_time in v$database [message #513069 is a reply to message #512994]

Thu, 23 June 2011 08:06

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Try it yourself.

Sriram

Report message to a moderator

Re: Version_time in v$database [message #513276 is a reply to message #513069]

Sat, 25 June 2011 11:59

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

Look ramo

I tried what you said, but it didn't

I made a backup of all database with autoback controfile on,

run
{
shutdown immediate;
startup mount;
backup database;
}

some time later and after serveral manipulations of dropping objects for example, I issued :

CMD (Windows)

set nls_date_format='dd-mm-yy hh24:mi:ss'

RMAN

run
{
shutdown immediate;
startup mount;
set until time '25-06-11 11:11:11';
retore database;
recover database;
alter dabase open resetlogs;
}

the database is safley restored and recovered but
CREATED and VERSION_TIME are always the same , I mean VERSION_TIME doesn't change in spite of restoring with

autoback controlfile on

SQL> alter session set nls_date_format ='dd-mm-yy hh24:mi:ss';

Session modifiée.

SQL> select name, created, version_time
  2  from v$database;

NAME      CREATED           VERSION_TIME
--------- ----------------- -----------------
ORCL      19-03-11 23:04:54 19-03-11 23:04:54

What's wrong ? plz.

Report message to a moderator

Re: Version_time in v$database [message #513281 is a reply to message #513276]

Sat, 25 June 2011 13:58

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Unless you deleted the current control file there is no reason you still not stay with it.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-00600: internal error code, arguments: [qerixGetKey:optdesc]
Next Topic:	Pfile very small(2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 09:22:20 CST 2025