Re: Hotbackups & Redo Logs

rwp wrote:

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

After completing the hot backup of your tablespaces, you are supposed to issue the ALTER SYSTEM SWITCH LOGFILE command. The redo logs just archived as a result of this command will also have to be part of your backup to be able to perform complete recovery.

--
hope this helps !
Srini
(to reply, change "nospam" to "chavali" in my email address.  :-)  )