Databases Reference
In-Depth Information
Once rman starts the database with the dummy parameter file, you can restore the actual spfile from the
autobackup:
restore spfile from autobackup; # restore a server parameter file
startup force; # restart instance with the new server parameter file
After restoring the spfile, you can start the database using that spfile.
You can also use the
dba
option with the
shutdown
command to restrict access to those users who've been
granted the
restricted session
privilege. Here's how:
RMAN> startup dba pfile=/tmp/initprod1.ora;
The database is now open, but only users with the
restricted session
privilege will be able to connect.
Typically DBAs give the
restricted session
privilege only to each other. It gives you a way to do work in the database
while ensuring that no business users are connected.
Shutting Down a Database
Issue the
shutdown
command to close down the database and stop the instance. All the standard SQL*Plus options
you can use with the
shutdown
command—normal, immediate, abort, and transactional—have the same effect and
meaning when used from within RMAN. Here's an example:
RMAN> shutdown immediate;
RMAN> startup mount;
RMAN> backup database;
RMAN> alter database open;
This example shuts down the database, kicking off any current users as soon as their currently executing SQL
statements finish. The database is then backed up and reopened for use.
How It Works
All the
shutdown
and
startup
commands shown here pertain only to the target database. You can't start and stop the
recovery catalog instance from RMAN. The only way to start up and shut down the recovery catalog instance is by
connecting to the recovery catalog database as the target database and by issuing the relevant commands to start or
stop the instance.
Checking the Syntax of RMAN Commands
Problem
You want to check the syntax of your RMAN commands without actually executing the commands.