This content has been marked as final. Show 15 replies
STARTUP MOUNT - is for both shared or exclusive and the database is not open - you can do any thing with its data.
Try - STARTUP RESTRICT
This starts the database and open it, but only users with RESTRICTED SESSION system privilege can connect to the database.
Make sure that only admins have RESTRICTED SESSION system privilege
Actually there is. EXCLUSIVE and SHARED were once used for Oracle Parallel Server.
SHARED meant: allow both instances to function.
EXCLUSIVE meant: allow only the current instance to function.
SHARED has been replaced by CLUSTER_DATABASE = TRUE
and EXCLUSIVE by CLUSTER_DATABASE = FALSE
Senior Oracle DBA
Experts: those who did read dcoumentation.
You are right but this option is deprecated from 9i, Parallel server was replaced by RAC (as you mentioned in your post), and should not be used any more (-:
If he is using 8i Parallel Server I taking my post back (-:
Currently MOUNT EXCLUSIVE does not serve you at all.
I have asked why he needs to mount exclusive in order to know what he is trying to do and give alternative.
and the commands should be fired after connecting to RMAN. i.e. the commands should like this:
RMAN> shutdown abort;
RMAN> startup mount exclusive restrict;
RMAN> drop database;
other drop options are:
RMAN> DROP DATABASE;
RMAN> DROP DATABASE NOPROMPT;
RMAN> DROP DATABASE INCLUDING BACKUPS;
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;
Correct me if I'm wrong.