Common commands for querying rman backup information

Source: Internet
Author: User
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;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.