How do you mount a database in exclusive mode?
Shut down the other instance or mount in a compatible mode. Firstly shutdown instance using the shutdown immediate command. Then kill ALL Oracle process using the following script. Now run startup mount again.
What is Oracle database exclusive mode?
Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that instance can mount the database. Versions of Oracle that do not support the Parallel Server option only allow an instance to mount a database in exclusive mode.
Can not mount database in exclusive mode?
Cause: Some other instance has the database mounted exclusive or shared. Action: Shut down the other instance or mount in a compatible mode. Find whether you have any running Oracle process.
How do I resolve ORA 00214?
This ORA-00214 error is related with the inconsistent set of control files, datafiles/logfiles, and redo files was used. To solve this error, Use a consistent set of control files, datafiles/logfiles, and redo log files. That is, all the files must be for the same database and from the same time period.
What is Startup Mount exclusive in Oracle?
EXCLUSIVE. Signifies that the database can only be mounted and opened by the current instance (it cannot be opened simultaneously by multiple instances). Cannot be used with SHARED, PARALLEL, or NOMOUNT. If no mounting option is specified, EXCLUSIVE is assigned by default.
How do I mount a standby database?
To open a standby database for read-only access when it is currently shut down:
- Start the Oracle instance for the standby database without mounting it: SQL> STARTUP NOMOUNT;
- Mount the standby database: SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
- Open the database for read-only access: SQL> ALTER DATABASE OPEN READ ONLY;
How do I drop an Oracle database?
Steps To Drop Oracle Database Manually
- Step 1 : Connect to the database with sysdba privilege. $ export ORACLE_SID=mydb $ sqlplus “/ as sysdba”
- Step 2 : Shutdown the database. SQL> shutdown immediate;
- Step 3: Start the Database in Exclusive mode.
- Step 4: Drop the database.
- Step 5 : Post Change Steps.