Oracle Startup and Shutdown Commands Explained (SQL*Plus DBA Guide)

Leave a reply

Introduction

Oracle startup and shutdown commands are fundamental skills for every Oracle DBA and application support engineer.
These commands are used during:

  • Server maintenance
  • Database patching
  • Backup and recovery
  • Emergency situations

In this blog, we will explain Oracle startup and shutdown commands step by step, exactly as used in real environments and demonstrated in DBA training videos.

Connecting to SQL*Plus as SYSDBA

Startup and shutdown operations require SYSDBA privileges.

sqlplus / as sysdba
-- Verify the connected user:
SHOW USER;

What Is Oracle Startup?

Oracle startup means:

  • Starting the Oracle instance
  • Allocating memory (SGA)
  • Starting background processes
  • Opening the database for user access

Oracle startup happens in three stages.

Oracle Startup Stages

1️⃣ NOMOUNT Stage

STARTUP NOMOUNT

What happens:

  • Instance starts
  • Memory allocated
  • Background processes start
  • Control files are NOT accessed

Used for:

  • Creating a new database
  • Recreating control files

2️⃣ MOUNT Stage

STARTUP MOUNT;

What happens:

  • Control files are read
  • Database is associated with instance
  • Datafiles are still closed

Used for:

  • Media recovery
  • Changing archive log mode
  • Renaming datafiles

3️⃣ OPEN Stage

Startup

This command:

  • Starts the instance
  • Mounts the database
  • Opens the database automatically

What happens:

  • Datafiles and redo logs are opened
  • Users can connect to the database

Verify Database and Instance Status

SELECT status FROM v$instance;

SELECT open_mode FROM v$database;

Oracle Shutdown Commands

Oracle provides multiple shutdown options depending on the situation.

Shutdown IMMEDIATE (Recommended)

SHUTDOWN IMMEDIATE;

What it does:

  • Disconnects all users
  • Rolls back active transactions
  • Closes database cleanly
  • No instance recovery needed

Shutdown NORMAL

SHUTDOWN NORMAL;
OR
SHUTDOWN;

What it does:

  • Waits for all users to disconnect
  • Does not terminate sessions
  • Rarely used in production

Shutdown TRANSACTIONAL

SHUTDOWN TRANSACTIONAL;

What it does:

  • Allows active transactions to complete
  • Blocks new transactions
  • Useful for critical production systems

Shutdown ABORT (Emergency Only)

SHUTDOWN ABORT;

What it does:

  • Immediate database stop
  • No cleanup performed
  • Instance recovery required on next startup

⚠️ Use only when database is hung or unresponsive