Re: QUESTION: Basic stuff about RMAN 9i

On 14 Jun 2005 13:30:09 -0700, "DW" <dwhittier_at_shaw.ca> wrote:

>FWIW, I am running 9.2.0.4.
>
>I've reviewed what I did, and suspect that what may have caused the
>problem was my connect string for RMAN; the error that was generated
>was from the catalog database. What I find most odd is that I was able
>to do a 'SHUTDOWN IMMEDIATE' from within RMAN without incident; but
>after restarting, a subsequent SHUTDOWN IMMEDIATE resulted in an error.

You have located the catalog in the same database as the database you are backing up. If you use a catalog at all (and many people state you don't need a catalog in 9i, and it seems to have disappeared in 10g), this needs to be in a *separate database*. Consequently, the error is fully understandable. You are shutting down the target database, which happens to be the catalog database. As soon as the catalog database is needed, getting in touch with the catalog database will result in error.

Chicken and Egg!

--
Sybrand Bakker, Senior Oracle DBA