Database、Code

BBED是ORACLE的内部工具，通常使用BBED都是恢复一些故障的数据库，比如断电或异常关闭操作系统导致的数据文件头不一致、SYSTEM表空间损坏等故障就可以使用BBED工具进行恢复。在11G中编译通常会报如下错误：[oracle@ogg1 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbedLinking BBED

[oracle@ogg1 lib]$ cat filelist.txt 4 /opt/oracle/oradata/orcl11g/users01.dbf3 /opt/oracle/oradata/orcl11g/undotbs01.dbf2 /opt/oracle/oradata/orcl11g/sysaux01.dbf1 /opt/oracle/oradata/orcl11g/

SYS@orcl11g>alter database datafile 6 online;alter database datafile 6 online*ERROR at line 1:ORA-01113: file 6 needs media recoveryORA-01110: data file 6: '/opt/oracle/oradata/orcl11g/zbdba01.db

ZBDBA@orcl11g>select * from zbdba;select * from zbdba *ERROR at line 1:ORA-01578: ORACLE data block corrupted (file # 3, block # 1449)ORA-01110: data file 3: '/opt/oracle/oradata/orc

bbed是一个强大的工具，允许我们绕过oracle直接从数据文件中修改对应的内容ZBDBA@orcl11g>select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO---------- ------

在我们恢复的时候，发现中间缺失归档，大部分dba认为从缺失的归档开始以后的归档都无法进行恢复。但是我们从非常规的方式，修改数据文件对应的信息是可以跳过该缺失的归档，并且利用后面的归档进行恢复的。SYS@orcl11g>recover datafile 6;ORA-00279: change 2054392 generated at 10/28/2014 23:20:14 needed for

创建测试表：ZBDBA@orcl11g>select * from zbdba;NAME------------------------------------------------------------zbdbahuihuiZBDBA@orcl11g>ZBDBA@orcl11g>ZBDBA@orcl11g>ZBDBA@orcl11g>ZBDBA@orcl11g>sel