Oracle RMAN Recover中使用BBED跳过缺失的归档继续Recover的测试(五)
3836079 ONLINE
7 rows selected.
这里的datafile 的SCN 都跳过了我们缺失的归档，我们可以继续进行recover了。
2.7 重新进行Recover
RMAN> recover database;
Starting recover at 07-JUL-13
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at07/07/2013 01:04:43
ORA-00283: recovery session canceled due toerrors
RMAN-11003: failure during parse/executionof SQL statement: alter database recover if needed
start
ORA-00283: recovery session canceled due toerrors
ORA-00600: internal errorcode, arguments: [3020], [3], [8077], [12590989], [], [], [], [], [], [], [],[]
ORA-10567:Redo is inconsistent with data block (file# 3, block# 8077, file offset is 66166784 bytes)
ORA-10564: tablespaceUNDOTBS1
ORA-01110: data file 3:'/u01/app/oracle/oradata/dave/undotbs1.258.816661037'
ORA-10560: block type 'KTU UNDO BLOCK'
根据官网的说明，我们这是UNDO 表空间恢复无法继续了，详见：
Resolving ORA-600[3020] Raised During Recovery (文档 ID 361172.1)
尝试跳过坏块测试：
RMAN> recover database allow 50 corruption;
Starting recover at 07-JUL-13
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time:00:00:01
Finished recover at 07-JUL-13
RMAN>
恢复是没有问题，但是打开是有问题的：
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated.Disconnection forced
ORA-01578: ORACLE data block corrupted(file # 3, block # 128)
ORA-01110: data file 3:'/u01/app/oracle/oradata/dave/undotbs1.258.816661037'
Process ID: 32549
Session ID: 16 Serial number: 5
2.8 重建UNDO 表空间
这里里面的 3 就是我们的undo 表空间，我们把重新创建一个UNDO 在拉起数据库：
2.8.1 用spfile 创建pfile，然后修改参数
#*.undo_tablespace='UNDOTBS1'
*.undo_management='MANUAL'
*.rollback_segments='SYSTEM'
2.8.2 用修改之后的pfile，重启DB
SQL> startuppfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initdave.ora'
ORACLE instance started.
Total System Global Area 718188544 bytes
Fixed Size 2231832 bytes
Variable Size 436208104 bytes
Database Buffers 276824064 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL>
2.8.3 删除原来的表空间，创建新的UNDO 表空间
SQL> select tablespace_name fromdba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
UNDOTBS2
DAVE
7 rows selected.
SQL> droptablespace undotbs1;
SQL> create undo tablespace undotbs1datafile '/u01/app/oracle/oradata/dave/undotbs1.dbf' size 50M;
Tablespace created.
2.8.4 关闭数据库，修改pfile参数，然后用新的pfile创建spfile，在正常启动数据库。
*.undo_tablespace='UNDOTBS1'
#*.undo_management='MANUAL'
#*.rollback_segments='SYSTEM'
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 718188544 bytes
Fixed Size 2231832 bytes
Variable