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';
 
Search WWH ::




Custom Search