SQL Plus - STARTUP

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

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

Advertising

3 - 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

4 - Syntax

STARTUP db_options | cdb_options | upgrade_options

4.1 - db_options

db_options has the following syntax:

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

4.1.1 - open_db_options

open_db_options has the following syntax:

READ {ONLY | WRITE [RECOVER]} | RECOVER
Advertising

4.2 - cdb_options

cdb_options has the following syntax:

root_connection_options | pdb_connection_options

4.2.1 - root_connection_options

root_connection_options has the following syntax:

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

4.2.2 - pdb_connection_options

pdb_connection_options has the following syntax:

[FORCE] [RESTRICT] | [OPEN [open_pdb_options]]
4.2.2.1 - open_pdb_options

has the following syntax:

READ WRITE | READ ONLY

4.3 - upgrade_options

upgrade_options has the following syntax:

[PFILE=filename] {UPGRADE | DOWNGRADE} [QUIET]
Advertising
lang/sqlplus/startup.txt · Last modified: 2017/09/06 19:30 by gerardnico