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 and default configurations.
`ARCHIVELOG BACKUP COPIES`	Shows the currently configured degree of duplexing for archived redo log backups.
`ARCHIVELOG DELETION POLICY`	Shows the `CONFIGURE` `ARCHIVELOG DELETION POLICY` setting.
`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 data files: `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 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-55). See Also: `forDbUniqueNameOption` for descriptions of the options in this clause

Examples

Example 3-56 Showing All Configurations for a Target Database

Assume that you want to know all persistent RMAN configurations for a target database. You start the RMAN client, CONNECT to the target database and recovery catalog, and run the SHOW command as follows (sample output included):

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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; 
  # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/disk1/oracle/dbs/cf_snap .f'