Re: Recover of a database

I agree, Oracle does not know it happened.

You could check however the alert<SID>.log of the database. When you keep it for a longer time (I prefer to keep them at least 6 months, ofcourse switch it once a month or so) and it is not restored (why would you) you must see that in the startup messages it suddenly reports a lower redo log sequence number than before. Looking at the reported sequence numbers at log switches helps too.
This can also occur after an "open resetlogs" but that can easily be identified because this command is logged in the alert.log as well and then it starts with sequence 1 again.

Tom Dyess <nospam_at_nospam.spm> schreef in berichtnieuws ac10dc$jc0$1_at_news.gate.net...
| Not that I know of - a cold resore is really done at the OS level when
| Oracle is shut down, so it really doesn't even know that it happened. You
| might be able to determine when it happend by looking at the creation date
| of the data files when they were moved on to that drive. Depends if they
| kept their original creation date.
|
| Tom
| OraclePower.com
|
| "Carlos Alberto" <calberto2312_at_hotmail.com> wrote in message
| news:72954535.0205160917.106e3b21_at_posting.google.com...
| > Hi,
| >
| > Is it possible to know the date of the last cold restore which was
| > made to a database? Is it registered within the v$ views?
| >
| > Thanks in advanced,
| > Carlos
|
|
Received on Thu May 16 2002 - 15:33:49 CDT