Startup and Shutdown: NOMOUNT, MOUNT, OPEN

Oracle DBA Certification 12 min min read Updated: Nov 16, 2026 Beginner
Startup and Shutdown: NOMOUNT, MOUNT, OPEN
Beginner Topic 3 of 6

The Three Startup Stages

StageWhat happensNeeds
NOMOUNTInstance starts: memory allocated, background processes startedSPFILE or PFILE
MOUNTInstance opens the control fileControl file
OPENDatafiles 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;
CommandUse it for
STARTUP NOMOUNTRecreate control file, restore control file
STARTUP MOUNTRestore datafiles, enable ARCHIVELOG, rename files
STARTUP RESTRICTOpen only for users with RESTRICTED SESSION (maintenance)
STARTUP FORCEAbort then start. Use with care.

Shut Down

ModeNew connectionsRunning transactionsResult
NORMALRefusedWaits for all users to disconnectClean, but can wait forever
TRANSACTIONALRefusedWaits for them to finishClean
IMMEDIATERefusedRolled backClean. Use this normally.
ABORTRefusedNot rolled back until next startNeeds 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.

Get Newsletter

Subscibe to our newsletter and we will notify you about the newest updates on Edugators