Home » RDBMS Server » Backup & Recovery » Has my database ever been restored ? (Oracle 10g / Windows)
Has my database ever been restored ? [message #523038] Thu, 15 September 2011 06:10 Go to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Hi, everybody

How can one knows if ever a database has already been restored or never,
not via RMAN, but just an ordinary connection to the database via SQLPLUS, for example,

in other words, i want to know if there is a way to know it just on exploring the dictionary views such as v$log, v$archivedlog, v$database, ...

The database is on archivelog mod, and backup job is scheduled on daily basis.


Thanks.
Re: Has my database ever been restored ? [message #523039 is a reply to message #523038] Thu, 15 September 2011 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can one knows if ever a database has already been restored or never,

No (if you mean a complete restore and recover), hopefully, otherwise it means the database was not restored in the same state.

Regards
Michel

[Updated on: Thu, 15 September 2011 06:13]

Report message to a moderator

Re: Has my database ever been restored ? [message #523054 is a reply to message #523039] Thu, 15 September 2011 07:27 Go to previous messageGo to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Thank you Michel,

Yes, that's what i'm intereseted in,

to check if , the current version of my db is the latest one or not,

for example in case of a complete restore followed by an INcomplete recover ?

Re: Has my database ever been restored ? [message #523061 is a reply to message #523054] Thu, 15 September 2011 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
An incomplete recover is terminated with an open resetlogs.
The last 2 reset log datetimes are in v$database.

Regards
Michel
Re: Has my database ever been restored ? [message #523104 is a reply to message #523061] Thu, 15 September 2011 10:26 Go to previous messageGo to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
So,
if "CREATED" and "RESETLOGS_TIME" columns in v$database view have the same values, I can be sure that this database has never been subjected to a "point-in-time recovery" operation ??

isn't it ?
Re: Has my database ever been restored ? [message #523108 is a reply to message #523104] Thu, 15 September 2011 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Has my database ever been restored ? [message #523351 is a reply to message #523108] Fri, 16 September 2011 18:04 Go to previous messageGo to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Thanks Michel.
Re: Has my database ever been restored ? [message #523939 is a reply to message #523104] Wed, 21 September 2011 04:04 Go to previous messageGo to next message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
>if "CREATED" and "RESETLOGS_TIME" columns in v$database view have the same values, I can be sure that this database has never been subjected to a "point-in-time recovery" operation

Unfortunately, no. CREATED is the creation/recreation time for the controlfile -- and the controlfile may have been recreated any time after the database, possibly for an incomplete recovery as well.

See http://hemantoracledba.blogspot.com/2010/07/vdatabasecreated-is-this-database.html

Hemant
Re: Has my database ever been restored ? [message #523948 is a reply to message #523939] Wed, 21 September 2011 04:28 Go to previous message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, it is only true in 99.999% of the case.

Regards
Michel
Previous Topic: Restore schema
Next Topic: Pre-requisites to perform RMAN BACKUP
Goto Forum:
  


Current Time: Tue Nov 30 16:20:04 CST 2021