Skip Headers

Oracle9i Recovery Manager Reference
Release 2 (9.2)

Part Number A96565-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

RMAN Commands , 51 of 59


SHOW

Syntax

Text description of show.gif follows
Text description of the illustration show.gif


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.

Keywords and Parameters

Syntax Element Description

RETENTION POLICY

Displays the settings for CONFIGURE RETENTION POLICY for the current target database.

[DEFAULT] DEVICE TYPE

Displays the configured device types and parallelism settings. If DEFAULT is specified, then SHOW displays the default device type and settings.

[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.

MAXSETSIZE

Displays the CONFIGURE MAXSETSIZE settings.

{DATAFILE | ARCHIVELOG} BACKUP COPIES

Displays the CONFIGURE ... BACKUP COPIES setting for datafiles and archived redo logs: 1, 2, 3, or 4.

BACKUP OPTIMIZATION

Displays the CONFIGURE BACKUP OPTIMIZATION settings: ON or OFF (default).

SNAPSHOT CONTROLFILE NAME

Displays the CONFIGURE SNAPSHOT CONTROLFILE settings.

AUXNAME

Displays the CONFIGURE AUXNAME settings.

EXCLUDE

Displays only the tablespaces that you have specified should be excluded.

CONTROLFILE AUTOBACKUP

Displays the CONFIGURE CONTROLFILE AUTOBACKUP settings: ON or OFF.

FORMAT

Displays the format for the control file autobackup file for configured devices.

ALL

Displays all user-entered CONFIGURE commands as well as default configurations.

Examples

Showing Channel Configurations: Example

This example shows commands relevant for displaying automatic channel configurations:

SHOW CHANNEL;
SHOW DEVICE TYPE;
SHOW DEFAULT DEVICE TYPE;
SHOW MAXSETSIZE;
Showing All Configurations: Example

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

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback