Oracle8i Backup and Recovery Guide
Release 8.1.5

A67773-01

Library

Product

Contents

Index

Prev Prev Next


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:

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.

Requirements

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"




Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index