SHOW

Purpose

Use the SHOW command to display the CONFIGURE commands used to set the current RMAN configuration for one or more databases. RMAN default configurations are suffixed with #default.

Prerequisites

Execute this command only at the RMAN prompt. Either of the following conditions must be met:

RMAN must be connected to a target database, which must be mounted or open.
RMAN must be connected to a recovery catalog and SET DBID must have been run.

Syntax

show::=

Description of the illustration show.gif

(deviceSpecifier::=)

forDbUniqueNameOption::=

Description of the illustration fordbuniquenameoption.gif

Semantics

Syntax Element	Description
`ALL`	Shows all user-entered `CONFIGURE` commands as well as default configurations.
`ARCHIVELOG BACKUP COPIES`	Shows the currently configured degree of duplexing for archived redo log backups.
`ARCHIVELOG DELETION POLICY`	Shows the currently configured archived redo log deletion policy.
`AUXNAME`	Shows the `CONFIGURE` `AUXNAME` settings.
`BACKUP` `OPTIMIZATION`	Shows the `CONFIGURE` `BACKUP` `OPTIMIZATION` settings: `ON` or `OFF` (default).
`[AUXILIARY]` `CHANNEL`	Shows the `CONFIGURE` `CHANNEL` settings. You can specify a normal channel or an `AUXILIARY` channel.
`FOR` `DEVICE` `TYPE` `deviceSpecifier`	Specifies the device type of the channel. For example, `SHOW` `CHANNEL` `FOR` `DEVICE` `TYPE` `DISK` Shows only channel settings for disk channels.
`COMPRESSION ALGORITHM`	Shows the configured backup compression algorithm.
`CONTROLFILE` `AUTOBACKUP`	Shows the `CONFIGURE` `CONTROLFILE` `AUTOBACKUP` settings: `ON` or `OFF`.
`FORMAT`	Shows the format for the control file autobackup file for configured devices.
`DATAFILE BACKUP` `COPIES`	Shows the `CONFIGURE` `...` `BACKUP` `COPIES` setting for datafiles: `1`, `2`, `3`, or `4`.
`DB_UNIQUE_NAME`	Shows the `DB_UNIQUE_NAME` values known to the recovery catalog.
`[DEFAULT]` `DEVICE` `TYPE`	Shows the configured device types and parallelism settings. If `DEFAULT` is specified, then `SHOW` displays the default device type and settings.
`ENCRYPTION`	Shows currently configured encryption settings for the database or tablespaces within the database, when used with `ALGORITHM` or `FOR` `{DATABASE` \|`TABLESPACE}`.
`ALGORITHM`	Shows the configured default algorithm to use for encryption when writing encrypted backup sets. Possible values are listed in `V$RMAN_ENCRYPTION_ALGORITHMS`.
`FOR` `DATABASE`	Shows current encryption settings for the database.
`FOR` `TABLESPACE`	Shows current encryption settings for each tablespace.
`EXCLUDE`	Shows only the tablespaces that you have specified should be excluded.
`MAXSETSIZE`	Shows the `CONFIGURE` `MAXSETSIZE` settings.
`RETENTION` `POLICY`	Shows the settings for `CONFIGURE` `RETENTION` `POLICY` for the current target database.
`SNAPSHOT` `CONTROLFILE` `NAME`	Shows the `CONFIGURE` `SNAPSHOT` `CONTROLFILE` settings.
`forDbUniqueNameOption`	Shows the configuration in the recovery catalog for a uniquely named database even when RMAN is not connected to this database as `TARGET`. You can specify a database with `db_unique_name` or use `ALL` for all uniquely named databases. The unique name for a database is the value of its `DB_UNIQUE_NAME` initialization parameter setting. The `FOR DB_UNIQUE_NAME` clause is useful for showing the configurations of standby databases in a Data Guard environment. RMAN must be connected to a recovery catalog. RMAN must be connected to a mounted target database or you must identify the target database with `SET` `DBID`. For example, you could run `SET DBID` with the DBID of the target database and then show the configuration for all standby databases known to the recovery catalog (see Example 2-46). See Also: `forDbUniqueNameOption` for descriptions of the options in this clause

Examples

Example 2-139 Showing All Configurations for the Target Database

This example shows all persistent configurations for the target database prod1 (and includes sample output):

RMAN> CONNECT TARGET SYS/password@prod
RMAN> CONNECT CATALOG rman/password@catdb
RMAN> SHOW ALL;
 
RMAN configuration parameters for database with db_unique_name PROD1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/disk1/oracle/dbs/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defa ult
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' 
  PARMS "SBT_LIBRARY=/usr/local/oracle/backup/lib/libobk.so";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/disk1/oracle/dbs/cf_snap .f'