Database Reference
In-Depth Information
Listed next are some other ways in which you can back up the archive redo log files:
RMAN> backup archivelog sequence 300;
RMAN> backup archivelog sequence between 300 and 400 thread 1;
RMAN> backup archivelog from time "sysdate-7" until time "sysdate-1";
If an archive redo log has been removed from disk manually via an OS delete command, RMAN will throw the
following error when attempting to back up the nonexistent archive redo log file:
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
In this situation, first run a
CROSSCHECK
command to let RMAN know which files are physically available on disk:
RMAN> crosscheck archivelog all;
Backing Up FRA
If you use an FRA, one nice RMAN feature is that you can back up all the files in that location with one command. If
you're using a media manager and have a tape backup channel enabled, you can back up everything in the FRA to
tape, like this:
RMAN> backup device type sbt_tape recovery area;
You can also back up the FRA to a location on disk. Use the
TO DESTINATION
command to accomplish this:
RMAN> backup recovery area to destination '/u01/O12C/fra_back';
RMAN will automatically create directories as required beneath the directory specified by the
TO DESTINATION
command.
■
the format of the subdirectory under the directory
TO_DESTINATION
is
db_uniuqe_name/backupset/
YYYY_MM_DD
.
Note
RMAN will back up full backups, incremental backups, control file autobackups, and archive redo log files. Keep
in mind that flashback logs, online redo log files, and the current control file are not backed up.
Excluding Tablespaces from Backups
Suppose you have a tablespace that contains noncritical data, and you don't ever want to back it up. RMAN can be
configured to exclude such tablespaces from the backup. To determine if RMAN is currently configured to exclude any
tablespaces, run this command:
RMAN> show exclude;
RMAN configuration parameters for database with db_unique_name O12C are:
RMAN configuration has no stored or default parameters
