Databases Reference
In-Depth Information
Starting and Shutting Down a Database with RMAN
Problem
You need to start and shut down the Oracle database from the RMAN client during a backup- and recovery-related
task.
Solution
You can both shut down and start up a database using the equivalent of the usual SQL*Plus
startup
and
shutdown
commands from the RMAN client. The following sections show how to issue the
startup
and
shutdown
commands
from RMAN.
Starting a Database
You can use the
startup
command with several options. Here's an example that shows how the database is opened
using the
startup
command:
RMAN> startup
RMAN enables you to do more with the
nomount
option, however. In the following example, you can see how you can
go through all the steps of opening a database: starting the instance, restoring the control file, mounting the control
files, recovering the database, and finally, opening the database. The example shows how to restore the control file
while connected to the recovery catalog. After restoring the control file, the database is mounted with the
alter
database mount
command. Next you see the
recover
command, which is mandatory after restoring a control file.
Finally, the database is opened with the
open resetlogs
option:
RMAN> connect target /
RMAN> connect catalog rman/rman@catdb
RMAN> startup nomount;
RMAN> restore controlfile;
RMAN> alter database mount;
RMAN> recover database;
RMAN> alter database open resetlogs;
The
nomount
option also comes in handy when you lose your spfile or are forced to start the instance without a
spfile (and any init.ora file). You can then use the
nomount
option to start up the database with a dummy parameter
file. For example:
set DBID 1296234570;
startup force nomount; # RMAN will start the instance with a dummy parameter file
If you aren't connected to the recovery catalog, you just need to set the following minimum parameters in the
init{SID}.ora file under the $ORACLE_HOME/dbs directory, as shown here.
•
DB_NAME
•
DB_RECOVERY_FILE_DEST
•
DB_RECOVERY_FILE_DEST_SIZE