Starts an Oracle instance with several options, including mounting, and opening a database.
| 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
STARTUP db_options | cdb_options | upgrade_options
db_options has the following syntax:
[FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] | OPEN [open_db_options] [dbname] ] | NOMOUNT ]
open_db_options has the following syntax:
READ {ONLY | WRITE [RECOVER]} | RECOVER
cdb_options has the following syntax:
root_connection_options | pdb_connection_options
root_connection_options has the following syntax:
PLUGGABLE DATABASE pdbname [FORCE] [RESTRICT] | [OPEN [open_pdb_options]]
pdb_connection_options has the following syntax:
[FORCE] [RESTRICT] | [OPEN [open_pdb_options]]
has the following syntax:
READ WRITE | READ ONLY
upgrade_options has the following syntax:
[PFILE=filename] {UPGRADE | DOWNGRADE} [QUIET]