rman_list命令列举

rman有好多列出命令，老是记不得太准确，笔记列出来，方便查阅使用

1.list incarnation; 
2.list backup; 
3.list backup summary; 
4.list backup of database summary; 
5.list backup of tablespace summary; 
6.list backup of datafile n,n summary; 
7.list backup of archivelog all summary; 
8.list backup by file; 
9.list expired backup; 
10.list copy; 
11.list backup of spfile; 
12.list backup of controlfile; 
13.list backup datafile n,n,n; 
14.list backup tablespace tablespace_name; 

15.list archivelog all;
16.list backup of archivelog all; 
17.list backup of archivelog from scn ...; 
18.list backup of archivelog until scn ...; 
19.list backup of archivelog from sequence ..; 
20.list backup of archivelog until time 'sysdate-10'; 
21.list backup of archivelog {all, from, high, like, logseq, low, scn, sequence, time, until}; 

//后面跟的是解释

 //可用恢复目录数据库原型列表

RMAN> list incarnation (具体化);

starting full resync of recovery catalog
full resync complete

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS    Reset SCN  Reset Time
-------      -------      --------      ----------------        ---              ----------    ----------
1                2            TEST     2102674174    CURRENT   1             12-JAN-13

//DBID是数据库对应的唯一代码

//STATUS 如果数据库有被多次用 RESETLOGS 打开的话，这里会有 多 条记录,值可以是parent,current,orphan(孤立,在resetlog命令之后进行恢复)

//Reset SCN 表示数据库被重新创建的时刻点

//Inc Key可能会不一样不使用恢复目录（例子中是2，不使用恢复目录我的实验中是1）

//列出已有备份集的详细信息，包括datafiles,control files,archivelog

//RMAN> backup as compressed backupset full database;

RMAN> list backup;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
477     Full    155.17M    DISK        00:00:35     31-JAN-13
BP Key: 479   Status: AVAILABLE  Compressed: YES  Tag: TAG20130131T00142
5
        Piece Name: D:\ORACLE\PRODUCT\10.2.0\DB_1\FLASH_RECOVERY_AREA\TEST\BACKU
PSET\2013_01_31\O1_MF_NNNDF_TAG20130131T001425_8JLKQ1PH_.BKP
  List of Datafiles in backup set 477
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1233539    31-JAN-13 D:\ORADATA\TEST\SYSTEM01.DBF
  2       Full 1233539    31-JAN-13 D:\ORADATA\TEST\UNDOTBS01.DBF
  3       Full 1233539    31-JAN-13 D:\ORADATA\TEST\SYSAUX01.DBF
  4       Full 1233539    31-JAN-13 D:\ORADATA\TEST\USERS01.DBF
  5       Full 1233539    31-JAN-13 D:\ORADATA\TEST\TEST01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
478     Full    1.03M      DISK        00:00:02     31-JAN-13
BP Key: 480   Status: AVAILABLE  Compressed: YES  Tag: TAG20130131T00142
5
        Piece Name: D:\ORACLE\PRODUCT\10.2.0\DB_1\FLASH_RECOVERY_AREA\TEST\BACKU
PSET\2013_01_31\O1_MF_NCSNF_TAG20130131T001425_8JLKR6HJ_.BKP
  Control File Included: Ckp SCN: 1233555      Ckp time: 31-JAN-13
  SPFILE Included: Modification time: 30-JAN-13

//列出备份的概要信息

RMAN> list backup summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies CompressedTag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
309     B  F  A DISK        30-JAN-13       1       1       NO         TAG20130130T181336
310     B  F  A DISK        30-JAN-13       1       1       NO         TAG20130130T181336
342     B  A  A DISK        30-JAN-13       1       1       NO         TAG20130130T181542

//KEY：表示backupset主键标识
//TY：B[Backup] 表示备份
//LV：F[Full] 表示完全备份，A[Archivelog]， 0,1,2 表示incremental level备份
//S 列说明备份的状态： A 表示Available，X 表示Expired.
//Device Type:  说明备份的设备是磁带还是磁盘

这个命令可以派生出以下4行命令

RMAN> list backup of database summary;
RMAN> list backup of archivelog all summary;
RMAN> list backup of tablespace users summary;

RMAN> list backup of datafile 2,3,4 summary;

//按文件类型列出备份

RMAN> list backup by file;
List of Datafile Backups
========================

File Key     TY LV S Ckp SCN    Ckp Time  #Pieces #Copies Compressed Tag
---- ------- -  -- - ---------- --------- ------- ------- ---------- ---
1    477     B  F  A 1233539    31-JAN-13 1       1       YES        TAG20130131
T001425
2    477     B  F  A 1233539    31-JAN-13 1       1       YES        TAG20130131
T001425
3    477     B  F  A 1233539    31-JAN-13 1       1       YES        TAG20130131
T001425
4    477     B  F  A 1233539    31-JAN-13 1       1       YES        TAG20130131
T001425
5    477     B  F  A 1233539    31-JAN-13 1       1       YES        TAG20130131
T001425

List of Control File Backups
============================

CF Ckp SCN Ckp Time  BS Key  S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
1233555    31-JAN-13 478     A 1       1       YES        TAG20130131T001425
List of SPFILE Backups
======================

Modification Time BS Key  S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
30-JAN-13         478     A 1       1       YES        TAG20130131T001425

 

//列出到期的备份列表

RMAN> list expired backup;

RMAN> list expired backup of datafile 5;

RMAN> list expired backup of archivelog all;

RMAN> list expired backup of archivelog until sequence 50;

RMAN> list expired backup of archivelog until time "to_date('2013-01-30','yyyy-m
m-dd')";

//列出用于恢复的备份列表

RMAN> list recoverable backup of database;

 

//按表空间列出，如果没有表空间备份会列出上级备份

RMAN> list backup of tablespace users;

//按文件号列出文件备份

RMAN> list backup of datafile 5;

 

//列出控制文件或参数文件备份列表

RMAN> list backup of controlfile;

RMAN> list backup of spfile;

 

//列出当前存在的归档日志备份

RMAN> list archivelog all;

//列出可用归档日志备份详情

RMAN> list backup of archivelog all;
//使用日志序列号或日期限制显示内容

RMAN> list  backup of archivelog until sequence 50;

RMAN> list  backup of archivelog until time "to_date('2013-01-30','yyyy-m
m-dd')";

 

//列出映像，日志文件备份可以视为COPY，COPY关键字使用上可代替BACKUP的位置

RMAN> list copy;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25843472/viewspace-753601/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25843472/viewspace-753601/