Databases Reference
In-Depth Information
Solution
Use the RMAN command
show
to view the current value of one or all of RMAN's configuration settings. The
show
command will let you view the value of a specified RMAN setting. For example, the following
show
command displays
whether the auto backup of the control file has been enabled:
RMAN> show controlfile autobackup;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
RMAN>
The
show all
command displays both settings that you have configured and any default settings. Any default
settings will be displayed with a
# default
at the end of the line. For example, the following is the output from
executing the
show all
command:
RMAN> connect target /
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/db_1/dbs/snapcf_orcl.f'; # default
RMAN>
Table
5-1
lists all the parameters you can use with the
show
command and describes each parameter.
Table 5-1.
Parameters for RMAN's
show
Command
Parameter
Description
all
Shows all parameters
archivelog deletion policy
Shows the archivelog deletion policy
archivelog backup copies
Shows the number of archivelog backup copies
auxname
Shows the auxiliary database information
(
continued
)
