Recovery Manager Command Syntax

startup

To start the 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: To learn how to start up and shut down a database, see the Oracle8i Administrator's Guide. For SQL*Plus STARTUP syntax, see the SQL*Plus User's Guide and Reference.

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.

If you do not specify any options, RMAN mounts and opens the database.

This example starts and opens the database:

startup;

This example forces a shutdown abort and then mounts the database with restricted access, specifying a non-default parameter file location:

startup force mount dba pfile=t_init1.ora;

force	executes either of these operations: If the database is open, this option first shuts down the database with a shutdown abort statement before re-opening it. If the database is closed, this option opens the database.
nomount	starts the instance without mounting the database.
mount	starts the instance, then mounts the database without opening it. If you specify neither the mount nor nomount options, the startup command opens the database.
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, the default `init.ora` filename is used.