Re: RMAN Restore Question

On 20 Apr 2005 06:26:09 -0700, amerar_at_iwc.net wrote:

>Then, I used RMAN and restored the control file from a previous backup.
> At this point, The control file has an eariler SCN than the data file
>headers. So, I ussed a 'recover database' which I thought should, roll
>everything forward.
>
>If this is true, why did I still need to open with resetlogs? I
>figured that the rolling forward brought the database back up to
>present.....

You are recovering from a *backup controlfile*. A *backup controlfile* does NOT contain the same information as the production controlfile, hence the SCN in the controlfile isn't equal to the SCN in the datafile.
As you are recovering from a *backup controlfile*, you are performing *incomplete recovery*, which you do by
recover database using backup controlfile until cancel So your script is incorrect.
After *incomplete recovery* using the resetlogs clause is *mandatory*, as *documented*.

Please read the documentation carefully or ask clarification with respect to specific passages in the doc. It is no use to request this group to spell it out for you all again. Please try to understand the basic difference between *complete* and *incomplete* recovery, various people have tried to explain it to you for several weeks now, and you begin to become annoying.

--
Sybrand Bakker, Senior Oracle DBA