Re: Archived logs

From: George Dau <gedau_at_isa.mim.com.au>
Date: Thu, 07 Jan 1999 22:23:58 GMT
Message-ID: <3696336b.254916240@isappp>

Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:

]On Thu, 7 Jan 1999, Daniel wrote:

]>
]> Only delete arch logs prior to your last known good (and tested) cold
]> backup...

]
]Why does it have to be a cold backup?

It doesn't.

There is only one good reason to do cold backups: it introduces a shutdown and startup. This is a very good idea, since the shutdown/startup will alert you to any problems with the database. These may not show up until a restart of the database.

If you have a window of downtime, you might as well get a cold backup in if you can; otherwise just start it up again straight away and continue with hot backups.
--
 ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __

/    * \ Home: gedau_at_pobox.com         !  Any views or opinions expressed (OO)
\_,--\_/ Work: gedau_at_isa.mim.com.au    !  above may be mine, but are NOT ( \/ )
      v   WWW: http://pobox.com/~gedau !  necessarily those of M.I.M.     W--W

Received on Thu Jan 07 1999 - 16:23:58 CST