RMAN LIST

List the backups and copies recorded in the repository. Some options below require the Data Recovery Advisor introduced in 11g (List Failure, List Restore Point.)

Syntax:

 LIST DB_UNIQUE_NAME ALL 
LIST DB_UNIQUE_NAME OF DATABASE [['] database_name [']] LIST [EXPIRED] {archivelogRecordSpecifier [ { {maintQualifier | RECOVERABLE [untilClause} }…] [forDbUniqueNameOption] LIST [EXPIRED] {BACKUP [OF listObjectList] [BY BACKUP] [VERBOSE] [ { {maintQualifier | RECOVERABLE [untilClause} }…] [forDbUniqueNameOption] LIST [EXPIRED] {BACKUP [OF listObjectList] SUMMARY [ { {maintQualifier | RECOVERABLE [untilClause} }…] [forDbUniqueNameOption] LIST [EXPIRED] {BACKUP [OF listObjectList] BY { BACKUP SUMMARY | FILE } [ { {maintQualifier | RECOVERABLE [untilClause} }…] [forDbUniqueNameOption] LIST [EXPIRED] {COPY [OF listObjectList] [ { {maintQualifier | RECOVERABLE [untilClause} }…] [forDbUniqueNameOption] LIST [EXPIRED] recordSpec [forDbUniqueNameOption]; LIST FAILURE [ {ALL | CRITICAL | HIGH | LOW | failureNumber [, failureNumber]…} [EXCLUDE FAILURE failureNumber [, failureNumber]…] [DETAIL] LIST FAILURE [CLOSED] [ {ALL | CRITICAL | HIGH | LOW | failureNumber} ] [EXCLUDE FAILURE failureNumber [, failureNumber]…] [DETAIL] LIST INCARNATION [OF DATABASE [['] database_name [']]] LIST RESTORE POINT restore_point_name [forDbUniqueNameOption] LIST RESTORE POINT ALL [forDbUniqueNameOption]

LIST ALL SCRIPT NAMES
LIST GLOBAL SCRIPT NAMES forDbUniqueNameOption::=
FOR DB_UNIQUE_NAME ALL
FOR DB_UNIQUE_NAME 'db_unique_name' 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 ARCHIVELOG ALL;
RMAN> LIST BACKUP OF ARCHIVELOG ALL;
RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE;
RMAN> LIST BACKUP OF DATAFILE 1;
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;
RMAN> LIST FAILURE;
RMAN> LIST FAILURE 641231 detail;

“I see no reason for recording the obvious” - Edward Weston

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.
ADVISE FAILURE - Display repair options (11g Data Recovery Advisor)
REPAIR FAILURE - Repair database failures (11g Data Recovery Advisor)

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


© Copyright SS64.com 1999-2013
Some rights reserved