Databases Reference
In-Depth Information
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
20-AUG-12 130 A 1 1 NO TAG20120820T113325
RMAN>
The
list backup by file
command groups all backups by file and lists all data files, their backup sets, and any
proxy copies.
How It Works
You can use the
list
command to list the following:
•
Backup pieces, image copies, and proxy copies of databases, tablespaces, data files, archived
redo logs, and the control file
•
Expired backups
•
Using the
list
command isn't the only way to view the status of RMAN backups. You can also check backup
status by querying the recovery catalog views RC_DATAFILE_COPY, RC_ARCHIVED_LOG, and V$BACKUP_FILES.
You can also get the output of the
list
command in a summarized form by specifying the keyword
summary
when
using the
list
command, as shown here:
Backups classified by time period, recoverability, path name, device type, or tag
RMAN> list backup summary; # lists backup sets, proxy copies, and image copies
RMAN> list expired backup summary; # lists expired backups in summary form
You can use optional clauses with the
list
command to narrow down your search of backup information or
to list only a specific type of backup. Here are some of the important optional clauses you can employ with the
list
command, with examples showing how to use those clauses.
This command lists only backup sets and proxy copies but not image copies:
RMAN> list backupset;
This command lists only data file, archived redo log, and control file copies:
RMAN> list copy;
This command lists a particular data file copy:
RMAN> list datafilecopy '/a01/app/oracle/users01.dbf';
This command lists backups by tag:
RMAN> list backupset tag 'weekly_full_db_backup';
This command lists backups according to when the backup was made:
RMAN> list copy of datafile 1 completed between '01-JAN-2012' AND '15-JAN-2012';
