Re: Recover of a database

"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.

I hope you're not suggesting that a cold backup causes the log sequence numbers to regress. They don't.

HJR
> 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 Sat May 18 2002 - 01:34:47 CDT