SQL*Plus User's Guide and Reference Release 8.1.6 A75664-01 |
|
Command Reference, 45 of 52
Starts an Oracle instance with several options, including mounting and opening a database. You cannot use STARTUP to start Oracle instances on Oracle 7 servers.
STARTUP [FORCE] [RESTRICT] [PFILE=filename] [EXCLUSIVE] [PARALLEL [RETRY]] [SHARED [RETRY]] [MOUNT [dbname] | OPEN [open_options] [dbname] | NOMOUNT]
where open_options has the following syntax:
READ {ONLY | WRITE [RECOVER]} | RECOVER
Refer to the following list for a description of each term and clause:
FORCE
RESTRICT
PFILE=
filename
EXCLUSIVE
PARALLEL
SHARED
RETRY
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.
MOUNT
dbname
OPEN
NOMOUNT
RECOVER
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 in exclusive mode, and open the database, enter
SQL> STARTUP
or enter
SQL> STARTUP EXCLUSIVE OPEN database
To start an instance using the standard parameter file, mount the default database in parallel mode, and open the database, enter
SQL> STARTUP PARALLEL SQL> STARTUP PARALLEL OPEN database
To restart an instance that went down in parallel mode and may not yet have been recovered by other instances, use the RETRY option:
SQL> STARTUP PARALLEL RETRY
To shutdown the current instance, immediately restart it without mounting or opening, and allow only database administrators to connect, enter
SQL> STARTUP FORCE RESTRICT NOMOUNT
To start an instance using the parameter file TESTPARM without mounting the database, enter
SQL> STARTUP PFILE=testparm NOMOUNT
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
SQL> STARTUP FORCE RESTRICT PFILE=myinit.ora SHARED OPEN database
To startup an instance and mount but not open a database, enter
SQL> CONNECT INTERNAL Connected to an idle instance. SQL> STARTUP MOUNT ORACLE instance started. Total System Global Area 7629732 bytes Fixed Size 60324 bytes Variable Size 6627328 bytes Database Buffers 409600 bytes Redo Buffers 532480 bytes
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|