SHOW

Syntax

show::=

Description of the illustration show.gif

Purpose

To display the current CONFIGURE command settings. The output of SHOW consists of the CONFIGURE commands used to set the configuration. RMAN default configurations are suffixed with #default.

Restrictions and Usage Notes

Execute this command at the RMAN prompt, not in a RUN block.
If SHOW ALL is executed when connected to a target database, only node-specific configurations and database configurations are displayed. Thus, in a standby configuration, SHOW ALL on the primary database or the standby database shows the node-specific configuration for the primary or standby databases, for all values except retention policy, tablespace exclude and auxiliary names.

Keywords and Parameters

Syntax Element	Description
`ALL`	Displays 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`	Displays the `CONFIGURE` `AUXNAME` settings.
`BACKUP` `OPTIMIZATION`	Displays the `CONFIGURE` `BACKUP` `OPTIMIZATION` settings: `ON` or `OFF` (default).
`[AUXILIARY]` `CHANNEL`	Displays 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` displays only channel settings for disk channels.
`CONTROLFILE` `AUTOBACKUP`	Displays the `CONFIGURE` `CONTROLFILE` `AUTOBACKUP` settings: `ON` or `OFF`.
`FORMAT`	Displays the format for the control file autobackup file for configured devices.
`{DATAFILE \| ARCHIVELOG} BACKUP` `COPIES`	Displays the `CONFIGURE` `...` `BACKUP` `COPIES` setting for datafiles and archived redo logs: `1`, `2`, `3`, or `4`.
`[DEFAULT]` `DEVICE` `TYPE`	Displays 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`	Displays the configured default algorithm to use for encryption, when writing encrypted backup sets. Possible values are listed in `V$RMAN_ENCRYPTION_ALGORITHMS`.
`FOR` { `DATABASE` \|`TABLESPACE` }	Displays current encryption settings for the database or for each tablespace.
`EXCLUDE`	Displays only the tablespaces that you have specified should be excluded.
`MAXSETSIZE`	Displays the `CONFIGURE` `MAXSETSIZE` settings.
`RETENTION` `POLICY`	Displays the settings for `CONFIGURE` `RETENTION` `POLICY` for the current target database.
`SNAPSHOT` `CONTROLFILE` `NAME`	Displays the `CONFIGURE` `SNAPSHOT` `CONTROLFILE` settings.

Examples

Showing Channel Configurations: Example This example shows commands relevant for displaying automatic channel configurations:

RMAN> SHOW CHANNEL;
RMAN> SHOW DEVICE TYPE;
RMAN> SHOW DEFAULT DEVICE TYPE;
RMAN> SHOW MAXSETSIZE;

Showing All Configurations: Example This example shows all persistent configurations for the target database (and includes sample output):

RMAN> SHOW ALL;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE DEVICE TYPE "SBT" PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DISK TO 2;
CONFIGURE DATAFILE BACKUP COPIES FOR SBT TO 1; #default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR SBT TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DISK TO 1; # default
CONFIGURE MAXSETSIZE TO 2097152K;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/dbs/cf_snap.f';