Oracle: Rman show command parameters

to check the rman configuration settings, SHOW is very important . there is a lot of parameter that show supports. let us check one by one:

==>RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters 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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFLION.ORA'; # default

show all will show all the rman configuration settings which include both the default settings as well as what you have configured . You can identify the default settings by "# default" at the end of every line.

==>RMAN> show controlfile autobackup;

RMAN configuration parameters are:
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

shows whether control file will be backup up automatically after any backup operation by rman.default value is OFF.

==>RMAN> show archivelog deletion policy;

RMAN configuration parameters are:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

shows the archive log detention policy.

==>RMAN> show archivelog backup copies;

RMAN configuration parameters are:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

shows the number of archivelog backup copies

==>RMAN> show auxname;

RMAN configuration parameters are:
RMAN configuration has no stored or default parameters

shows the auxiliary database information.

==>RMAN> show backup optimization;

RMAN configuration parameters are:
CONFIGURE BACKUP OPTIMIZATION OFF; # default

shows whether backup optimization is on or off.

==>RMAN> show controlfile autobackup format;

RMAN configuration parameters are:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

shows what will be the format of auto backed up control file .

==>RMAN> show datafile backup copies;

RMAN configuration parameters are:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
shows how many datafile backup copies will be kept by rman

==>RMAN> show default device type;

RMAN configuration parameters are:
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

shows whether the default device type is disk or tape

==>RMAN> show retention policy;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

Shows policy for datafile and control file backups and copies that RMAN marks as obsolete.

==>RMAN> show encryption algorithm;

RMAN configuration parameters are:
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

shows which encryption algorithm is currently is use.

==>RMAN> show encryption for database;[or for tablespace]

RMAN configuration parameters are:
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

shows the encryption for the database or every tablespace.

More:
show exclude; (will show which tablespaces are excluded from backup)
show maxsetsize; (shows the max size of backup set. the default is unlimited)
show snapshot controlfile name; (shows the snapshot control file name)
show compression algorithm; (shows compression algorithm . default is ZLIB)
show channel for device type disk; [device type sbt](shows the channel for device type)

NOTE: If you have changed the default value of any rman parameters , you can get the parameter name and the values from v$rman_configuration view .
ex:
step 1:
RMAN> show controlfile autobackup;

RMAN configuration parameters are:
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

so, it is off now.and it is default
step 2:
sys@LION> select * from v$rman_configuration;
no rows selected

step 3:
RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

Changing the default value off to on.
step 4:
sys@LION> select * from v$rman_configuration;

CONF# NAME VALUE
---------- ------------------------------ ------------------------------
1 CONTROLFILE AUTOBACKUP ON

So , hope it is clear now.


Thanks,
have a nice day....