startup

Syntax

Purpose

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: Oracle8i 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.

Requirements

• 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, RMAN mounts and opens the database.

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.

Examples

Opening the Database Using the Default Parameter File

This example starts and opens the database:

startup;

Mounting the Database While Specifying the Parameter File

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;

Related Topics

"alterDatabase"

"shutdown"