RMAN LIST Command
to set the date format run the following before executing rman
Windows: set NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ss
linux: export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
List backup summary:
list backup of database summary;
LIST BACKUP SUMMARY;
LIST EXPIRED BACKUP SUMMARY;
list backup summary device type=disk;
list backup summary device type=sbt;
To list all existing backups use:
LIST BACKUP;
LIST BACKUP OF DATABASE;
To list backups with specific TAG:
LIST BACKUPSET TAG 'TAG20210923T210722';
To list all existing backups of a specific datafile use:
RMAN> LIST BACKUP OF DATAFILE 4;
RMAN> LIST BACKUP OF DATAFILE '/u01/app/oradata/TEST/users01.dbf';
To list all existing archivelog backups use:
RMAN> LIST BACKUP OF ARCHIVELOG ALL;
To list all existing controfile backups use:
RMAN> LIST BACKUP OF CONTROLFILE;
To list all existing SPFILE backups use:
RMAN> LIST BACKUP OF SPFILE;
To list all archive logs use:
RMAN> LIST ARCHIVELOG ALL;
To list the contents of an individual backup set use:
RMAN> LIST BACKUPSET 44;
To list all datafile image copies use:
RMAN> LIST DATAFILECOPY ALL;
To list an individual datafile image copy use:
RMAN> LIST DATAFILECOPY 26;
RMAN> LIST DATAFILECOPY '/u01/app/oracle/copy/users01.dbf';
To list all controlfile copies use
RMAN> LIST COPY OF CONTROLFILE;
RMAN> LIST CONTROLFILECOPY 20;
To list backups of a tablespace use the LIST BACKUP OF TABLESPACE command. For example:
RMAN> LIST BACKUP OF TABLESPACE USERS;
The LIST INCARNATION command shows the incarnations of the database. Note that multiple incarnations may share the same database ID.
RMAN> LIST INCARNATION;
|