| Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-02 |
|
|
View PDF |
| Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-02 |
|
|
View PDF |
Syntax
show::=
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
{ |
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';
