SQL Plus - STARTUP

About

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

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]

Powered by ComboStrap