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

>> 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."

Boy, you got that right, brother!!! I had a situation last summer where we were one mishap away from losing the whole shootin' match, and that last option was to start again.

Anyway, since your database was closed for the PITR, a "hot" backup isn't really possible there. My question was intended for the situation where either choice was possible.

Anyone? Bueller? Bueller? Anyone?

--
http://www.freelists.org/webpage/oracle-l