Thursday, 28 April 2011

RMAN list commands

IST BACKUP;
LIST BACKUP OF DATABASE;
LIST BACKUP SUMMARY;
LIST INCARNATION;
LIST BACKUP BY FILE;
LIST COPY OF DATABASE ARCHIVELOG ALL;
LIST COPY OF DATAFILE 1, 2, 3;
LIST BACKUP OF DATAFILE 11 SUMMARY;
LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
LIST BACKUPSET OF DATAFILE 1;
LIST BACKUP OF ARCHIVELOG all;
LIST EXPIRED BACKUP;

 list backup of database completed between '01-MAY-07' and '07-MAY-07' ;

 list backup of database;

 list backup of database summary completed between '01-MAY-07' and '07-MAY-07';

 list backup of archivelog all;

list backup of archivelog from time  '05-MAY-07';

list backup of archivelog high sequence=10796;

list backup of archivelog low sequence=10796;
      LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 10966;
list backup of archivelog from time '26-JUN-07';
backup archivelog until time 'SYSDATE-6' delete input;
backup archivelog sequence between 6 and 29 delete input;
list backup of archivelog time between '17-JUN-07' and '18-JUN-07';
list backup of database summary TAG 'clone_db_bk_full';
list backupset completed between '25-OCT-07' and '30-OCT-07' TAG 'clone_db_bk_full';

No comments:

Post a Comment