What is STARTUP command?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to
ace your certification exam in first attempt.
STARTUP is a SQL*Plus command that is used to open an Oracle database. A database is opened in three stages. First, an Oracle instance is started. Then, the instance mounts the specified database. Finally, the database is opened.
Syntax:
STARTUP [FORCE] [RESTRICT] [PFILE=filename]
[ MOUNT [dbname] | [ OPEN [READ {ONLY | WRITE [RECOVER]} | RECOVER] [dbname] ] | NOMOUNT ]
where,
FORCE shuts down the currently running Oracle instance and restarts it.
RESTRICT specifies that only the users with the RESTRICTED SESSION system privilege can connect to the database.
PFILE causes the specified parameter file to be used while starting up the instance. If PFILE is not specified, the default STARTUP parameter file is used.
filename specifies the name of the parameter file.
MOUNT mounts the specified database but does not open it.
dbname specifies the name of the database to be mounted or opened. If no database name is specified, it is taken from the DB_NAME initialization parameter.
OPEN mounts and opens the specified database.
READ ONLY opens the specified database in read-only mode.
READ WRITE opens the specified database in read-write mode. It is the default mode.
RECOVER performs media recovery, if necessary, before starting the instance.
NOMOUNT prevents the specified database from being mounted or opened. It cannot be used with MOUNT or OPEN.
Note: The
STARTUP command without any argument is equivalent to the
STARTUP OPEN command.
Other articles
