From: Doug Coan <dcoan@aegonusa.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Hot Backup
Date: Fri, 02 Feb 2001 22:23:05 GMT
Organization: Deja.com
Lines: 31
Message-ID: <95fbvt$pu4$1@nnrp1.deja.com>
References: <95el51$3k7$1@nnrp1.deja.com>
NNTP-Posting-Host: 206.150.248.11
X-Article-Creation-Date: Fri Feb 02 22:23:05 2001 GMT
X-Http-User-Agent: Mozilla/4.76 [en] (WinNT; U)
X-Http-Proxy: 1.0 x54.deja.com:80 (Squid/1.1.22) for client 206.150.248.11
X-MyDeja-Info: XMYDJUIDdougcoan


In article <95el51$3k7$1@nnrp1.deja.com>,
  ashish25@my-deja.com wrote:
> Hi,
>    I take a hotbackup daily and make a backup of the controlfile after
> doing alter system switch logfile;
>    My question is I don't take a backup of redo logs.I have them
> mirrored and everything.Should I take a backup of redo logs also.
>      If the current member of redo logs get corrupted how is the
> recovery done.
> Regards,
> Ashish
>
> Sent via Deja.com
> http://www.deja.com/
>

No need. Your online redos will get built on the fly if you restore
from hotbackup. Try this sometime, in test :-). Shutdown the DB. delete
all your online redos. Start the DB. Do a log switch. Watch the redos
get allocated.

If a current online redo gets wacked before it can be archived then you
can only recover up to the point it got hit.

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com
http://www.deja.com/