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

On Mon, 28 Feb 2005 07:39:24 -0700, Tim Gorman <tim_at_evdbt.com> 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
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l