Common instructions for querying Rman backup information

Common instructions for querying Rman backup information

----Landing to Rman

$rman Target/

----View backup information in a streamlined format

Rman> list Backup of database summary;

List of Backups

===============

Key TY LV S Device Type completion time#pieces #Copies compressed TAG

Backup slice number Type backup level device type finish time slice number of mirrors whether to compress labels

------- -- -- ------------ --------------- ------- ------- ---------- ---

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 tag20140526t144509

1077 B 1 A DISK 26-may-14 1 1 YES tag20140526t144509

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 on behalf of incremental backups

----LV: Backup level, such as Level 1 standby, Level 0 backup

----Size: Sizes

----Device Type: Device types, disk represents disks

----Elapsed Time: Consuming

----Completion time: Finish

----BP Key: Backup piece number

----Status: Backup status, available representative available

----COMPRESSED: Compressed, yes represents already compressed

----Tag: The default is listed in time format, such as tag20140526t151509 on behalf of the May 26, 2014, 15:15 Backup

----Piece Name: The physical path of the backup slice, such as/backup/level1_25p98sfu_1_1.bak

----List of Datafilesin backup set 1091: List the data file information for backup of the 1091th number

----CKP SCN: The SCN number of the data file

----CKP time: Production Check point times

List of Backup Sets

===================

BS Key Type LV Size Device typeelapsed Time Completion time

------- ---- -- ---------- ----------------------- ---------------

1090 INCR 1 104.00K DISK 00:00:00 26-may-14

BP key:1090 status:available Compressed:yes tag:tag20140526t151509

Piece Name:/backup/level1_24p98sfu_1_1.bak

List of Datafiles in backup set 1090

File LV Type Ckp SCN ckptime Name

---- -- ---- ---------- --------- ----

1 1 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.15M DISK 00:00:02 26-may-14

BP key:1091 status:available Compressed:yes tag:tag20140526t151509

Piece Name:/backup/level1_25p98sfu_1_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 the archive log

Rman> crosscheck Archivelog All;

----Delete an expired archive if there is an action to be performed

Rman> deleteexpired Archivelog All;

----View archived information for Rman backups

Rman> list Backup of Archivelog all;

----View backup information for control files

Rman> list Backup of Controlfile;

----View backup information for mirrored files

rman> list copy;

---View backup information for parameter files

Rman> list Backup of SPFile;

----View the physical structure of the database

Rman> a schema;

----View the file information that needs to be backed up

Rman> need backup;

----View Rman configuration information

Rman> Show All;

----View outdated backup information

rman> obsolete;

----View backup information for the first 1 days

Rman> list Backup of archivelog untiltime = ' sysdate-1 ';

---View backup information for the user table space

Rman> list Backup of tablespace users;

----View backup information with a file number of 1

Rman> list Backup of datafile 1;

----Backup system table Space

rman> backup tablespace SYSTEM;