Re: question on cold backup(in archive mode)

From: Scott Watson <rscottwatson_at_hotmail.com>
Date: Tue, 17 Oct 2000 19:12:56 -0400
Message-ID: <W%4H5.4635$My1.182524@wagner.videotron.net>

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 - 18:12:56 CDT