Re: question on cold backup(in archive mode)

From: Big Al <db-guru_at_att.net>
Date: Tue, 17 Oct 2000 23:09:52 GMT
Message-ID: <39ECDBCD.5DC26660@att.net>

susana73_at_hotmail.com wrote:
>
> Hi there,
>
> I am doing cold backup in archive mode on my production database. I
> have two questions regarding recovery:
>
> 1.If one of the datafiles corrupted, can I just replace that
> particular file from the backup and then apply the archive logs?

Yes.
>
> 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?

Yes, and you can roll forward to current easily if you kept the original control files. If you also replace the control files from the backup you will need to do a recover until cancel or a recover until time command.

Big Al Received on Tue Oct 17 2000 - 18:09:52 CDT