Re: Archive Log Mode Question

I believe the original question dealt with whether to put the db in archive log mode or not to do a backup. My response was meant to say that if the database is up and running, you have to be in archive log mode to do 'hot' backups. A 'cold' backup of a running database is unreliable, if your os will even let you do it.

For a cold backup to be valid, the db/instance must be down. As such, whether it is in archive log mode or not is not a factor.

I am a strong believer in archive logging for point-in-time and automatic instance recovery. Particularly for db's that can't be backed up cold nightly. It was not the issue I was addressing.

In article <Pine.OSF.4.02.9907040838420.15751- 100000_at_gonzo.wolfenet.com>,
  Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:
> On Thu, 1 Jul 1999 mpir_at_compuserve.com wrote:
>
> > If you are talking about hot backups, you can't disable archive
> > logging. The database needs the archive logs to handle 'hot' mode.
If
> > you are talking about cold backups, then the database is down and
> > archiving is irrelevant.
>
> Archiving redologs is not irrelevant for people using cold backups.
> Having archived copies of every log will allow you, in the event of a
> restore, to roll forward from any given cold backup to an arbitrary
> point in time between backups.
>
> --
> Jeremiah Wilton http://www.wolfenet.com/~jeremiah
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 06 1999 - 08:50:08 CDT