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.

Related Views: