Re: question on cold backup(in archive mode)

From: Doug <zuestra_at_hotmail.com>
Date: Tue, 17 Oct 2000 22:45:58 -0400
Message-ID: <7k3quscadue8ue9rc6s1cttqvsacjnf1ab@4ax.com>

Uh... what? This is a good reason to be wary of usenet.... Yes you can do a cold backup with archive mode, and recover with it, and yet you can recover a single file... I'm scared to think of what this last poster uses for a backup strategy....

On Tue, 17 Oct 2000 19:12:56 -0400, "Scott Watson" <rscottwatson_at_hotmail.com> wrote:

>See comments....
>
>
><susana73_at_hotmail.com> wrote in message news:8sijks$fdj$1_at_nnrp1.deja.com...
>> Hi there,
>>
>> I am doing cold backup in archive mode on my production database. I
>> have two questions regarding recovery:
>
>Why are you archiving if you are only doing a cold backup.
>
>>
>> 1.If one of the datafiles corrupted, can I just replace that
>> particular file from the backup and then apply the archive logs?
>>
>Not from a cold backup you need to perform a hot backup. (eg alter
>tablespace begin backup ....)
>
>
>> 2.If I recover ALL the datafiles from yesterday backup(the database
>> become valid in yesterday version), can I still apply the archive logs
>> so that I can get back all the updated data as of today?
>>
>Again no, you cannot apply archive log files to a cold backup.
>
>> Thanks in advance,
>>
>> Susan
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
Received on Tue Oct 17 2000 - 21:45:58 CDT