As a DBA We always need to know backup informations for our databases.So I just prepared quick list for some important list backup commands.

– LIST ARCHIVELOG ALL;
– LIST BACKUP OF ARCHIVELOG ALL;
– LIST BACKUP;
– LIST BACKUP OF DATABASE;
– LIST BACKUP SUMMARY;
– LIST BACKUP BY FILE;


– LIST expired Backup of archivelog all summary;
– LIST Backup of tablespace Test summary;
– LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
– LIST Backup of Controlfile;
– LIST Backup of Spfile;
– LIST expired Backup;
– LIST expired Backup summary;
– LIST expired Backup of Archivelog all;
– LIST recoverable backup;

For more informations, please review:
https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta036.htm

Reklam