Re: Why control files are needed for restore of hot backup?

Sybrand Bakker wrote:
>
> Your scenario would still constitute *manual/point in time* recovery as
> opposed to *complete* automatic recovery.

I'm not sure I follow - "*manual/point in time*"? My scenario can be 1) completely automated and 2) results in a complete recovery, not a point-in-time recovery. The steps involved are no more manual or automatic than a recovery with an existing controlfile - I run one sql script which is automatically generated for me by the backup controlfile to trace command, and I'm done. No transactions lost, no resetlogs, *complete* recovery.

> You say there isn't a difference between the two methods of recovery? With
> all archived redolog files and the controlfile being present, what would
> happen?

I would get a completely recovered database, just as I asserted.

> In your scenario you would have at least to press <ENTER> for every
> individual archive.

No I wouldn't. I just did it, and not once did I have to hit <ENTER>. The *only* modification I made to the output of the backup controlfile to trace command was adding the word "AUTOMATIC" to the "RECOVER DATABASE" line. But this is no different than if I had a current copy of the controlfile - I'd still have to issue a "recover automatic database" if I didn't want to be prompted for each individual archive.

> If you want to nit pick next time, make sure you're better prepared.

:) Please, show me what else I needed to prepare. I'm happy to admit I'm wrong, but you have to prove me wrong first, not just assert ill-preparedness.

Regards,
Sean Received on Wed May 22 2002 - 18:18:23 CDT