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';

oracle10g_rman_語法測試_show專題

相關文章