我们维护的一个客户生产数据库,由于工程人员把数据库用户的temporary tablespace设置为system,现在system满了,是不是会导致system有坏块呀?
系统环境:
tru64unix 4.0+oracle8.1.6.2
应用结构:c/s
dbv.log:
Corrupt block relative dba: 0x0041bb6e file=0. blocknum=113518.
Bad check value found during dbv:
Data in bad block - type:8. format:2. rdba:0x0041bb6e
last change scn:0x0666.c921b79a seq:0x1 flg:0x0c
consistancy value in tail 0xb79a0801
check value in block header: 0x7a3f, calculated check value: 0x648c
spare1:0x0, spare2:0x0, spare2:0x0
DBVERIFY - Verification complete
Total Pages Examined : 115488
Total Pages Processed (Data) : 34192
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 7395
Total Pages Failing (Index): 0
Total Pages Processed (Other): 71992
Total Pages Empty : 1904
Total Pages Marked Corrupt : 5
Total Pages Influx : 0
根据提示的块号,查看是sys.view$,sys.i_source$等系统对象
各位有没有遇到这个问题?
除了重新建库有没有别的办法?