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)

Additionally, the RMAN STARTUP command can start an instance in NOMOUNT mode even if no server parameter file or initialization parameter file exists. This feature is useful when you need to restore a lost server parameter file.

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: execute a STARTUP statement in a SQL*Plus session instead.

Keywords and Parameters

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

Syntax Element	Description
STARTUP	If you specify only STARTUP with no other options, then Oracle starts the instance, then mounts and open the database.
FORCE	If the database is open, then FORCE shuts down the database with a SHUTDOWN ABORT statement before re-opening it.If the database is closed, then FORCE opens the database.
NOMOUNT	Starts the instance without mounting the database. If no parameter file exists, then RMAN starts the instance with a "dummy" parameter file. You can then run RESTORE SPFILE to restore a backup server parameter file.
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=/tmp/initTRGT.ora;

Starting an Instance Without a Parameter File: Example

The following example starts an instance without using a parameter file, then runs RESTORE SPFILE:

SET DBID 1447326980;
STARTUP FORCE NOMOUNT; # RMAN starts instance with dummy parameter file
RESTORE SPFILE FROM AUTOBACKUP; # restore a server parameter file
STARTUP FORCE; # restart instance with restored server parameter file