Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backup Recovery - Cold Backup in Archive log mode

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US