|
|
RMAN LIST
List the backups and copies recorded in the repository.
Syntax:
LIST { INCARNATION [OF DATABASE [['] database_name [']]] | [EXPIRED] { listObjectSpec [ maintQualifier | RECOVERABLE [untilClause] ]... | recordSpec } }; listObjectSpec::= { BACKUP [OF listObjectList] [listBackupOption] | COPY [OF listObjectList] | archivelogRecordSpecifier } listObjectList::= [ DATAFILE datafileSpec [, datafileSpec]... | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]... | archivelogRecordSpecifier | DATABASE [SKIP TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...] | CONTROLFILE | SPFILE ]... listBackupOption::= [ [BY BACKUP] [VERBOSE] | SUMMARY | BY { BACKUP SUMMARY | FILE } ]
Examples
RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE;
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 BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
RMAN> LIST BACKUPSET OF DATAFILE 1;
"We don't want to go back to tomorrow, we want
to go forward" - Dan
Quale
Related Commands:
BACKUP - Back up database files, archive
logs, backups, or copies.
CHANGE - Update the status of a backup in the RMAN repository.
CROSSCHECK - Check whether backup items still exist.
DELETE - Delete backups from disk or tape
REPORT - Report backup status: database, files, backups
RESTORE - Restore RMAN backups and copies.
Related Views:
RC_BACKUP_SET V$BACKUP_SET Backup sets
RC_BACKUP_SPFILE V$BACKUP_SPFILE Server parameter files in backup sets
RC_BACKUP_FILES V$BACKUP_FILES RMAN backups and copies in the repository.
RC_BACKUP_PIECE V$BACKUP_PIECE Backup pieces Datafiles: RC_TABLESPACE V$TABLESPACE All tablespaces registered in the recovery catalog. RC_DATAFILE V$DATAFILE All datafiles registered in the recovery catalog RC_BACKUP_DATAFILE V$BACKUP_DATAFILE Datafiles in backup sets RC_DATAFILE_COPY V$DATAFILE_COPY Datafile image copies RC_PROXY_DATAFILE V$PROXY_DATAFILE Datafile backups created by proxy copy Control Files: RC_BACKUP_CONTROLFILE V$BACKUP_DATAFILE Control files in backup sets RC_PROXY_CONTROLFILE V$PROXY_DATAFILE Control file backups created by proxy copy RC_CONTROLFILE_COPY V$DATAFILE_COPY Control file copies on disk