Re: Some one tested RESETLOGS new functionality on 10g?

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: tim@xxxxxxxxx
  • Date: Mon, 28 Feb 2005 15:12:25 +0000

On Mon, 28 Feb 2005 07:39:24 -0700, Tim Gorman <tim@xxxxxxxxx> wrote:
> I "tested" this functionality first in a good-sized production database in
> v8.0.5 OPS.  More of a sphincter-clench than 10g, surely...  :-)


> POP QUIZ:  The need for a "cold" backup immediately following RESETLOGS was
> one of at least two situations where a "cold" backup was "better" from a
> data protection standpoint than a "hot" backup.  There remains one situation
> where a "cold" backup is better (from a data-protection standpoint) than a
> "hot" backup.  Can anyone name that situation?
> To put it another way, what is the situation where a production DBA might
> ask to halt a production application to take a "cold" backup, and not be
> crazy?

I have done this only once. We were *about* to do PITR from the last
good hot backup. Step 1 of any attempt at PITR (or indeed disaster
recovery) in my book is "first preserve your existing situation for
when the attempted recovery goes wrong."

The book is of course open on my sanity though. 

Niall Litchfield
Oracle DBA

Other related posts: