oracle语法测试在线,oracle10g_rman_语法测试_show专题

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: ExampleThis

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