Re: Recover of a database

The topic of this thread is not cold backup but cold restore.

Jaap.

On Sat, 18 May 2002 16:34:47 +1000, "Howard J. Rogers" <dba_at_hjrdba.com> wrote:

>
>"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 - 09:30:44 CDT