Re: RMAN Incomplete Recovery question - REPOST

On 17 Dec 2003 06:47:01 -0800, ravisista_at_hotmail.com (Ravi) wrote:

>If we use the current controlfile, as
>I said in the original post, how'd it know about the droppped
>tablespace and may be that's why recovery failed?

Tablespace info is in the controlfile. So when you drop a tablespace it is marked deleted in the controlfile. Anyone correct me if I am wrong, but using the current controlfile is specific for *complete* recovery. Your script however performs *incomplete* recovery by virtue of the 'set until time' command. And BTW: if you are using a recovery catalog, the controlfile still keeps track of RMAN backups.

--
Sybrand Bakker, Senior Oracle DBA