查询rman备份信息常用指令 —-登陆到rman $rman target / —-以精简的格式查看备份信息 RMAN list backup of database summary; List of Backups =============== Key TY LV S Device Type Completion Time#Pieces #Copies Compressed Tag 备份片号 类型
查询rman备份信息常用指令
—-登陆到rman
$rman target /
—-以精简的格式查看备份信息
RMAN> list backup of database summary;
List of Backups
===============
Key TY LV S Device Type Completion Time#Pieces #Copies Compressed Tag
备份片号 类型 备份级别 设备类型 完成时间 片数 镜像数 是否压缩 标签
——- — — ———— ————— ——- ——- ———- —
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 TAG20140526T151
本文来源gao!%daima.com搞$代*!码$网9
509
RMAN> list backup of database;
—-查看备份详细信息
—-BS Key：备份集号
—-Type：备份类型，Incr代表增量备份
—-LV：备份级别，如1级备、0级备份
—-Size：大小
—-Device Type：设备类型，DISK代表磁盘
—-Elapsed Time：消耗时间
—-Completion Time：完成时间
—-BP Key：备份片号
—-Status: 备份状态，AVAILABLE代表可用
—-Compressed: 是否压缩，YES代表已经压缩
—-Tag:标签，默认会以时间格式列出，如 TAG20140526T151509代表2014年5月26日，15:15进行的备份
—-Piece Name: 备份片的物理路径，如/backup/level1_25p98sfu_1_1.bak
—-List of Datafilesin backup set 1091：列出1091号备份片备份的数据文件信息
—-Ckp SCN：数据文件的scn号
—-Ckp Time：生产检查点时间
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
—-检查归档日志的连续性
RMAN> crosscheck archivelog all;
—-删除过期的归档，如果有执行操作
RMAN> deleteexpired archivelog all;
—-查看rman备份的归档信息
RMAN> list backup of archivelog all;
—-查看控制文件的备份信息
RMAN> list backup of controlfile;
—-查看镜像文件的备份信息
RMAN> list copy;
—查看参数文件的备份信息
RMAN> list backup of spfile;
—-查看数据库物理结构
RMAN> report schema;
—-查看需要备份的文件信息
RMAN> report need backup;
—-查看rman配置信息
RMAN> show all;
—-查看过时的备份信息
RMAN> report obsolete;
—-查看前1天的备份信息
RMAN> list backup of archivelog untiltime ='sysdate -1';
—查看user表空间的备份信息
RMAN> list backup of tablespace users;
—-查看文件号为1的备份信息
RMAN> list backup of datafile 1;
—-备份system表空间
RMAN> backup tablespace SYSTEM;
转载请注明原文链接：查询rman备份信息常用指令
