ora-01102 with multiple databases

[UCLAPat]

Hi, I installed two databases (DB1 and RECOVERY) to the same system. I had one fully functional DB1. I created the second one (RECOVERY) so that I could make an independent recovery catalog.

Anyway, during the entire process, at some point, I had shutdown the DB1 database (via SHUTDOWN NORMAL or SHUTDOWN IMMEDIATE).

While trying to restore the DB1, RMAN said I had to have a mounted DB1 (the target). So when I tried to remount it, it brought up the ORA-01102 error. I've tried stopping and restarting all the oracle services. I've rebooted the system. The databases have completely different names across the board. I've tried starting an instance and using SHUTDOWN ABORT (which brings up the database not mounted, instance closed message).

I can't mount or open my DB1 any more.

Any help would be very much appreciated. nguyenpatrick@hotmail.com

 

[karluk]

Please check the name of your control files on the recovery database. (select name from v$controlfile If your recovery database initialization file is pointing at DB1's control files, you started up DB1 when you thought you were starting up the recovery database.

 

[UCLAPat]

Thanks for the reply! Any, I logged into the RECOVERY database and executed the 'select name from v$controlfile' and the control files are in the RECOVERY directory. The DB1 and RECOVERY directories are entirely independent. I checked the init.ora files for both DB's and both are pointing to their respective directories.