标签云
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)
- 操作系统 (101)
- 数据库 (1,630)
- DB2 (22)
- MySQL (71)
- Oracle (1,494)
- Data Guard (50)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle 23ai (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (48)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (545)
- Oracle安装升级 (89)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- Oracle 23ai依旧支持bbed
- oracle 23ai(23.5.0.24.07)完整功能版安装体验
- win平台安装oracle遭遇INS-30131处理
- 配置win环境ssh和sftp并实现免密登录
- 11.2.0.4最新psu-202407
- Oracle 19c 2024.07补丁(RUs+OJVM)
- ORA-00756 ORA-10567故障处理
- ORA-01092 ORA-00604 ORA-08103故障处理
- 数据库启动报ORA-600 6711故障分析处理
- RMAN SBT_TAPE备份无法被DISK通道识别
- ORA-27154 ORA-27300 ORA-27301 ORA-27302故障处理
- Patch SCN工具for Linux
- awr创建snapshot等待library cache: mutex X
- exadata换flash卡的一些操作
- RMAN-06207 RMAN-06208报错解决
- RAC主机相差超过10分钟导致crs无法启动
- O/S-Error: (OS 23) 数据错误(循环冗余检查)—故障处理
- 异常断电数据库恢复-从ORA-600 2131到ORA-08102: 未找到索引关键字, 对象号 39
- 数据泵迁移Wrapped PLSQL之后报PLS-00753
- 数据库open报ORA-600 kcratr_scan_lastbwr故障处理
标签归档:oracle 8恢复
oracle 8.1.6因断电无法启动恢复
接到一个oralce 8.1.6的数据库恢复请求,由于断电之后,系统无法正常恢复,通过尝试recover datafile报错如下
SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PL/SQL Release 8.1.6.0.0 - Production CORE 8.1.6.0.0 Production TNS for 32-bit Windows: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production
Tue Oct 16 14:17:01 2018 Media Recovery Datafile: 1 Media Recovery Start Media Recovery Log Recovery of Online Redo Log: Thread 1 Group 1 Seq 146597 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG Tue Oct 16 14:17:02 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA03040.TRC: ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [30547], [6101], [], [], [], [] Tue Oct 16 14:17:03 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA03040.TRC: ORA-01578: ORACLE data block corrupted (file # 1, block # 30547) ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF' ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [kcoapl_blkchk], [1], [30547], [6101], [], [], [], [] Tue Oct 16 14:17:03 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA03040.TRC: ORA-00314: log 2 of thread 1, expected sequence# 146598 doesn't match 146415 ORA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG'
这里可以获取到两个信息:1)system文件可能有坏块,导致数据库recover的时候报ORA-600 kcoapl_blkchk错误,2)数据库的redo可能异常了,由于8i数据库默认redo 10m,在业务繁忙时候切换较为频繁,而文件系统的cache导致redo信息比较老,而数据文件需要redo比较新,从而无法正常恢复成功。比较明显对于当前这样的情况只能是屏蔽数据一致性,强制拉库
ARC0: media recovery disabled Tue Oct 16 14:17:39 2018 SMON: enabling cache recovery Tue Oct 16 14:17:39 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA02256.TRC: ORA-00600: internal error code, arguments: [2662], [1], [1712082681], [1], [1712107587], [8388610], [], [] Tue Oct 16 14:17:41 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA02256.TRC: ORA-00600: internal error code, arguments: [2662], [1], [1712082682], [1], [1712107587], [8388610], [], [] ORA-00600: internal error code, arguments: [2662], [1], [1712082681], [1], [1712107587], [8388610], [], [] Tue Oct 16 14:17:43 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA02256.TRC: ORA-00600: internal error code, arguments: [2662], [1], [1712082682], [1], [1712107587], [8388610], [], [] ORA-00600: internal error code, arguments: [2662], [1], [1712082681], [1], [1712107587], [8388610], [], [] Tue Oct 16 14:17:45 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA02256.TRC: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [2662], [1], [1712082682], [1], [1712107587], [8388610], [], [] ORA-00600: internal error code, arguments: [2662], [1], [1712082681], [1], [1712107587], [8388610], [], []
ORA-600 2662这个错误比较常见,直接推数据库scn,启动库
Tue Oct 16 16:09:11 2018 Errors in file D:\Oracle\admin\orcl\bdump\orclSMON.TRC: ORA-00600: internal error code, arguments: [4193], [29469], [29477], [], [], [], [], [] Recovery of Online Redo Log: Thread 1 Group 3 Seq 1 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG Tue Oct 16 16:09:12 2018 Errors in file D:\Oracle\admin\orcl\bdump\orclSMON.TRC: ORA-01595: error freeing extent (3) of rollback segment (2)) ORA-00600: internal error code, arguments: [4193], [29469], [29477], [], [], [], [], [] Tue Oct 16 16:09:13 2018 Completed: ALTER DATABASE OPEN Tue Oct 16 16:12:06 2018 CREATE ROLLBACK SEGMENT nrbs1 TABLESPACE rbs Tue Oct 16 16:12:06 2018 Errors in file D:\Oracle\admin\orcl\udump\ORA02252.TRC: ORA-00600: internal error code, arguments: [4194], [79], [38], [], [], [], [], []
错误比较明显ORA-600 4194,而且已经告知是由于rollback segment 2异常,通过屏蔽回滚段,open数据库,删除老回滚段,创建新回滚段(8i无undo自动管理)
SQL> startup ORACLE instance started. Total System Global Area 1549432076 bytes Fixed Size 70924 bytes Variable Size 500707328 bytes Database Buffers 1048576000 bytes Redo Buffers 77824 bytes Database mounted. Database opened. SQL> drop rollback segment "RBS1"; Rollback segment dropped. SQL> drop rollback segment "RBS2"; Rollback segment dropped. SQL> drop rollback segment "RBS3"; Rollback segment dropped. SQL> drop rollback segment "RBS4"; Rollback segment dropped. SQL> drop rollback segment "RBS5"; Rollback segment dropped. SQL> drop rollback segment "RBS6"; Rollback segment dropped. SQL> CREATE ROLLBACK SEGMENT nrbs1 TABLESPACE rbs; Rollback segment created. SQL> CREATE ROLLBACK SEGMENT nrbs2 TABLESPACE rbs; Rollback segment created. SQL> CREATE ROLLBACK SEGMENT nrbs3 TABLESPACE rbs; Rollback segment created. SQL> CREATE ROLLBACK SEGMENT nrbs4 TABLESPACE rbs; Rollback segment created. SQL> CREATE ROLLBACK SEGMENT nrbs5 TABLESPACE rbs; Rollback segment created. SQL> CREATE ROLLBACK SEGMENT nrbs6 TABLESPACE rbs; Rollback segment created. SQL> CREATE ROLLBACK SEGMENT nrbs7 TABLESPACE rbs; Rollback segment created.
客户安排导出导入,至此该库恢复完成