RMAN Show clause

Display the currently enabled CONFIGURE commands.

Syntax:

   SHOW 
   { RETENTION POLICY 
   | [DEFAULT] DEVICE TYPE 
   | [AUXILIARY] CHANNEL [FOR DEVICE TYPE deviceSpecifier] 
   | MAXSETSIZE 
   | { DATAFILE | ARCHIVELOG } BACKUP COPIES 
   | BACKUP OPTIMIZATION 
   | SNAPSHOT CONTROLFILE NAME 
   | AUXNAME 
   | EXCLUDE
   | CONTROLFILE AUTOBACKUP [FORMAT] 
   | ALL
   };

Examples

SHOW RETENTION POLICY;
SHOW DEVICE TYPE;
SHOW DEFAULT DEVICE TYPE;
SHOW CHANNEL;
SHOW MAXSETSIZE;

SHOW ALL;

Related Commands:

CHANGE - Update the status of a backup in the RMAN repository.
CONFIGURE
- Persistent RMAN settings.
CROSSCHECK
- Check whether backup items still exist.
LIST - List backups and copies
REPORT
- Report backup status: database, files, backups
SET
- Settings for the current RMAN session.


© Copyright SS64.com 1999-2013
Some rights reserved