Databases Reference
In-Depth Information
Table 5-1.
(
continued
)
Parameter
Description
backup optimization
Shows whether optimization is on or off
[
auxiliary] channel
Shows how the normal channel and auxiliary channel are configured
channel for device type [disk |
Shows the characteristics of the channel
<media device>;
controlfile autobackup
Shows whether auto backup is on or off
controlfile autobackup format
Shows the format of the auto backup control file
datafile backup copies
Shows the number of data file backup copies being kept
default device type
Shows the default type (disk or tape)
encryption algorithm
Shows the encryption algorithm currently in use
encryption for [database | tablespace]
Shows the encryption for the database and every tablespace
Exclude
Shows the tablespaces excluded from the backup
Maxsetsize
Shows the maximum size for backup sets. The default is unlimited
retention policy
Shows the policy for data file and control file backups and copies
that RMAN marks as obsolete
snapshot controlfile name
Shows the snapshot control filename
compression algorithm
Shows the compression algorithm in force. The default is the ZLIB
algorithm
■
Note
You can also display nondefault RMAN configuration settings by querying the v$RMAN_CoNfiguRAtioN view.
To simplify ongoing use of RMAN, you can set several persistent configuration settings for each target database.
These settings control many aspects of RMAN behavior. For example, you can configure the backup retention policy,
default destinations for backups, default backup device type, and so on.
How It Works
The
show
command queries the target database control file to retrieve RMAN configuration settings. You can use the
configure
command to view and change RMAN configurations.
Configuration settings are stored in the target database control file regardless of whether you are using a recovery
catalog. Once configured, settings persist until you change them again.
Because RMAN settings are stored in the control file, your target database must be mounted or open when
issuing the
show
command.
The
show all
command reveals the present configuration regarding several important RMAN backup and
recovery settings. The following list summarizes the meaning of the most important of these settings, shown by
issuing the
show all
command:
configure retention policy to redundancy 1
means that RMAN retains only one set of
backup copies.
•
configure backup optimization off
means that by default RMAN won't skip the backing
up of unchanged data blocks in the data files.
•
