标签云
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 2131 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)
- 操作系统 (102)
- 数据库 (1,674)
- DB2 (22)
- MySQL (73)
- Oracle (1,536)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (22)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (562)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (78)
- 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)
-
最近发表
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
- 数据库启动报ORA-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
标签归档:ORA-600 2130
ORA-15096: lost disk write detected
又一例由于存储掉电导致asm磁盘组,由于ORA-15096: lost disk write detected,导致无法mount的恢复请求
SQL> ALTER DISKGROUP DATA MOUNT /* asm agent *//* {1:45277:148} */ NOTE: cache registered group DATA number=2 incarn=0x73886b6a NOTE: cache began mount (first) of group DATA number=2 incarn=0x73886b6a NOTE: Assigning number (2,2) to disk (/dev/asm-data3) NOTE: Assigning number (2,1) to disk (/dev/asm-data2) NOTE: Assigning number (2,0) to disk (/dev/asm-data1) Fri Nov 06 19:06:56 2020 NOTE: GMON heartbeating for grp 2 GMON querying group 2 at 94 for pid 30, osid 11596 NOTE: cache opening disk 0 of grp 2: DATA_0000 path:/dev/asm-data1 NOTE: F1X0 found on disk 0 au 2 fcn 0.0 NOTE: cache opening disk 1 of grp 2: DATA_0001 path:/dev/asm-data2 NOTE: cache opening disk 2 of grp 2: DATA_0002 path:/dev/asm-data3 NOTE: cache mounting (first) external redundancy group 2/0x73886B6A (DATA) Fri Nov 06 19:06:57 2020 * allocate domain 2, invalid = TRUE kjbdomatt send to inst 2 Fri Nov 06 19:06:57 2020 NOTE: attached to recovery domain 2 NOTE: starting recovery of thread=1 ckpt=25.7986 group=2 (DATA) NOTE: starting recovery of thread=2 ckpt=33.364 group=2 (DATA) NOTE: BWR validation signaled ORA-15096 Errors in file /u01/app/oracle/diag/asm/+asm/+ASM1/trace/+ASM1_ora_11596.trc: ORA-15096: lost disk write detected NOTE: crash recovery signalled OER-15096 ERROR: ORA-15096 signalled during mount of diskgroup DATA NOTE: cache dismounting (clean) group 2/0x73886B6A (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 11596, image: oracle@db1 (TNS V1-V3) NOTE: lgwr not being msg'd to dismount kjbdomdet send to inst 2 detach from dom 2, sending detach message to inst 2 freeing rdom 2 NOTE: detached from domain 2 NOTE: cache dismounted group 2/0x73886B6A (DATA) NOTE: cache ending mount (fail) of group DATA number=2 incarn=0x73886b6a NOTE: cache deleting context for group DATA 2/0x73886b6a GMON dismounting group 2 at 95 for pid 30, osid 11596 NOTE: Disk DATA_0000 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0001 in mode 0x7f marked for de-assignment NOTE: Disk DATA_0002 in mode 0x7f marked for de-assignment ERROR: diskgroup DATA was not mounted ORA-15032: not all alterations performed ORA-15096: lost disk write detected ERROR: ALTER DISKGROUP DATA MOUNT /* asm agent *//* {1:45277:148} */
通过判断,通过一系列处理之后,数据库进行了mount操作发现报错ORA-600 2130
Fri Nov 06 17:03:27 2020 ALTER DATABASE RECOVER database Media Recovery Start started logmerger process Parallel Media Recovery started with 40 slaves Fri Nov 06 17:03:29 2020 Errors in file /u01/app/oracle/diag/rdbms/ynhis/ynhis1/trace/ynhis1_pr00_7393.trc (incident=195869): ORA-00600: internal error code, arguments: [2130], [2], [1], [2], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/ynhis/ynhis1/incident/incdir_195869/ynhis1_pr00_7393_i195869.trc Fri Nov 06 17:03:30 2020 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Media Recovery failed with error 600 ORA-10877 signalled during: ALTER DATABASE RECOVER database ...
判断redo异常,通过resetlogs打开库,发现报错ORA-00600 2662
Fri Nov 06 18:21:32 2020 alter database open resetlogs RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 8670753264 Resetting resetlogs activation ID 306909514 (0x124b114a) Redo thread 2 enabled by open resetlogs or standby activation Fri Nov 06 18:21:39 2020 Setting recovery target incarnation to 2 Initializing SCN for created control file Database SCN compatibility initialized to 3 Warning - High Database SCN: Current SCN value is 8670753267, threshold SCN value is 0 Fri Nov 06 18:21:39 2020 Assigning activation ID 408224320 (0x18550240) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /orabak/data/group_1.289.954514319 Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Nov 06 18:21:40 2020 SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/ynhis/ynhis1/trace/ynhis1_ora_24310.trc (incident=231847): ORA-00600: internal error code, arguments: [2662], [2], [80818679], [2], [93545365], [4194545], [], [], [], [], [],[] Incident details in: /u01/app/oracle/diag/rdbms/ynhis/ynhis1/incident/incdir_231847/ynhis1_ora_24310_i231847.trc Fri Nov 06 18:21:42 2020 Dumping diagnostic data in directory=[cdmp_20201106182142],requested by(instance=1,osid=24310),summary=[incident=231847] Fri Nov 06 18:21:43 2020 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /u01/app/oracle/diag/rdbms/ynhis/ynhis1/trace/ynhis1_ora_24310.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [2662], [2], [80818679], [2], [93545365],[4194545],[],[],[],[],[],[] Errors in file /u01/app/oracle/diag/rdbms/ynhis/ynhis1/trace/ynhis1_ora_24310.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [2662], [2], [80818679], [2], [93545365],[4194545],[],[],[],[],[],[] Error 704 happened during db open, shutting down database USER (ospid: 24310): terminating the instance due to error 704 Instance terminated by USER, pid = 24310 ORA-1092 signalled during: alter database open resetlogs... opiodr aborting process unknown ospid (24310) as a result of ORA-1092
处理该错误之后,数据库resetlog之后,数据库open成功但是报错ORA-00600 4137
Database Characterset is ZHS16GBK Errors in file /u01/app/oracle/diag/rdbms/ynhis/ynhis1/trace/ynhis1_smon_26195.trc (incident=255799): ORA-00600: internal error code, arguments: [4137], [25.33.122556], [0], [0], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/ynhis/ynhis1/incident/incdir_255799/ynhis1_smon_26195_i255799.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. No Resource Manager plan active Fri Nov 06 18:30:46 2020 replication_dependency_tracking turned off (no async multimaster replication found) ORACLE Instance ynhis1 (pid = 23) - Error 600 encountered while recovering transaction (25, 33). Errors in file /u01/app/oracle/diag/rdbms/ynhis/ynhis1/trace/ynhis1_smon_26195.trc: ORA-00600: internal error code, arguments: [4137], [25.33.122556], [0], [0], [], [], [], [], [], [], [], []
对异常undo进行处理,数据库可以正常启动关闭,然后安排数据导出导入新库操作,恢复完成.
数据库恢复遭遇ORA-00600[3705]
某个客户在一台机器上装3个oracle数据库,机器蓝屏后,使用pe拷贝出来所有数据文件,redo文件,控制文件等,在尝试恢复过程中,三个库都出现同样的ORA-600[3705]错误,在以前的数据库恢复中对于redo异常,使用过N次类似方法出来都未出问题,但是在ORACLE 9.2.0.1版本中确实出现诡异现象,这里记录处理过程和大家分享
尝试恢复数据库
C:\Documents and Settings\Administrator>set oracle_sid=telnet C:\Documents and Settings\Administrator>sqlplus/nolog SQL*Plus: Release 9.2.0.1.0 - Production on 星期日 5月 25 13:04:29 2014 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn / as sysdba 已连接。 SQL> select open_mode from v$database; OPEN_MODE ---------- MOUNTED SQL> alter database open; alter database open * ERROR 位于第 1 行: ORA-01113: 文件 2 需要介质恢复 ORA-01110: 数据文件 2: 'E:\ORACLE\ORADATA\TELNET\UNDOTBS01.DBF' SQL> recover database; ORA-00283: 恢复会话因错误而取消 ORA-00322: 日志 2 (线程 1) 不是当前副本 ORA-00312: 联机日志 2 线程 1: 'E:\ORACLE\ORADATA\TELNET\REDO02.LOG'
redo异常,尝试使用_allow_resetlogs_corruption参数启动数据库
SQL> startup mount pfile='c:\pfile.txt' ORACLE 例程已经启动。 Total System Global Area 126950220 bytes Fixed Size 453452 bytes Variable Size 109051904 bytes Database Buffers 16777216 bytes Redo Buffers 667648 bytes 数据库装载完毕。 SQL> recover database until cancel; ORA-00279: 更改 66763056 (在 05/12/2014 09:50:10 生成) 对于线程 1 是必需的 ORA-00289: 建议: E:\ORACLE\ORA92\RDBMS\ARC00312.001 ORA-00280: 更改 66763056 对于线程 1 是按序列 # 312 进行的 指定日志: {<RET>=suggested | filename | AUTO | CANCEL} cancel ORA-01547: 警告: RECOVER 成功但 OPEN RESETLOGS 将出现如下错误 ORA-01194: 文件1需要更多的恢复来保持一致性 ORA-01110: 数据文件 1: 'E:\ORACLE\ORADATA\TELNET\SYSTEM01.DBF' ORA-01112: 未启动介质恢复 SQL> alter database open resetlogs; alter database open resetlogs * ERROR 位于第 1 行: ORA-03113: 通信通道的文件结束
查看alert日志
Sun May 25 15:35:02 2014 ALTER DATABASE RECOVER CANCEL ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ... Sun May 25 15:35:02 2014 ALTER DATABASE RECOVER CANCEL ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ... Sun May 25 15:35:09 2014 alter database open resetlogs RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 66763056 Resetting resetlogs activation ID 0 (0x0) Sun May 25 15:35:20 2014 Assigning activation ID 2117757301 (0x7e3a6975) Sun May 25 15:35:20 2014 Errors in file e:\oracle\admin\telnet\bdump\telnet_lgwr_12140.trc: ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [1], [], [], [] Sun May 25 15:35:56 2014 Errors in file e:\oracle\admin\telnet\bdump\telnet_lgwr_12140.trc: ORA-00600: internal error code, arguments: [3705], [1], [1], [1], [1], [], [], [] LGWR: terminating instance due to error 600 Instance terminated by LGWR, pid = 12140
创建控制文件继续恢复
SQL> recover database until cancel; ORA-00283: 恢复会话因错误而取消 ORA-00600: 内部错误代码,参数: [2130], [0], [1], [2], [], [], [], [] SQL> alter database backup controlfile to trace as 'c:\ctl.txt'; 数据库已更改。 SQL> alter database open; alter database open * ERROR 位于第 1 行: ORA-03113: 通信通道的文件结束 SQL> startup nomount ORACLE 例程已经启动。 Total System Global Area 126950220 bytes Fixed Size 453452 bytes Variable Size 109051904 bytes Database Buffers 16777216 bytes Redo Buffers 667648 bytes SQL> CREATE CONTROLFILE REUSE DATABASE "TELNET" NORESETLOGS NOARCHIVELOG 2 MAXLOGFILES 50 3 MAXLOGMEMBERS 5 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 226 7 LOGFILE 8 GROUP 1 'E:\ORACLE\ORADATA\TELNET\REDO01.LOG' SIZE 100M, 9 GROUP 2 'E:\ORACLE\ORADATA\TELNET\REDO02.LOG' SIZE 100M, 10 GROUP 3 'E:\ORACLE\ORADATA\TELNET\REDO03.LOG' SIZE 100M 11 DATAFILE 12 'E:\ORACLE\ORADATA\TELNET\SYSTEM01.DBF', 13 'E:\ORACLE\ORADATA\TELNET\UNDOTBS01.DBF', 14 'E:\ORACLE\ORADATA\TELNET\CWMLITE01.DBF', 15 'E:\ORACLE\ORADATA\TELNET\DRSYS01.DBF', 16 'E:\ORACLE\ORADATA\TELNET\EXAMPLE01.DBF', 17 'E:\ORACLE\ORADATA\TELNET\INDX01.DBF', 18 'E:\ORACLE\ORADATA\TELNET\ODM01.DBF', 19 'E:\ORACLE\ORADATA\TELNET\TOOLS01.DBF', 20 'E:\ORACLE\ORADATA\TELNET\USERS01.DBF', 21 'E:\ORACLE\ORADATA\TELNET\XDB01.DBF' 22 CHARACTER SET ZHS16GBK 23 ; 控制文件已创建 SQL> recover database; ORA-00283: 恢复会话因错误而取消 ORA-00264: 不要求恢复 SQL> alter database open; 数据库已更改。