BBED ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [...

BBED模拟并修复

删除：$ORACLE_HOME/rdbms/admin/prvtsupp.plb

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], []
Process ID: 29344
Session ID: 3319 Serial number: 3

利用：第三方工具GDUL，导出mount下库的数据，导入到新的库。以解决这个灾难

http://www.eygle.com/archives/2018/07/recover_ora-600_16703.html

https://www.cnblogs.com/lhrbest/p/7576416.html#3795408

部分处理过程：

oradebug:生成10046事件，观察报错信息：
alter session set tracefile_identifier='elon';
alter session set events '10046 trace name context forever,level 12';
alter session set events '10046 trace name context off';

 

查文件块号：
select
dbms_rowid.ROWID_RELATIVE_FNO(rowid) fno,
dbms_rowid.ROWID_BLOCK_NUMBER(rowid) bno,
dbms_rowid.ROWID_ROW_NUMBER(rowid) rowno from sys.tab$ ;

select max(dbms_rowid.ROWID_BLOCK_NUMBER(rowid)) bno from sys.tab$ ;
select min(dbms_rowid.ROWID_BLOCK_NUMBER(rowid)) bno from sys.tab$ ;

select distinct file_no, blk_no
from
(
select dbms_rowid.rowid_relative_fno(rowid) file_no, dbms_rowid.rowid_block_number(rowid) blk_no from sys.tab$
) order by file_no, blk_no;

生成copy 语句：
select 'copy file 100 block ' || blk_no || ' to file 1 block ' || blk_no || ';'
from
(
select distinct dbms_rowid.rowid_relative_fno(rowid) file_no, dbms_rowid.rowid_block_number(rowid) blk_no
from sys.tab$
order by file_no, blk_no
);

select distinct file_no, blk_no
from
(
select dbms_rowid.rowid_relative_fno(rowid) file_no, dbms_rowid.rowid_block_number(rowid) blk_no from sys.tab$
)
where blk_no = 31497;

file: 1， 块号是169,170,145

vi filelist.txt
1 /home/oracle/oradata/dstdw/system01.dbf
2 /home/oracle/oradata/dstdw/sysaux01.dbf
3 /home/oracle/oradata/dstdw/undotbs01.dbf
4 /home/oracle/oradata/dstdw/users01.dbf
5 /home/oracle/oradata/dstdw/credit.dbf
100 /tmp/system01.dbf.new

vi par.bbd
blocksize=8192
listfile=filelist.txt
mode=edit

从备份文件中copy良好的数据块进行恢复
[oracle@ ~]$ bbed parfile=par.bbd
password:blockedit

BBED>copy file 100 block 169 to file 1 block 169;
BBED>copy file 100 block 170 to file 1 block 170;
BBED>copy file 100 block 145 to file 1 block 145;

BBED> verify

 

转载于:https://www.cnblogs.com/elontian/p/9686849.html