标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (100)
- 数据库 (1,598)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- PostgreSQL解析wal日志之—walminer
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
月归档:三月 2016
强制关机导致数据库无法正常启动恢复
有客户qq找到我,说有朋友推荐,让我帮他们恢复数据库.由于强制关机后,数据库无法正常启动.
数据库recover database失败
Mon Mar 28 10:20:33 2016 ALTER DATABASE RECOVER database Media Recovery Start started logmerger process Parallel Media Recovery started with 32 slaves Mon Mar 28 10:20:36 2016 Recovery of Online Redo Log: Thread 1 Group 2 Seq 18686 Reading mem 0 Mem# 0: E:\ORACLE_DATA\YCCY\REDO02.LOG Recovery of Online Redo Log: Thread 1 Group 3 Seq 18687 Reading mem 0 Mem# 0: E:\ORACLE_DATA\YCCY\REDO03.LOG Recovery of Online Redo Log: Thread 1 Group 1 Seq 18688 Reading mem 0 Mem# 0: E:\ORACLE_DATA\YCCY\REDO01.LOG Mon Mar 28 10:20:38 2016 Hex dump of (file 45, block 7431) in trace file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0q_2968.trc Corrupt block relative dba: 0x0b401d07 (file 45, block 7431) Mon Mar 28 10:20:38 2016 Hex dump of (file 45, block 7836) in trace file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr01_2220.trc Bad header found during media recovery Corrupt block relative dba: 0x0b401e9c (file 45, block 7836) Data in bad block: Bad header found during media recovery type: 0 format: 0 rdba: 0x1d070000 last change scn: 0x4917.f8dc0b40 seq: 0x0 flg: 0x00 spare1: 0x6 spare2: 0xa2 spare3: 0xc7f7 consistency value in tail: 0x06010000 check value in block header: 0x601 block checksum disabled Reading datafile 'E:\ORACLE_DATA\YCCY\DT_SYS_IDX12.DBF' for corruption at rdba: 0x0b401d07 (file 45, block 7431) Reread (file 45, block 7431) found valid data Repaired corruption at (file 45, block 7431) Hex dump of (file 45, block 7556) in trace file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0q_2968.trc Corrupt block relative dba: 0x0b401d84 (file 45, block 7556) Bad header found during media recovery Data in bad block: type: 106 format: 3 rdba: 0x1d840000 last change scn: 0x461d.391a0b40 seq: 0x0 flg: 0x00 spare1: 0x6 spare2: 0xa2 spare3: 0x2499 consistency value in tail: 0x06013999 check value in block header: 0x401 block checksum disabled Reading datafile 'E:\ORACLE_DATA\YCCY\DT_SYS_IDX12.DBF' for corruption at rdba: 0x0b401d84 (file 45, block 7556) Reread (file 45, block 7556) found valid data Repaired corruption at (file 45, block 7556) Mon Mar 28 10:20:38 2016 Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x1334748, kcbzfw()+3094] Mon Mar 28 10:20:39 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0k_3900.trc (incident=131189): ORA-00600: internal error code, arguments: [kcbr_validate_read_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131189\yccy_pr0k_3900_i131189.trc ERROR: Unable to normalize symbol name for the following short stack (at offset 199): Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0r_3060.trc (incident=131245): ORA-07445: exception encountered: core dump [kcbzfw()+3094] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x1334748] [UNABLE_TO_READ] [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 169345, file offset is 1387274240 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: data file 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131245\yccy_pr0r_3060_i131245.trc Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C, kcbzdh()+942] Mon Mar 28 10:20:39 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0d_2112.trc (incident=131133): ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131133\yccy_pr0d_2112_i131133.trc Mon Mar 28 10:20:39 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0e_3260.trc (incident=131141): ORA-00600: internal error code, arguments: [3020], [5], [163457], [21134977], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 163457, file offset is 1339039744 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: data file 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131141\yccy_pr0e_3260_i131141.trc Mon Mar 28 10:20:39 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr04_3980.trc (incident=131021): ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131021\yccy_pr04_3980_i131021.trc Data in bad block: type: 0 format: 0 rdba: 0x1e9c0000 last change scn: 0x4915.f8320b40 seq: 0x0 flg: 0x00 spare1: 0x6 spare2: 0xa2 spare3: 0x8029 consistency value in tail: 0x0602e40c check value in block header: 0x602 block checksum disabled Reading datafile 'E:\ORACLE_DATA\YCCY\DT_SYS_IDX12.DBF' for corruption at rdba: 0x0b401e9c (file 45, block 7836) Reread (file 45, block 7836) found valid data Repaired corruption at (file 45, block 7836) Mon Mar 28 10:20:39 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0f_816.trc (incident=131149): ORA-00600: internal error code, arguments: [kcbr_validate_read_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131149\yccy_pr0f_816_i131149.trc Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C, kcbzdh()+942] Mon Mar 28 10:20:39 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0i_2132.trc (incident=131173): ORA-00600: internal error code, arguments: [3020], [5], [154240], [21125760], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 154240, file offset is 1263534080 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: data file 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131173\yccy_pr0i_2132_i131173.trc Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0k_3900.trc (incident=131190): ORA-07445: exception encountered: core dump [kcbzdh()+942] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [kcbr_validate_read_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131190\yccy_pr0k_3900_i131190.trc Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr01_2220.trc (incident=131037): ORA-00600: internal error code, arguments: [kcbrapply_14], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131037\yccy_pr01_2220_i131037.trc Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C, kcbzdh()+942] Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0f_816.trc (incident=131150): ORA-07445: exception encountered: core dump [kcbzdh()+942] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [kcbr_validate_read_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131150\yccy_pr0f_816_i131150.trc Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr01_2220.trc (incident=131038): ORA-07445: exception encountered: core dump [kcbzdh()+942] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [kcbrapply_14], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131038\yccy_pr01_2220_i131038.trc Mon Mar 28 10:20:39 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0h_4036.trc (incident=131165): ORA-00600: internal error code, arguments: [kcbr_validate_read_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131165\yccy_pr0h_4036_i131165.trc Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C, kcbzdh()+942] Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC13B, kcbzpnd()+299] Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x1351BB9, kcbs_dump_adv_state()+1529] Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC13B, kcbzpnd()+299] Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0h_4036.trc (incident=131166): ORA-07445: exception encountered: core dump [kcbzdh()+942] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC62C] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [kcbr_validate_read_1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131166\yccy_pr0h_4036_i131166.trc Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC13B, kcbzpnd()+299] Mon Mar 28 10:20:40 2016 Checker run found 60 new persistent data failures Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0d_2112.trc (incident=131134): ORA-07445: exception encountered: core dump [kcbzpnd()+299] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC13B] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131134\yccy_pr0d_2112_i131134.trc Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr04_3980.trc (incident=131022): ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+1529] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x1351BB9] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131022\yccy_pr04_3980_i131022.trc Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0e_3260.trc (incident=131142): ORA-07445: exception encountered: core dump [kcbzpnd()+299] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC13B] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [3020], [5], [163457], [21134977], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 163457, file offset is 1339039744 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: data file 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131142\yccy_pr0e_3260_i131142.trc Mon Mar 28 10:20:41 2016 Trace dumping is performing id=[cdmp_20160328102041] Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr0i_2132.trc (incident=131174): ORA-07445: exception encountered: core dump [kcbzpnd()+299] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x12EC13B] [UNABLE_TO_READ] [] ORA-00600: internal error code, arguments: [3020], [5], [154240], [21125760], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 154240, file offset is 1263534080 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: data file 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131174\yccy_pr0i_2132_i131174.trc Mon Mar 28 10:20:41 2016 Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x2E7FFFFFE] [PC:0x74CAE3F0, 0000000074CAE3F0] Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pr06_2684.trc (incident=131077): ORA-07445: exception encountered: core dump [PC:0x74CAE3F0] [ACCESS_VIOLATION] [ADDR:0x2E7FFFFFE] [PC:0x74CAE3F0] [UNABLE_TO_READ] [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131077\yccy_pr06_2684_i131077.trc Mon Mar 28 10:20:42 2016 Exception [type: ACCESS_VIOLATION, UNABLE_TO_WRITE] [ADDR:0x0] [PC:0x4D20D2, kslgetl()+54] Mon Mar 28 10:20:42 2016 Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_pmon_3856.trc (incident=130853): ORA-07445: exception encountered: core dump [kslgetl()+54] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x4D20D2] [UNABLE_TO_WRITE] [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_130853\yccy_pmon_3856_i130853.trc Trace dumping is performing id=[cdmp_20160328102042] Errors in file d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_131077\yccy_pr06_2684_i131077.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00602: internal programming exception ORA-07445: exception encountered: core dump [PC:0x74CAE3F0] [ACCESS_VIOLATION] [ADDR:0x2E7FFFFFE] [PC:0x74CAE3F0] [UNABLE_TO_READ] [] Process debug not enabled via parameter _debug_enable Trace dumping is performing id=[cdmp_20160328102043] Mon Mar 28 10:21:01 2016 RECO (ospid: 3524): terminating the instance due to error 472 Instance terminated by RECO, pid = 3524
通过观察这段日志,基本上可以发现主要是FILE 45,虽然提示坏块但是最终验证确定为正常块(类似:Reread (file 45, block 7836) found valid data),这里主要是file 5,报了大量的ORA-600[3020].
对数据文件逐个进行recover操作
SQL> startup mount; ORACLE 例程已经启动。 Total System Global Area 1.7103E+10 bytes Fixed Size 2192864 bytes Variable Size 9059699232 bytes Database Buffers 8019509248 bytes Redo Buffers 21762048 bytes 数据库装载完毕。 SQL> recover datafile 1; 完成介质恢复。 SQL> recover datafile 2; ORA-03113: 通信通道的文件结尾 进程 ID: 1652 会话 ID: 551 序列号: 55 SQL> recover datafile 3; 完成介质恢复。 SQL> recover datafile 4; 完成介质恢复。 SQL> recover datafile 5; ORA-03113: 通信通道的文件结尾 进程 ID: 4900 会话 ID: 551 序列号: 56131 SQL> recover datafile 6; 完成介质恢复。 ………… SQL> recover datafile 63; 完成介质恢复。 SQL> recover datafile 64; 完成介质恢复。
除掉datafile 2,5之外,其他文件全部recover成功.
对于file 2 尝试处理
无法通过recover成功,只能暂时放弃,后续考虑先offline open库,然后把这个文件强制online
SQL> recover datafile 2 ; ORA-03113: 通信通道的文件结尾 进程 ID: 5020 会话 ID: 551 序列号: 3 Mon Mar 28 10:47:12 2016 ALTER DATABASE RECOVER datafile 2 Media Recovery Start Serial Media Recovery started Recovery of Online Redo Log: Thread 1 Group 1 Seq 18688 Reading mem 0 Mem# 0: E:\ORACLE_DATA\YCCY\REDO01.LOG Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x2E7FFFFFE] [PC:0x74CAE3F0, 0000000074CAE3F0] Errors in file d:\oracle\diag\rdbms\yccy\yccy\trace\yccy_ora_3508.trc (incident=143022): ORA-07445: 出现异常错误: 核心转储 [PC:0x74CAE3F0] [ACCESS_VIOLATION] [ADDR:0x2E7FFFFFE] [PC:0x74CAE3F0] [UNABLE_TO_READ] [] Incident details in: d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_143022\yccy_ora_3508_i143022.trc Errors in file d:\oracle\diag\rdbms\yccy\yccy\incident\incdir_143022\yccy_ora_3508_i143022.trc: ORA-00607: 当更改数据块时出现内部错误 ORA-00602: 内部编程异常错误 ORA-07445: 出现异常错误: 核心转储 [PC:0x74CAE3F0] [ACCESS_VIOLATION] [ADDR:0x2E7FFFFFE] [PC:0x74CAE3F0] [UNABLE_TO_READ] []
对于file 5处理
SQL> recover datafile 5; ORA-00283: 恢复会话因错误而取消 ORA-00600: 内部错误代码, 参数: [3020], [5], [163457], [21134977], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 163457, file offset is 1339039744 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: 数据文件 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' SQL> recover datafile 5 allow 1 corruption; ORA-00283: 恢复会话因错误而取消 ORA-00600: 内部错误代码, 参数: [3020], [5], [162433], [21133953], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 162433, file offset is 1330651136 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: 数据文件 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' SQL> recover datafile 5 allow 1 corruption; ORA-00283: 恢复会话因错误而取消 ORA-00600: 内部错误代码, 参数: [3020], [5], [166272], [21137792], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 166272, file offset is 1362100224 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: 数据文件 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' SQL> recover datafile 5 allow 1 corruption; ORA-00283: 恢复会话因错误而取消 ORA-00600: 内部错误代码, 参数: [3020], [5], [169346], [21140866], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 5, block# 169346, file offset is 1387282432 bytes) ORA-10564: tablespace DT_SYS_DAT ORA-01110: 数据文件 5: 'E:\ORACLE_DATA\YCCY\DT_SYS_DAT.ORA' ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK' SQL> recover datafile 5 allow 1 corruption; 完成介质恢复。
open数据库并online datafile 2
SQL> startup pfile='d:/pfile.txt' mount; ORACLE 例程已经启动。 Total System Global Area 1.7103E+10 bytes Fixed Size 2192864 bytes Variable Size 9059699232 bytes Database Buffers 8019509248 bytes Redo Buffers 21762048 bytes 数据库装载完毕。 SQL> alter database datafile 2 offline; 数据库已更改。 SQL> alter database open; 数据库已更改。 SQL> shutdown immediate; ORA-03113: 通信通道的文件结尾 SQL> conn / as sysdba 已连接到空闲例程。 SQL> startup pfile='d:/pfile.txt' mount; ORACLE 例程已经启动。 Total System Global Area 1.7103E+10 bytes Fixed Size 2192864 bytes Variable Size 9059699232 bytes Database Buffers 8019509248 bytes Redo Buffers 21762048 bytes 数据库装载完毕。 SQL> select group#,status from v$log; GROUP# STATUS ---------- ---------------- 1 INACTIVE 3 INACTIVE 2 CURRENT SQL> recover database until cancel; ORA-00279: 更改 1226478477 (在 03/28/2016 20:23:37 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\ORACLE\FLASH_RECOVERY_AREA\YCCY\ARCHIVELOG\2016_03_28\O1_MF_1_18689_%U_.ARC ORA-00280: 更改 1226478477 (用于线程 1) 在序列 #18689 中 指定日志: {<RET>=suggested | filename | AUTO | CANCEL} E:\ORACLE_DATA\YCCY\REDO02.LOG 已应用的日志。 完成介质恢复。 SQL> alter database datafile 2 online; 数据库已更改。 SQL> alter database open resetlogs; 数据库已更改。
数据库基本上属于正常打开,处理掉3020部分的坏块基本ok
修改11.2 RAC 的 SCAN IP
在某些情况下,由于是C/S架构,从以前的单机系统迁移到现在11.2的rac中,如果修改客户端ip地址工作量太大,而且也不现实,一般建议直接修改scan ip地址和以前一样,从而实现业务直接访问scan ip实现应用不用一个个单独配置.这里通过简单演示,实现修改scan ip的过程(网段不变),主要是把scan名字为scan-xff的ip地址从192.168.137.245修改为192.168.137.248
查看当前scan ip信息
[root-www.xifenfei.com@xff1 ~]# ping xff-scan PING xff-scan (192.168.137.245) 56(84) bytes of data. ^C --- xff-scan ping statistics --- 2 packets transmitted, 0 received, 100% packet loss, time 1738ms [root-www.xifenfei.com@xff1 ~]# crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.LISTENER.lsnr ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.asm ONLINE ONLINE xff1 Started ONLINE ONLINE xff2 Started ora.gsd OFFLINE OFFLINE xff1 OFFLINE OFFLINE xff2 ora.net1.network ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.ons ONLINE ONLINE xff1 ONLINE ONLINE xff2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xff1 ora.cvu 1 ONLINE ONLINE xff1 ora.oc4j 1 ONLINE ONLINE xff1 ora.scan1.vip 1 ONLINE ONLINE xff1 ora.xff1.vip 1 ONLINE ONLINE xff1 ora.xff2.vip 1 ONLINE ONLINE xff2 ora.xffdb.db 1 ONLINE ONLINE xff1 Open 2 ONLINE ONLINE xff2 Open [root-www.xifenfei.com@xff1 ~]# srvctl config scan SCAN name: xff-scan, Network: 1/192.168.137.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /xff-scan/192.168.137.245
修改scan ip
[root-www.xifenfei.com@xff1 ~]# srvctl stop scan_listener [root-www.xifenfei.com@xff1 ~]# srvctl stop scan [root-www.xifenfei.com@xff1 ~]# crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.LISTENER.lsnr ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.asm ONLINE ONLINE xff1 Started ONLINE ONLINE xff2 Started ora.gsd OFFLINE OFFLINE xff1 OFFLINE OFFLINE xff2 ora.net1.network ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.ons ONLINE ONLINE xff1 ONLINE ONLINE xff2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 OFFLINE OFFLINE ora.cvu 1 ONLINE ONLINE xff1 ora.oc4j 1 ONLINE ONLINE xff1 ora.scan1.vip 1 OFFLINE OFFLINE ora.xff1.vip 1 ONLINE ONLINE xff1 ora.xff2.vip 1 ONLINE ONLINE xff2 ora.xffdb.db 1 ONLINE ONLINE xff1 Open 2 ONLINE ONLINE xff2 Open --如果是dns,注意修改dns中scan ip信息,如果是hosts文件注意多个节点都需要修改 [root-www.xifenfei.com@xff1 ~]# ping xff-scan PING xff-scan (192.168.137.248) 56(84) bytes of data. ^C --- xff-scan ping statistics --- 2 packets transmitted, 0 received, 100% packet loss, time 1738ms [root-www.xifenfei.com@xff1 ~]# srvctl modify scan -n xff-scan [root-www.xifenfei.com@xff1 ~]# srvctl config scan SCAN name: xff-scan, Network: 1/192.168.137.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /xff-scan/192.168.137.248 [root-www.xifenfei.com@xff1 ~]# srvctl start scan [root-www.xifenfei.com@xff1 ~]# srvctl start scan_listener [root-www.xifenfei.com@xff1 ~]# crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.LISTENER.lsnr ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.asm ONLINE ONLINE xff1 Started ONLINE ONLINE xff2 Started ora.gsd OFFLINE OFFLINE xff1 OFFLINE OFFLINE xff2 ora.net1.network ONLINE ONLINE xff1 ONLINE ONLINE xff2 ora.ons ONLINE ONLINE xff1 ONLINE ONLINE xff2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xff2 ora.cvu 1 ONLINE ONLINE xff1 ora.oc4j 1 ONLINE ONLINE xff1 ora.scan1.vip 1 ONLINE ONLINE xff2 ora.xff1.vip 1 ONLINE ONLINE xff1 ora.xff2.vip 1 ONLINE ONLINE xff2 ora.xffdb.db 1 ONLINE ONLINE xff1 Open 2 ONLINE ONLINE xff2 Open
查看修改后的scan listener状态
xff2:/home/grid> lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-MAR-2016 17:02:32 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN1 Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 12-MAR-2016 16:59:05 Uptime 0 days 0 hr. 3 min. 27 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/app/grid/network/admin/listener.ora Listener Log File /u01/oracle/app/grid/log/diag/tnslsnr/xff2/listener_scan1/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.248)(PORT=1521))) The listener supports no services The command completed successfully [root-www.xifenfei.com@xff2 ~]# su - oracle xff2:/home/oracle> sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 12 17:01:11 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> alter system register; System altered. SQL> / System altered. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options xff2:/home/oracle> exit logout [root-www.xifenfei.com@xff2 ~]# su - grid xff2:/home/grid> lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-MAR-2016 17:01:24 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN1 Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 12-MAR-2016 16:59:05 Uptime 0 days 0 hr. 2 min. 18 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/app/grid/network/admin/listener.ora Listener Log File /u01/oracle/app/grid/log/diag/tnslsnr/xff2/listener_scan1/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.248)(PORT=1521))) The listener supports no services The command completed successfully
这里发现修改scan ip之后,scan listener没有正确或者到监听的动态注册信息,哪怕人工执行了alter system register;也不行.
通过重启数据库,解决修改scan ip后的动态监听注册问题
[root-www.xifenfei.com@xff2 ~]# su - oracle xff2:/home/oracle> srvctl stop database -d xffdb xff2:/home/oracle> srvctl start database -d xffdb xff2:/home/oracle> exit logout [root-www.xifenfei.com@xff2 ~]# su - grid xff2:/home/grid> lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-MAR-2016 17:06:17 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN1 Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 12-MAR-2016 16:59:05 Uptime 0 days 0 hr. 7 min. 11 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/oracle/app/grid/network/admin/listener.ora Listener Log File /u01/oracle/app/grid/log/diag/tnslsnr/xff2/listener_scan1/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.248)(PORT=1521))) Services Summary... Service "xffdb" has 2 instance(s). Instance "xffdb1", status READY, has 1 handler(s) for this service... Instance "xffdb2", status READY, has 1 handler(s) for this service... Service "xffdbXDB" has 2 instance(s). Instance "xffdb1", status READY, has 1 handler(s) for this service... Instance "xffdb2", status READY, has 1 handler(s) for this service... The command completed successfully
ORA-01172 ORA-01151 故障恢复
有客户存储异常断电,导致数据库启动报ORA-01172错,导致数据库无法open
数据库启动报ORA-01172错误
Wed Mar 23 14:16:23 2016 ALTER DATABASE OPEN Wed Mar 23 14:16:24 2016 Beginning crash recovery of 1 threads parallel recovery started with 15 processes Wed Mar 23 14:16:24 2016 Started redo scan Wed Mar 23 14:16:25 2016 Completed redo scan 62588 redo blocks read, 15 data blocks need recovery Wed Mar 23 14:16:25 2016 Started redo application at Thread 1: logseq 15050, block 2, scn 2439828667 Wed Mar 23 14:16:25 2016 Recovery of Online Redo Log: Thread 1 Group 1 Seq 15050 Reading mem 0 Mem# 0 errs 0: /oracle/oradata/orcl/redo01.log Wed Mar 23 14:16:25 2016 Completed redo application Wed Mar 23 14:16:25 2016 RECOVERY OF THREAD 1 STUCK AT BLOCK 26185 OF FILE 3 Wed Mar 23 14:16:25 2016 RECOVERY OF THREAD 1 STUCK AT BLOCK 69385 OF FILE 3 Wed Mar 23 14:16:25 2016 RECOVERY OF THREAD 1 STUCK AT BLOCK 566 OF FILE 2 Wed Mar 23 14:16:25 2016 RECOVERY OF THREAD 1 STUCK AT BLOCK 89 OF FILE 2 Wed Mar 23 14:16:25 2016 RECOVERY OF THREAD 1 STUCK AT BLOCK 53769 OF FILE 3 Wed Mar 23 14:16:26 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p012_6540.trc: ORA-01172: recovery of thread 1 stuck at block 566 of file 2 ORA-01151: use media recovery to recover block, restore backup if needed Wed Mar 23 14:16:26 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p008_6532.trc: ORA-01172: recovery of thread 1 stuck at block 53769 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed Wed Mar 23 14:16:26 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p011_6538.trc: ORA-01172: recovery of thread 1 stuck at block 69385 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed Wed Mar 23 14:16:26 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p005_6526.trc: ORA-01172: recovery of thread 1 stuck at block 26185 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed Wed Mar 23 14:16:27 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p014_6544.trc: ORA-01172: recovery of thread 1 stuck at block 89 of file 2 ORA-01151: use media recovery to recover block, restore backup if needed Wed Mar 23 14:16:27 2016 Aborting crash recovery due to slave death, attempting serial crash recovery Wed Mar 23 14:16:27 2016 Beginning crash recovery of 1 threads Wed Mar 23 14:16:27 2016 Started redo scan Wed Mar 23 14:16:27 2016 Completed redo scan 62588 redo blocks read, 15 data blocks need recovery Wed Mar 23 14:16:27 2016 Started redo application at Thread 1: logseq 15050, block 2, scn 2439828667 Wed Mar 23 14:16:27 2016 Recovery of Online Redo Log: Thread 1 Group 1 Seq 15050 Reading mem 0 Mem# 0 errs 0: /oracle/oradata/orcl/redo01.log RECOVERY OF THREAD 1 STUCK AT BLOCK 566 OF FILE 2 Wed Mar 23 14:16:27 2016 Aborting crash recovery due to error 1172 Wed Mar 23 14:16:27 2016 Errors in file /oracle/admin/orcl/udump/orcl_ora_6514.trc: ORA-01172: recovery of thread 1 stuck at block 566 of file 2 ORA-01151: use media recovery to recover block, restore backup if needed ORA-1172 signalled during: ALTER DATABASE OPEN...
ALTER DATABASE RECOVER datafile 1 报错
尝试recover datafile 1之后报ORA-600 kcbrapply_4,ORA-600 kcfrbd_3,ORA-600 kcbrapply_12等错误,从报错信息看,出现这些错误的原因,是由于断电导致坏块引起.
Thu Mar 24 21:50:18 2016 ALTER DATABASE RECOVER datafile 1 Thu Mar 24 21:50:18 2016 Media Recovery Start parallel recovery started with 15 processes Thu Mar 24 21:50:18 2016 Recovery of Online Redo Log: Thread 1 Group 1 Seq 15050 Reading mem 0 Mem# 0 errs 0: /oracle/oradata/orcl/redo01.log Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p004_13391.trc: ORA-00600: internal error code, arguments: [kcbrapply_4], [2], [], [], [], [], [], [] Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p010_13403.trc: ORA-00600: internal error code, arguments: [kcbrapply_4], [0], [], [], [], [], [], [] Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p000_13383.trc: ORA-00600: internal error code, arguments: [kcbrapply_4], [0], [], [], [], [], [], [] Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p009_13401.trc: ORA-00600: internal error code, arguments: [kcbrapply_4], [3], [], [], [], [], [], [] Thu Mar 24 21:50:19 2016 Hex dump of (file 1, block 61562) in trace file /oracle/admin/orcl/bdump/orcl_p001_13385.trc Corrupt block relative dba: 0x0040f07a (file 1, block 61562) Bad header found during media recovery Data in bad block: type: 0 format: 0 rdba: 0xf07a0000 last change scn: 0x916c.dc4b0040 seq: 0x0 flg: 0x00 spare1: 0x6 spare2: 0xa2 spare3: 0xb088 consistency value in tail: 0x06010fc1 check value in block header: 0x601 block checksum disabled Thu Mar 24 21:50:19 2016 Hex dump of (file 1, block 55706) in trace file /oracle/admin/orcl/bdump/orcl_p014_13411.trc Corrupt block relative dba: 0x0040d99a (file 1, block 55706) Bad header found during media recovery Data in bad block: type: 0 format: 0 rdba: 0xd99a0000 last change scn: 0x916c.e1ad0040 seq: 0x0 flg: 0x00 spare1: 0x6 spare2: 0xa2 spare3: 0xa520 consistency value in tail: 0x06012222 check value in block header: 0x601 block checksum disabled Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p006_13395.trc: ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [3342335], [1], [0], [64000], [], [] Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p003_13389.trc: ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [3932159], [1], [0], [64000], [], [] Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p002_13387.trc: ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [2293759], [1], [0], [64000], [], [] Reread of rdba: 0x0040d99a (file 1, block 55706) found valid data Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p014_13411.trc: ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [] Thu Mar 24 21:50:19 2016 Reread of rdba: 0x0040f07a (file 1, block 61562) found valid data Thu Mar 24 21:50:19 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p001_13385.trc: ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p014_13411.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xB9782BF4] [] [] ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p006_13395.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xB9C82BF4] [] [] ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [3342335], [1], [0], [64000], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p009_13401.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xB9A02BF4] [] [] ORA-00600: internal error code, arguments: [kcbrapply_4], [3], [], [], [], [], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p003_13389.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xB9F02AF4] [] [] ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [3932159], [1], [0], [64000], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p004_13391.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xBA182AF4] [] [] ORA-00600: internal error code, arguments: [kcbrapply_4], [2], [], [], [], [], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p010_13403.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xBA402AF4] [] [] ORA-00600: internal error code, arguments: [kcbrapply_4], [0], [], [], [], [], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p000_13383.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xB9282AF4] [] [] ORA-00600: internal error code, arguments: [kcbrapply_4], [0], [], [], [], [], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p001_13385.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+450] [SIGSEGV] [Address not mapped to object] [0xB9C82AF4] [] [] ORA-00600: internal error code, arguments: [kcbrapply_12], [], [], [], [], [], [], [] Thu Mar 24 21:50:23 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p002_13387.trc: ORA-10562: Error occurred while applying redo to data block (file# 1, block# 11042) ORA-10564: tablespace SYSTEM ORA-01110: data file 1: '/oracle/oradata/orcl/system01.dbf' ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [2293759], [1], [0], [64000], [], []
ALTER DATABASE RECOVER datafile 3 报错
该文件恢复主要报ORA-600 kcbrsearchflist_2,ORA-600 kdxlin:psno out of range,ORA-600 kcbs_dump_adv_state等错误
Thu Mar 24 21:52:04 2016 ALTER DATABASE RECOVER datafile 3 Thu Mar 24 21:52:04 2016 Media Recovery Start parallel recovery started with 15 processes Thu Mar 24 21:52:04 2016 Recovery of Online Redo Log: Thread 1 Group 1 Seq 15050 Reading mem 0 Mem# 0 errs 0: /oracle/oradata/orcl/redo01.log Thu Mar 24 21:52:05 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p007_13462.trc: ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [] Thu Mar 24 21:52:05 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p001_13450.trc: ORA-00600: internal error code, arguments: [kcbrsearchflist_2], [], [], [], [], [], [], [] Thu Mar 24 21:52:05 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p007_13462.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+464] [SIGSEGV] [Address not mapped to object] [0xB9F076F4] [] [] ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [] Thu Mar 24 21:52:05 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p001_13450.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+464] [SIGSEGV] [Address not mapped to object] [0xB9C874F4] [] [] ORA-00600: internal error code, arguments: [kcbrsearchflist_2], [], [], [], [], [], [], [] Thu Mar 24 21:52:06 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p007_13462.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+464] [SIGSEGV] [Address not mapped to object] [0xB9F066F4] [] [] ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+464] [SIGSEGV] [Address not mapped to object] [0xB9F076F4] [] [] ORA-00600: internal error code, arguments: [kdxlin:psno out of range], [], [], [], [], [], [], [] Thu Mar 24 21:52:06 2016 Errors in file /oracle/admin/orcl/bdump/orcl_p001_13450.trc: ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+464] [SIGSEGV] [Address not mapped to object] [0xB9C864F4] [] [] ORA-07445: exception encountered: core dump [kcbs_dump_adv_state()+464] [SIGSEGV] [Address not mapped to object] [0xB9C874F4] [] [] ORA-00600: internal error code, arguments: [kcbrsearchflist_2], [], [], [], [], [], [], []
恢复过程
SQL> startup mount ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 1220432 bytes Variable Size 369098928 bytes Database Buffers 1761607680 bytes Redo Buffers 15556608 bytes Database mounted. SQL> select file# from v$datafile; FILE# ---------- 1 2 3 4 5 6 6 rows selected. SQL> recover datafile 1; ORA-03113: end-of-file on communication channel SQL> startup mount ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 1220432 bytes Variable Size 369098928 bytes Database Buffers 1761607680 bytes Redo Buffers 15556608 bytes Database mounted. SQL> recover datafile 3; ORA-03113: end-of-file on communication channel SQL> startup mount ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 1220432 bytes Variable Size 369098928 bytes Database Buffers 1761607680 bytes Redo Buffers 15556608 bytes Database mounted. SQL> recover datafile 5; Media recovery complete. SQL> recover datafile 6; Media recovery complete. SQL> recover datafile 4; Media recovery complete. SQL> recover datafile 2; Media recovery complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4194], [57], [11], [], [], [], [], [] SQL> select open_mode from v$database; OPEN_MODE ---------- READ WRITE
这次运气不错,system坏的是mon_mods$,undo异常可以重建,基本上可以说没有数据丢失,数据库恢复完成.
重要的库,通过open过程报错信息,分析可能的坏块所属对象,然后确定处理方法,以免造成永久性数据块损坏.