Re: Is this method of offline backup OK?

From: Sean McKeown <smckeownNO_at_BACKSIESearthlink.net>
Date: Wed, 13 Mar 2002 03:57:05 GMT
Message-ID: <3C8ECE31.95CA84FF@BACKSIESearthlink.net>

"Howard J. Rogers" wrote:
>
> It's fine. Technically you don't have to include the online redo logs, but
> cold backups with them are a bit simpler to restore.

And a really bad idea to backup as a general practice. Oracle recommends against backing up your online redo logs. See the Oracle Backup and Recovery Guide. Backing up online redos is dangerous because you may 1) accidentally restore them after a crash, overwriting transactions in the existing online redos and 2) if you do restore a cold backup including online redos, you will generate multiple timelines for redo - i.e. you will generate multiple copies of archive logs with the same name and sequence number, again causing confusion (and possibly corruption) in the event of a recovery.

Regards,
Sean Received on Tue Mar 12 2002 - 21:57:05 CST