Re: Hot Backup

From: Doug Coan <dcoan_at_aegonusa.com>
Date: Fri, 02 Feb 2001 22:23:05 GMT
Message-ID: <95fbvt$pu4$1@nnrp1.deja.com>

In article <95el51$3k7$1_at_nnrp1.deja.com>, ashish25_at_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/

Received on Fri Feb 02 2001 - 16:23:05 CST