Oracle9i Recovery Manager Reference Release 2 (9.2) Part Number A96565-01 |
|
RMAN Commands , 51 of 59
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
.
Execute this command at the RMAN prompt.
Syntax Element | Description |
---|---|
|
Displays the settings for |
|
Displays the configured device types and parallelism settings. If |
|
Displays the |
|
Specifies the device type of the channel. For example, |
|
Displays the |
|
Displays the |
|
Displays the |
|
Displays the |
|
Displays the |
|
Displays only the tablespaces that you have specified should be excluded. |
|
Displays the |
Displays the format for the control file autobackup file for configured devices. |
|
|
Displays all user-entered |
This example shows commands relevant for displaying automatic channel configurations:
SHOW CHANNEL; SHOW DEVICE TYPE; SHOW DEFAULT DEVICE TYPE; SHOW MAXSETSIZE;
This example shows all persistent configurations for the target database (and includes sample output):
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';
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|