|SQL*Plus User's Guide and Reference
Command Reference, 45 of 52
Starts an Oracle instance with several options, including mounting and opening a database.
where mount_options requires the following syntax:
Refer to the following list for a description of each term and clause:
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.
If recovery fails using the RECOVER option, the database remains mounted and closed.
Specifies that opening the database should be attempted every five seconds if the instance is busy being recovered by another instance. When an instance is being recovered by another instance, the down instance cannot open the database until recovery is complete. If the database cannot be opened for any other reason, RETRY does not attempt to open the database again. This option is only available for instances operating in PARALLEL mode.
You must be connected to a database as SYSOPER, or SYSDBA. You cannot be connected via a multi-threaded server.
To start an instance using the standard parameter file, mount the default database in exclusive mode, and open the database, enter
To start an instance using the standard parameter file, mount the default database in parallel mode, and open the database, enter
To restart an instance that went down in parallel mode and may not yet have been recovered by other instances, use the RETRY option:
To shutdown the current instance, immediately restart it without mounting or opening, and allow only database administrators to connect, enter
To start an instance using the parameter file TESTPARM without mounting the database, enter
To shutdown a particular database, immediately restart and open it in parallel mode, allow access only to database administrators, and use the parameter file MYINIT.ORA. enter
To startup an instance and mount but not open a database, enter