Instructions frequently used to query RMAN backup information
---- Log on to RMAN
$ RMAN target/
---- View backup information in a simplified format
RMAN> List backup of database summary;
List of backups
====================
Key ty LV s device type completion time # pieces # copies compressed tag
Backup Credit Number Type backup level device type completion time slice Number Image count whether to compress tags
-----------------------------------------------------------------
1054 B 0 a disk 26-may-14 1 1 Yes tag20140526t140012
1055 B 0 a disk 26-may-14 1 1 Yes tag20140526t140012
1062 B 1 A disk 26-may-14 1 1 Yes tag20140526t141509
1063 B 1 A disk 26-may-14 1 1 Yes tag20140526t141509
1069 B 1 A disk 26-may-14 1 1 Yes tag20140526t143009
1070 B 1 A disk 26-may-14 1 1 Yes tag20140526t143009
1076 B 1 A disk 26-may-14 1 1 Yes tag20140526t142139
1077 B 1 A disk 26-may-14 1 1 Yes tag20140526t142139
1082 B 0 a disk 26-may-14 1 1 Yes tag20140526t150011
1083 B 0 a disk 26-may-14 1 1 Yes tag20140526t150011
1090 B 1 A disk 26-may-14 1 1 Yes tag20140526t151509
1091 B 1 A disk 26-may-14 1 1 Yes tag20140526t151509
RMAN> List backup of database;
---- View the specific backup information
---- BS key: Backup set number
---- Type: Backup Type. incr indicates Incremental backup.
---- LV: Backup level, such as Level 1 backup and level 0 backup
---- Size: Size
---- Device type: device type. Disk indicates disk.
---- Elapsed time: Time consumed
---- Completion time: Completion Time
---- BP key: Backup credits
---- Status: Backup status. Available indicates available.
---- Compressed: Indicates whether to compress the data. Yes indicates that the data has been compressed.
---- Tag: tag, which is listed in the time format by default. For example, tag20140526t151509 indicates the backup performed at, January 9, May 26, 2014.
---- Piece name: physical path of the backup part, for example,/backup/level1_25p98sfu_1_1.bak
---- List of datafilesin backup set 1091: list the data file information backed up by the backup Part no. 1091
---- Ckp scn: the SCN Number of the data file
---- CKP time: Production checkpoint time
List of backup Sets
==============================
BS key Type LV Size Device typeelapsed time completion time
-------------------------------------------------------------
1090 incr 1 104.00 K disk 00:00:00 26-may-14
BP key: 1090 status: available compressed: Yes Tag: tag20140526t151509
Piece name:/backup/level%24p98sfu_%1.bak
List of datafiles in backup set 1090
File LV type ckp scn ckptime name
---------------------------------
1 One incr 796838 26-may-14/u01/APP/Oracle/oradata/Metro/system01.dbf
4 1 incr 796838 26-may-14/u01/APP/Oracle/oradata/Metro/users01.dbf
BS key Type LV Size Device typeelapsed time completion time
-------------------------------------------------------------
1091 incr 1 1.15 m disk 00:00:02 26-may-14
BP key: 1091 status: available compressed: Yes Tag: tag20140526t151509
Piece name:/backup/level%25p98sfu_%1.bak
List of datafiles in backup set 1091
File LV type ckp scn ckptime name
---------------------------------
2 1 incr 796842 26-may-14/u01/APP/Oracle/oradata/Metro/undotbs01.dbf
3 1 incr 796842 26-may-14/u01/APP/Oracle/oradata/Metro/sysaux01.dbf
5 1 incr 796842 26-may-14/u01/APP/Oracle/oradata/Metro/example01.dbf
---- Check the continuity of archived logs
RMAN> crosscheck archivelog all;
---- Delete the expired archive. Assume there are running operations.
RMAN> deleteexpired archivelog all;
---- View the archiving information of RMAN backup
RMAN> List backup of archivelog all;
---- View the backup information of the Control File
RMAN> List backup of controlfile;
---- View backup information of the image file
RMAN> List copy;
--- View the backup information of the quota File
RMAN> List backup of spfile;
---- View the physical structure of the database
RMAN> report Schema;
---- View the file information to be backed up
RMAN> report need backup;
---- View RMAN configuration information
RMAN> show all;
---- View outdated backup information
RMAN> report obsolete;
---- View the backup information of the previous day
RMAN> List backup of archivelog untiltime = 'sysdate-1 ';
--- View the backup information of the user tablespace
RMAN> List backup of tablespace users;
---- View the backup information with file number 1
RMAN> List backup of datafile 1;
---- Back up the system tablespace
RMAN> Backup tablespace system;