Common commands for querying rman backup information

Common commands for querying rman backup information ---- log on to rman $ rmantarget ---- view backup information in simplified format RMANlistbackupofdatabasesummary; ListofBackupsKeyTYLVSDeviceTypeCompletionTime # Pieces # CopiesCompressedTag backup item type

Common commands for querying rman backup information ---- log on to rman $ rman target/---- and view the backup information in simplified format: RMAN list backup of database summary; list of Backups ================== Key ty lv s Device Type Completion Time # Pieces # Copies Compressed Tag backup title number Type

Common commands for querying 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 number 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 backup details

---- 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. If any operation is performed

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 parameter 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;