Database Reference
In-Depth Information
keyword to produce summary output, which is often all you need, as shown in this
example:
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
2 B F X DISK 11-OCT-13 1 1 YES
TAG20131011T142622
11 B F A DISK 18-OCT-13 1 1 YES
TAG20131018T032019
15 B F A DISK 18-OCT-13 1 1 YES
TAG20131018T134250
Now that's a lot easier to read! Here you see that there are three backups of the data-
base, when they were taken, the type, and other interesting information on the backups.
You can get the following details on the various types of backups that you might be tak-
ing with RMAN:
Lists of all backups
Lists of backup-set backups
Lists of archive-log backups
Lists of image copies
Lists of control-file backups
Backups of specific tablespaces or data files
For example, here is a list of the backups of all archive logs. Note that the LIST BACKUP
OF ARCHIVELOG command provides the ability to list specific archive logs based on numerous
criteria, such as a log-sequence number range, time range, and SCN range, or you can just
list them all, as we do in this example:
RMAN> list backup of archivelog all summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1 B A A DISK 11-OCT-13 1 1 YES
TAG20131011T142547
4 B A A DISK 11-OCT-13 1 1 YES
TAG20131011T143308
5 B A A DISK 11-OCT-13 1 1 NO
TAG20131011T143528
Search WWH ::




Custom Search