Oracle® Database Recovery Manager Reference 10g Release 1 (10.1) Part Number B10770-02 |
|
|
View PDF |
show::=
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
.
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.Syntax Element | Description |
---|---|
|
Displays all user-entered |
|
Shows the currently configured degree of duplexing for archived redo log backups. |
|
Shows the currently configured archived redo log deletion policy. |
|
Displays the |
|
Displays the |
|
Displays the |
|
Specifies the device type of the channel. For example, |
|
Displays the |
Displays the format for the control file autobackup file for configured devices. |
|
|
Displays the |
|
Displays the configured device types and parallelism settings. If |
|
Displays only the tablespaces that you have specified should be excluded. |
|
Displays the |
|
Displays the settings for |
|
Displays the |
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;
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';