ORA-00600: internal error code, arguments: [3020], [3], [307241], [12890153], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 3, block# 307241, file offset is 2516918272 bytes) ORA-10564: tablespace SYSAUX ORA-01110: data file 3: ...
本文阐述了Oracle ADG备库SYSAUX数据文件坏块恢复处理(ORA-00600,ORA-10567,ORA-10564,ORA-01110,ORA-10561)的思路、步骤、解决方案。
数据库异常断电之后,recover 报ORA-00756 ORA-10567等错 SQL> recoverdatabase; ORA-00756: 恢复操作检测到数据块写入丢失 ORA-10567: Redoisinconsistentwithdata block (file# 1,block# 113855,file offsetis932700160 bytes) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1:'H:\BAIDUNETDISK\XIFENFEI\SYST...
ORA-00600: internal error code, arguments: [3020], [3], [10232], [12593144], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 3, block# 10232, file offset is 83820544 bytes) ORA-10564: tablespace UNDOTBS1 ORA-01110: data file 3: ...
ORA-10564: tablespace ESCMOWNER_DATA 1. ORA-01110: data file 52: '/u02/oradata/SCM2/escmowner_d07.dbf' 1. ORA-10560: block type 'LOB BLOCK' 1. 1. 1. SQL> 1. 结果恢复时又遇到了ORA-00600: internal error code, arguments: [3020] 与 ORA-10567: Redo is inconsistent with data bl...
ORA-00600: internal error code, arguments: [3020], [113246216], [1], [7617], [164], [72], [], [] ORA-10567: Redo is inconsistent with data block (file# 27, block# 8) ORA-10564: tablespace STK_TS ORA-01110: data file 27: '/global/oradata/ctsdb/stk_ts03.dbf' ...
ORA-10567故障处理 一:场景描述 数据库版本:11.2.0.1 64bit active dataguard 操作系统版本:centos 5.8 64bit 早上数据库例行检查,发现undo表空间数据文件太大,查询了最大的block后,发现实际只使用到几百兆。于是想当然alter database datafile 'xxxx' resize 3G;万事ok!在这之前,遇到这种情况,也都是这样处理,...
ORA-00600: internal error code, arguments: [3020], [6], [2343], [25168167], [], [], ORA-10567: Redo is inconsistent with data block (file# 6, block# 2343, file offset is 38387712 bytes) ORA-10564: tablespace UNDOTBS1 ORA-01110: data file 6: '/data/orcl/undotbs03.dbf' ...
ORA-10564: tablespace ESCMOWNER_DATA ORA-01110:datafile52:'/u02/oradata/SCM2/escmowner_d07.dbf' ORA-10560: block type'LOB BLOCK' SQL> 结果恢复时又遇到了ORA-00600: internal error code, arguments: [3020] 与 ORA-10567: Redo is inconsistent with data block 错误。
ORA-10567: Redo is inconsistent with data block (file# 5, block# 131, file offset is 1073152 bytes) ORA-10564: tablespace T1 ORA-01110: data file 5: '/oradata/rzxerp/t1.dbf' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 94252 ...