Re: Hotbackups & Redo Logs

Hi! The same question has been bugging me for a very long time. Oracle says you should not backup the redo logs as part of your hot backup and that if you try to restore logs from a backup, it might corrupt the database. I guess this is the reason why you should always mirror your log files Venkat

rwp wrote in message <34F109E1.A004CD9A_at_ibm.net>
>I am familiar with using hot backups with Oracle and have used them to
>recover a tablespace but I have one question for anyone unlucky enough
>to have had this experience.
>
>When you take a hot backup you get a copy of all your data files, your
>archive logs, and a "backup" version of your control file. The only
>files not backed up are your redo log files. This raises a question.
>
>If you are in a disaster situation where you have no database at all to
>start with and you only have your hot backup (with no redo logs backed
>up) how do you deal with the fact that the redo logs are not there after
>you restore this hot backup from tape?
>
>I'll be experimenting with this on a test database but want to know if
>anyone else has been here before and what you did.
>
>Thanks, rwp.
Received on Mon Feb 23 1998 - 00:00:00 CST