重庆思庄Oracle、Redhat认证学习论坛

标题: 查看目标库过去时间的表空间信息 [打印本页]

作者: 郑全 时间: 2015-11-14 16:06
标题: 查看目标库过去时间的表空间信息
在配置了rman恢复目录后,我们可以查看目标库过去某个时间的表空间及数据文件信息：

•Allowsyou to list the data files and tablespaces that are or were in thetarget database at a given time

具体实现：

$ rman target sys/oracle@sztech1 catalog rman/rman@192.168.133.1:1521/orcl

查看当前数据库信息
RMAN> report schema;
Report of database schema for database with db_unique_name SZTECH1
List of Permanent Datafiles
===========================
File Size(MB) Tablespace          RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 740    SYSTEM             YES    /u01/app/oracle/oradata/sztech1/system01.dbf
2 560    SYSAUX             NO    /u01/app/oracle/oradata/sztech1/sysaux01.dbf
3 105    UNDOTBS1          YES    /u01/app/oracle/oradata/sztech1/undotbs01.dbf
4 6       USERS             NO    /u01/app/oracle/oradata/sztech1/users01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace          Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 29    TEMP                32767    /u01/app/oracle/oradata/sztech1/temp01.dbf

查看两天以前的表空间信息：

RMAN> report schema at time "sysdate-interval '2' day";
Report of database schema for database with db_unique_name SZTECH1
List of Permanent Datafiles
===========================
File Size(MB) Tablespace          RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 740    SYSTEM             YES    /u01/app/oracle/oradata/sztech1/system01.dbf
2 560    SYSAUX             YES    /u01/app/oracle/oradata/sztech1/sysaux01.dbf
3 105    UNDOTBS1          YES    /u01/app/oracle/oradata/sztech1/undotbs01.dbf
4 6       USERS             YES    /u01/app/oracle/oradata/sztech1/users01.dbf
5 346    EXAMPLE             YES    /u01/app/oracle/oradata/sztech1/example01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace          Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 29    TEMP                32767    /u01/app/oracle/oradata/sztech1/temp01.dbf

红色部分，就以前有的表空间

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)