SQL Plus - STARTUP

About

Starts an Oracle instance with several options, including mounting, and opening a database.

Articles Related

Quick Example

Instance Status	SQL Plus Command	SQL Command if already started
Nomount	startup nomount
Mount	startup Mount	alter database mount
Open	startup	alter database open

You can see the status in the instance table.

select * from v$instance;

INSTANCE_NUMBER | INSTANCE_NAME    | HOST_NAME              | VERSION           | STARTUP_T | STATUS
--------------- | ---------------- | -----------------------| ----------------- | --------- | -----------
              1 | orcl             | HI-LAPTOP-NGD          | 12.1.0.1.0        | 18-MAR-14 | STARTED

Syntax

STARTUP db_options | cdb_options | upgrade_options

db_options

db_options has the following syntax:

[FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] | OPEN [open_db_options] [dbname] ] | NOMOUNT ]

open_db_options

open_db_options has the following syntax:

READ {ONLY | WRITE [RECOVER]} | RECOVER

cdb_options

cdb_options has the following syntax:

root_connection_options | pdb_connection_options

root_connection_options

root_connection_options has the following syntax:

PLUGGABLE DATABASE pdbname [FORCE] [RESTRICT] | [OPEN [open_pdb_options]]

pdb_connection_options

pdb_connection_options has the following syntax:

[FORCE] [RESTRICT] | [OPEN [open_pdb_options]]

open_pdb_options

has the following syntax:

READ WRITE | READ ONLY

upgrade_options

upgrade_options has the following syntax:

[PFILE=filename] {UPGRADE | DOWNGRADE} [QUIET]