snippetMinor
How to unmount oracle database?
Viewed 0 times
databaseoracleunmounthow
Problem
According to the oracle docs, during shutdown, 3 steps are performed:
Is it possible to make only first 2 steps?
- 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 mountedCode 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 mountedContext
StackExchange Database Administrators Q#172152, answer score: 6
Revisions (0)
No revisions yet.