Re: Recover of a database

Hi Anton,

  OK, IŽll take a look at the alert to see the log sequence.

Thanks,
Carlos

"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message news:<ac1527$ia5$1_at_news1.xs4all.nl>...
> 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 Fri May 17 2002 - 09:20:47 CDT