Startup and Shutdown: NOMOUNT, MOUNT, OPEN
The Three Startup Stages
| Stage | What happens | Needs |
|---|---|---|
| NOMOUNT | Instance starts: memory allocated, background processes started | SPFILE or PFILE |
| MOUNT | Instance opens the control file | Control file |
| OPEN | Datafiles and redo logs are opened. Users can connect. | Datafiles, redo logs |
Why stages? Some admin tasks need the database partly started. For example, restoring a lost control file happens at NOMOUNT, and restoring datafiles happens at MOUNT.
Start Up
sql
sqlplus / as sysdba
STARTUP -- goes straight to OPEN
-- or step by step
STARTUP NOMOUNT;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN;
| Command | Use it for |
|---|---|
STARTUP NOMOUNT | Recreate control file, restore control file |
STARTUP MOUNT | Restore datafiles, enable ARCHIVELOG, rename files |
STARTUP RESTRICT | Open only for users with RESTRICTED SESSION (maintenance) |
STARTUP FORCE | Abort then start. Use with care. |
Shut Down
| Mode | New connections | Running transactions | Result |
|---|---|---|---|
NORMAL | Refused | Waits for all users to disconnect | Clean, but can wait forever |
TRANSACTIONAL | Refused | Waits for them to finish | Clean |
IMMEDIATE | Refused | Rolled back | Clean. Use this normally. |
ABORT | Refused | Not rolled back until next start | Needs instance recovery |
sql
SHUTDOWN IMMEDIATE;
-- last resort when IMMEDIATE hangs
SHUTDOWN ABORT;
About ABORT: ABORT is like pulling the power plug. Oracle recovers automatically at the next start using redo, but it is slower and you should only use it when nothing else works.
Check the Status
sql
SELECT instance_name, status, startup_time FROM v$instance;
SELECT open_mode, log_mode FROM v$database;
Startup and Shutdown of a PDB
sql
ALTER PLUGGABLE DATABASE FREEPDB1 CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE FREEPDB1 OPEN;
DBA habit: Before any shutdown, check who is connected with
SELECT username, COUNT(*) FROM v$session GROUP BY username; and tell the team first.
Conclusion
Startup moves through NOMOUNT, MOUNT and OPEN. Use SHUTDOWN IMMEDIATE for normal stops and keep ABORT for emergencies.
Quick Summary: STARTUP = NOMOUNT, MOUNT, OPEN. SHUTDOWN IMMEDIATE is the normal clean stop.

