Re: Backup Recovery - Cold Backup in Archive log mode

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 10 Jun 2004 11:38:14 +1000
Message-ID: <40c7bb70$0$31674$afc38c87@news.optusnet.com.au>

"raj" <rajesh_choprauk_at_yahoo.co.uk> wrote in message news:80c4d335.0406091551.4ea2d7cd_at_posting.google.com...
> Is it best to issue:
>
> ALTER SYSTEM ARCHIVE LOG ALL;
>
> Prior to shutting down my database for a cold backup.
>
> Raj

Well, I wouldn't archive log *all*. You can archive log *current* if you like, since that's the only online log that's not been archived yet.

It's not really essential anyway, though. The argument runs like this. If you are doing a hot backup, then the backup you take is an inconsistent one. Inconsistent ones can only be made consistent and usable by applying redo to them. Therefore, the contents of the current online log are important for being able to make use of your latest hot backup.

But you are doing cold backups, even in archivelog mode. Therefore your backup will be entirely consistent, and won't need the redo in the current log to be made usable.

So, it's not actually needed at all, but if you are feeling a little paranoid and nervous, and want to make sure everything that can be is archived, then throw in an archive log current.

Regards
HJR Received on Wed Jun 09 2004 - 20:38:14 CDT