Tuesday 22 October 2013

List Commands Examples in RMAN:



RMAN> LIST ARCHIVELOG ALL;

RMAN> LIST BACKUP OF ARCHIVELOG ALL;

RMAN> LIST BACKUP;

RMAN> LIST BACKUP OF DATABASE;

RMAN> LIST BACKUP OF DATAFILE 1;

RMAN> LIST BACKUP SUMMARY;

RMAN> LIST INCARNATION;

RMAN> LIST BACKUP BY FILE;

RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;

RMAN> LIST COPY OF DATAFILE 1, 2, 3;

RMAN> LIST BACKUP OF DATAFILE 11 SUMMARY;

RMAN> LIST expired Backup of archivelog all summary;

RMAN> LIST Backup of tablespace Test summary;

RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;

RMAN> LIST CONTROLFILECOPY “/tmp/cntrlfile.copy”;

RMAN> LIST BACKUPSET OF DATAFILE 1;

RMAN> LIST FAILURE;

RMAN> LIST FAILURE 641231 detail;

RMAN> LIST Backup of Controlfile;

RMAN> LIST Backup of Spfile;

RMAN> LIST Backup of Tablespace Test;

RMAN> LIST expired Backup;

RMAN> LIST expired Backup summary;

RMAN> LIST expired Backup of Archivelog all;

RMAN> LIST expired Backup of datafile 10;

RMAN> LIST recoverable backup;

No comments:

Post a Comment