Comments below
HJR
--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources: http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------
<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:
>
> 1.If one of the datafiles corrupted, can I just replace that
> particular file from the backup and then apply the archive logs?
>
Absolutely. That's the whole point of archives.
> 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, provided you don't try and restore the Control Files and/or Redo Logs
(online).
You will however be applying archives to the entire database instead of to
one particular file, and hence you can expect recovery to take a good deal
longer than it otherwise would.
Regards
HJR
> Thanks in advance,
>
> Susan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 18 2000 - 05:38:03 CDT
