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.
 
Search WWH ::




Custom Search