环境:
Centos-6.5
oracle 11.2.0.4
没有开归档。
具体描述:
1.在用户SDCG下创建表,报ORA-08103: object no longer exists错误,是创建任何表都会报错,但查询该用户的一些表,却没有报错。
2.通过dbv检测该文件,发现并没有坏块。
[oracle@localhost trace]$ dbv file=/home/oracle/app/oracle/oradata/orcl/SDCG.dbf
DBVERIFY: Release 11.2.0.4.0 - Production on Thu Aug 23 15:27:07 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
DBVERIFY - Verification starting : FILE = /home/oracle/app/oracle/oradata/orcl/SDCG.dbf
DBVERIFY - Verification complete
Total Pages Examined : 1395200
Total Pages Processed (Data) : 690061
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 38267
Total Pages Failing (Index): 0
Total Pages Processed (Other): 638746
Total Pages Processed (Seg): 0
Total Pages Failing (Seg): 0
Total Pages Empty
: 28126
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted: 0
Highest block SCN
: 507596108 (0.507596108)
复制代码3.做errorstack dump 8103,没有发现什么关键信息,发现有一个可疑的地方。文件已上传。
orcl_ora_9035.zip(1.01 MB, 下载次数: 3)2018-8-23 15:40 上传点击文件名下载附件
The buffer with tsn: 10 rdba: 0x025294ba was pinned,
复制代码4.通过定位这个rdba,发现也是SDCG这个文件的,但是查询相关的segment,是为空的。
select to_number('025294BA','xxxxxxxxxxx') from dual;--38966458
select dbms_utility.data_block_address_file(38966458) file_no,dbms_utility.data_block_address_block(38966458) block_no from dual;--9 1217722
SELECT OWNER,
SEGMENT_NAME,
SEGMENT_TYPE,
TABLESPACE_NAME
FROM DBA_EXTENTS
WHERE FILE_ID =9
AND 1217722 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;复制代码
|