STARTUP

Syntax

Text description of the illustration startup.gif

Purpose

To start the target database from within the RMAN environment. This command is equivalent to using the SQL*Plus STARTUP command. You can:

• Start the instance without mounting a database.

• Start the instance and mount the database, but leave it closed.

• Start the instance, and mount and open the database in:
  • unrestricted mode (accessible to all users)

  • restricted mode (accessible to DBAs only)

    See Also: Oracle9i Database Administrator's Guide to learn how to start up and shut down a database, and SQL*Plus User's Guide and Reference for SQL*Plus STARTUP syntax

Restrictions and Usage Notes

• Execute this command either at the RMAN prompt or within the braces of a RUN command.

• You cannot use the RMAN STARTUP command to open the recovery catalog database. To start this database, start a SQL*Plus session and execute a STARTUP statement.

Keywords and Parameters

If you do not specify any options, then RMAN mounts and opens the database with the default server parameter file.

STARTUP	If you specify only STARTUP with no other options, then Oracle starts the instance, then mounts and open the database.
FORCE	Executes either of these operations: If the database is open, then this option first shuts down the database with a SHUTDOWN ABORT statement before re-opening it. If the database is closed, then this option opens the database.
NOMOUNT	Starts the instance without mounting the database.
MOUNT	Starts the instance, then mounts the database without opening it
DBA	Restricts access to the database to users with the RESTRICTED SESSION privilege.
PFILE = 'filename'	Specifies the filename of the init.ora file for the target database. If this parameter is not specified, then the default init.ora filename is used.

Examples

Opening the Database by Using the Default Parameter File: Example

This example starts and opens the database:

STARTUP;

Mounting the Database While Specifying the Parameter File: Example

This example forces a SHUTDOWN ABORT and then mounts the database with restricted access, specifying a nondefault parameter file location:

STARTUP FORCE MOUNT DBA PFILE=t_init1.ora;