|SQL*Plus User's Guide and Reference
Part Number A88827-02
Command Reference, 45 of 52
STARTUP [FORCE] [RESTRICT] [PFILE=filename] [MOUNT [dbname]
| OPEN [open_options] [dbname] | NOMOUNT]
where open_options has the following syntax:
Starts an Oracle instance with several options, including mounting and opening a database. You cannot use STARTUP to start Oracle7 instances.
Refer to the following list for a description of each term and clause:
Causes the specified parameter file to be used while starting up the instance. If PFILE is not specified, then the default STARTUP parameter file is used. The default file used is platform specific. For example, the default file is $ORACLE_HOME/dbs/init$ORACLE_SID.ora on UNIX, and %ORACLE_HOME%\database\initORCL.ora on Windows.
Specifies that media recovery should be performed, if necessary, before starting the instance. STARTUP RECOVER has the same effect as issuing the RECOVER DATABASE command and starting an instance. Only complete recovery is possible with the RECOVER option.
Recovery proceeds, if necessary, as if AUTORECOVERY is set to ON, regardless of whether or not AUTORECOVERY is enabled. If a redo log file is not found in the expected location, recovery continues as if AUTORECOVERY is disabled, by prompting you with the suggested location and name of the subsequent log files that need to be applied.
You must be connected to a database as SYSOPER, or SYSDBA. You cannot be connected via a multi-threaded server.
STARTUP with no arguments is equivalent to STARTUP OPEN.
STARTUP OPEN RECOVER mounts and opens the database even when recovery fails.
To start an instance using the standard parameter file, mount the default database, and open the database, enter
or enterSTARTUP OPEN database
To start an instance using the standard parameter file, mount the default database, and open the database, enterSTARTUP FORCE RESTRICT NOMOUNT
To start an instance using the parameter file TESTPARM without mounting the database, enterSTARTUP PFILE=testparm NOMOUNT
To shutdown a particular database, immediately restart and open it, allow access only to database administrators, and use the parameter file MYINIT.ORA. enterSTARTUP FORCE RESTRICT PFILE=myinit.ora OPEN database
To startup an instance and mount but not open a database, enter