oracle 列出备份文件路径,RMAN备份、恢复实验室 之 备份篇 【查看备份情况】

概要：

查看备份集

查看SCHEMA统计信息

查看表空间的备份情况

查看数据文件的备份情况

查看控制文件的备份情况

查看不同类型设备上的备份情况

查看归档日志及其备份情况

查看系统中不存在(或者说是不在指定路径下)的备份

查看过期的备份

查看几天前的schema状态

查看需要备份的文件

查看违反规则的备份

操作命令：

查看备份集：

RMAN> list backupset;

List of Backup Sets

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

1       Full    9.36M

DISK        00:00:03

02-AUG-13

BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20130802T014453

Piece Name:

/oracle/app/oracle/product/11.2.0/db_1/dbs/02og8fcm_1_1

SPFILE Included: Modification

time: 02-AUG-13

SPFILE db_unique_name: ORCL

Control File Included: Ckp SCN:

1181185      Ckp time: 02-AUG-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

2       Full    9.36M

DISK        00:00:01     02-AUG-13

BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20130802T014548

Piece

Name: /oracle/app/oracle/product/11.2.0/db_1/dbs/04og8fed_1_1

SPFILE Included: Modification

time: 02-AUG-13

SPFILE db_unique_name:ORCL                              ----------------数据库名

Control File Included: Ckp SCN:

1181217      Ckp time: 02-AUG-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

3       Full    1.01G

DISK        00:02:24     02-AUG-13

BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130802T015052

Piece Name:

/oracle/app/oracle/product/11.2.0/db_1/dbs/05og8fns_1_1

List of Datafiles in backup set

3

File LV

Type Ckp SCN    Ckp Time  Name    -----------level type 跟增量备份有关

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

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

1       Full 1181392    02-AUG-13

/oracle/app/oradata/ORCL/datafile/o1_mf_system_8xm4839m_.dbf

2       Full 1181392    02-AUG-13 /oracle/app/oradata/ORCL/datafile/o1_mf_sysaux_8xm483f7_.dbf

3       Full 1181392    02-AUG-13

/oracle/app/oradata/ORCL/datafile/o1_mf_undotbs1_8xm483gd_.dbf

4       Full 1181392    02-AUG-13

/oracle/app/oradata/ORCL/datafile/o1_mf_users_8xm483jk_.dbf

5       Full 1181392    02-AUG-13

/oracle/app/oradata/ORCL/datafile/o1_mf_example_8xm4gzck_.dbf   -------------------数据文件信息，包括路径、文件名、SCN、增量备份的LEVEL、文件号等

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

4       Full    9.36M

DISK        00:00:04     02-AUG-13

BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag:

TAG20130802T015052

Piece Name:

/oracle/app/oracle/product/11.2.0/db_1/dbs/06og8fsf_1_1

SPFILE Included: Modification

time: 02-AUG-13

SPFILE db_unique_name: ORCL

Control File Included: Ckp SCN:

1181392      Ckp time: 02-AUG-13

查看SCHEMA统计信息：

RMAN> report schema;

Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles

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

File Size(MB) Tablespace

RB segs Datafile Name

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

1    690      SYSTEM               ***

/oracle/app/oradata/ORCL/datafile/o1_mf_system_8xm4839m_.dbf

2    490      SYSAUX               ***

/oracle/app/oradata/ORCL/datafile/o1_mf_sysaux_8xm483f7_.dbf

3    85       UNDOTBS1             ***

/oracle/app/oradata/ORCL/datafile/o1_mf_undotbs1_8xm483gd_.dbf

4    8        USERS                ***     /oracle/app/oradata/ORCL/datafile/o1_mf_users_8xm483jk_.dbf

5    100      EXAMPLE              ***

/oracle/app/oradata/ORCL/datafile/o1_mf_example_8xm4gzck_.dbf

---------------------可以看到文件号、文件大小、所属表空间名、文件路径、文件名等。

List of Temporary Files

==