Databases Reference
In-Depth Information
If the control file autobackup feature is turned off, RMAN
won't
automatically include the control file in the
database backup. To force RMAN to include a backup of the current control file in the backup in such a situation, you
must add the
include current controlfile
clause to your
backup
command, as shown here:
RMAN> backup database
2> include current controlfile;
The previous command will back up all the data files, the control file, and the spfile. You can't add the
include current controlfile
clause to a backup that includes the archived redo logs. You can use the clause only
in a data file backup.
Backing Up Recovery Files in the FRA
Problem
You want to back up all the recovery files located in the fast recovery area of a database so that you can store them
offline on tape.
Solution
Use either the
recovery area
clause or the
db_recovery_file_dest
clause with your
backup
command to back
up all the recovery files for a database (
recovery area
and
db_recovery_file_dest
are synonymous). To back up
the recovery files in the fast recovery area, use the following command (you must first configure sbt as the backup
channel):
RMAN> backup recovery area;
If the default device type is disk, you may issue the following command instead to back up the fast recovery area:
RMAN> backup device type sbt recovery area;
By adding the subclause
destination
to the
backup recovery area
command, you can specify a disk channel as
the location for the backing up of the recovery area files.
RMAN> backup recovery area to destination '/u01/app/oracle/backup';
Both of the previous commands will back up recovery files that were created not only in the current fast recovery
area but also in all previous fast recovery area locations.
If you want to back up the recovery files located in all locations, not merely the fast recovery area, use the
following command instead after configuring a tape backup channel:
RMAN> backup recovery files;
If the default device type is disk, then you may issue the following RMAN command instead:
RMAN> backup device type sbt recovery files;
By adding the subclause
destination
to the
backup recovery files
command, you can specify a disk channel
as the location for the backing up of the recovery area files:
RMAN> backup recovery files to destination '/u01/app/oracle/backup';