OraFAQ Forum: Backup & Recovery » Has my database ever been restored ?

Home » RDBMS Server » Backup & Recovery » Has my database ever been restored ? (Oracle 10g / Windows)

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

Has my database ever been restored ? [message #523038]

Thu, 15 September 2011 06:10

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.

Report message to a moderator

Re: Has my database ever been restored ? [message #523039 is a reply to message #523038]

Thu, 15 September 2011 06:13

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

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

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 ?

Report message to a moderator

Re: Has my database ever been restored ? [message #523061 is a reply to message #523054]

Thu, 15 September 2011 07:52

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

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

Report message to a moderator

Re: Has my database ever been restored ? [message #523104 is a reply to message #523061]

Thu, 15 September 2011 10:26

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 ?

Report message to a moderator

Re: Has my database ever been restored ? [message #523108 is a reply to message #523104]

Thu, 15 September 2011 10:55

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

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

Re: Has my database ever been restored ? [message #523351 is a reply to message #523108]

Fri, 16 September 2011 18:04

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

Thanks Michel.

Report message to a moderator

Re: Has my database ever been restored ? [message #523939 is a reply to message #523104]

Wed, 21 September 2011 04:04

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

Report message to a moderator

Re: Has my database ever been restored ? [message #523948 is a reply to message #523939]

Wed, 21 September 2011 04:28

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

Senior Member
Account Moderator

OK, it is only true in 99.999% of the case.

Regards
Michel

Report message to a moderator

Previous Topic:	Restore schema
Next Topic:	Pre-requisites to perform RMAN BACKUP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 22:14:53 CST 2025