HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to unmount oracle database?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
databaseoracleunmounthow

Problem

According to the oracle docs, during shutdown, 3 steps are performed:

  • Close the database.



  • Unmount the database.



  • Shut down the instance.



Is it possible to make only first 2 steps?

Solution

Yes, it's possible.

SQL> alter database close;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database dismount;

Database altered.

SQL> select open_mode from v$database;
select open_mode from v$database
                      *
ERROR at line 1:
ORA-01507: database not mounted

Code Snippets

SQL> alter database close;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database dismount;

Database altered.

SQL> select open_mode from v$database;
select open_mode from v$database
                      *
ERROR at line 1:
ORA-01507: database not mounted

Context

StackExchange Database Administrators Q#172152, answer score: 6

Revisions (0)

No revisions yet.