Oracle11新特性——备份恢复功能增强（九）

打算写一系列的文章介绍11g的新特性和变化。

Oracle11g在备份和恢复方面新增了很多的功能，无论是性能、功能性、安全性和可操作性方面都有了不同程度的提高。

这一篇介绍11g的新特性Data Recovery Advisor。

Oracle11新特性——备份恢复功能增强（一）：http://yangtingkun.itpub.net/post/468/412991

Oracle11新特性——备份恢复功能增强（二）：http://yangtingkun.itpub.net/post/468/414647

Oracle11新特性——备份恢复功能增强（三）：http://yangtingkun.itpub.net/post/468/414834

Oracle11新特性——备份恢复功能增强（四）：http://yangtingkun.itpub.net/post/468/414941

Oracle11新特性——备份恢复功能增强（五）：http://yangtingkun.itpub.net/post/468/416015

Oracle11新特性——备份恢复功能增强（六）：http://yangtingkun.itpub.net/post/468/423531

Oracle11新特性——备份恢复功能增强（七）：http://yangtingkun.itpub.net/post/468/426943

Oracle11新特性——备份恢复功能增强（八）：http://yangtingkun.itpub.net/post/468/427877

11g新增特性Data Recovery Advisor，这个内嵌工具可以自动检测物理数据错误，可以给出建议修改方式，执行修复操作。

看一个简单的例子，首先对测试表空间进行备份：

[oracle@yangtk ~]$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Fri Nov 9 00:35:19 2007

connected to target database: ORA11G (DBID=4026820313)

RMAN> list failure;

using target database control file instead of recovery catalog
no failures found that match specification

RMAN> backup tablespace users;

Starting backup at 09-NOV-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=118 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set

www.ixdba.net

input datafile file number=00004 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf
channel ORA_DISK_1: starting piece 1 at 09-NOV-07
channel ORA_DISK_1: finished piece 1 at 09-NOV-07
piece handle=/data1/backup/1ij0irqj_1_1 tag=TAG20071109T003531 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 09-NOV-07

Starting Control File and SPFILE Autobackup at 09-NOV-07
piece handle=/data1/backup/c-4026820313-20071109-00 comment=NONE
Finished Control File and SPFILE Autobackup at 09-NOV-07

RMAN> exit

Recovery Manager complete.

下面建立测试用表：

[oracle@yangtk ~]$ sqlplus yangtk/yangtk

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Nov 9 00:36:27 2007

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table t_failure tablespace users as select * from dba_objects;

Table created.

SQL> select dbms_rowid.rowid_relative_fno(rowid), dbms_rowid.rowid_block_number(rowid)
2 from t_failure where rownum = 1;

DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID) DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------ ------------------------------------
4 12

SQL> select count(*) from t_failure;

COUNT(*)
----------
68918

下面通过文本编辑工具如