2025年9月15日

专业Oracle数据库恢复技术支持 13709885510

主要支持数据库恢复内容但不仅限如此

误drop table 恢复

数据文件大小为0kb

误delete/update 恢复

误truncate table 恢复

asm数据文件丢失/误删除

丢失system文件数据库恢复

asm 磁盘被意外格式化恢复

bootstarp$中对象验证损坏

Oracle数据文件被加密恢复

Oracle dmp文件被加密恢复

asm磁盘组损坏，无法正常mount

操作系统层面误删除数据文件恢复

数据库因为undo损坏/丢失无法正常启动

数据库因为某些数据块损坏不能正常工作

数据库因为ORA-600错误而不能正常启动

exp dmp文件损坏，无法正常导入数据库恢复

数据库因为控制文件损坏/丢失无法正常启动

数据库因为redo损坏/丢失导致无法正常启动

数据库因为数据文件损坏/丢失无法正常启动

数据库因为丢失归档导致数据文件无法online

数据库错误offline system文件导致无法启动

数据库因为操作系统损坏，只有数据文件恢复

数据库因存储异常，导致数据库无法正常启动

expdp dmp文件损坏，无法正常导入数据库恢复

部分asm磁盘丢失导致asm 磁盘组无法正常使用

数据库因为错误的resetlogs操作导致恢复无法继续

数据库因为断电、异常关机等原因导致不能正常启动

以下是比较典型的ORACLE故障恢复

system rollback异常恢复

ORA-00604 ORA-00607 ORA-00600[4194]

Thu Jul 26 13:21:11 2012

Recovery of Online Redo Log: Thread 1 Group 1 Seq 3994 Reading mem 0

Mem# 0: /orasvr/mispdata/redo01.log

Block recovery completed at rba 3994.5.16, scn 0.89979533

Thu Jul 26 13:21:11 2012

Errors in file /orasvr/admin/mispdata/udump/mispdata_ora_2865.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4194], [31], [2], [], [], [], [], []

Error 604 happened during db open, shutting down database

USER: terminating instance due to error 604

Instance terminated by USER, pid = 2865

ORA-1092 signalled during: ALTER DATABASE OPEN...

undo segment异常恢复

ORA-00704 ORA-00604 ORA-01555

Fri May 4 21:04:21 2012

select ctime, mtime, stime from obj$ where obj# = :1

Fri May 4 21:04:21 2012

Errors in file /oracle/admin/standdb/udump/perfdb_ora_1286288.trc:

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01555: snapshot too old: rollback segment number 40 with name "_SYSSMU40$" too small

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Instance terminated by USER, pid = 1286288

ORA-1092 signalled during: alter database open resetlogs...

ORA-00704 ORA-00604 ORA-01173

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Wed Feb 12 10:16:00 2014

SMON: enabling cache recovery

Errors in file H:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_9232.trc:

ORA-01173: data dictionary indicates missing data file from system tablespace

Errors in file H:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_9232.trc:

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01173: data dictionary indicates missing data file from system tablespace

Errors in file H:\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ora_9232.trc:

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01173: data dictionary indicates missing data file from system tablespace

Error 704 happened during db open, shutting down database

USER (ospid: 9232): terminating the instance due to error 704

Instance terminated by USER, pid = 9232

ORA-1092 signalled during: alter database open resetlogs...

obj$事务异常恢复

ORA-00704 ORA-00600[4000]

Thu Feb 28 19:29:10 2013

SMON: enabling cache recovery

Thu Feb 28 19:29:11 2013

Errors in file /u1/PROD/prodora/db/tech_st/10.2.0/admin/PROD_oracle/udump/prod_ora_20989.trc:

ORA-00600: internal error code, arguments: [4000], [50], [], [], [], [], [], []

Thu Feb 28 19:29:13 2013

Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0]

Thu Feb 28 19:29:13 2013

Errors in file /u1/PROD/prodora/db/tech_st/10.2.0/admin/PROD_oracle/udump/prod_ora_20989.trc:

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [4000], [50], [], [], [], [], [], []

Thu Feb 28 19:29:13 2013

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Instance terminated by USER, pid = 20989

ORA-1092 signalled during: ALTER DATABASE OPEN RESETLOGS...

IO异常恢复

ORA-01115 ORA-01110 ORA-27070 OSD-04016

Tue May 14 15:32:10 2013

Completed redo scan

16941 redo blocks read, 1106 data blocks need recovery

Tue May 14 15:32:17 2013

Errors in file d:\oracle\product\10.2.0\admin\water\bdump\water_p002_1472.trc:

ORA-01115: IO error reading block from file 6 (block # 81951)

ORA-01110: data file 6: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\WATER\YD_DATA01.DBF'

ORA-27070: async read/write failed

OSD-04016: 异步 I/O 请求排队时出错。

O/S-Error: (OS 23) 数据错误(循环冗余检查)。

Oracle SCN异常恢复

ORA-600 kcbzib_kcrsds_1

2024-08-24T06:11:27.498146+08:00

Errors in file /oracle/diag/rdbms/xff/xff/trace/xff_ora_1614892.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], []

2024-08-24T06:11:27.501122+08:00

ORA-603 : opitsk aborting process

ORA-600 2662/2663

Wed Feb 21 15:37:35 2024

SMON: enabling cache recovery

Errors in file /oracle/db/diag/rdbms/xff/xff1/trace/xff1_ora_6357664.trc (incident=432423):

ORA-00600: internal error code, arguments: [2662], [6], [576742938], [6], [576834283], [12583104]

Incident details in: /oracle/db/diag/rdbms/xff/xff1/incident/incdir_432423/xff1_ora_6357664_i432423.trc

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 /oracle/db/diag/rdbms/xff/xff1/trace/xff1_ora_6357664.trc:

ORA-00600: internal error code, arguments: [2662], [6], [576742938], [6], [576834283], [12583104], [], [], [], [], [], []

Errors in file /oracle/db/diag/rdbms/xff/xff1/trace/xff1_ora_6357664.trc:

ORA-00600: internal error code, arguments: [2662], [6], [576742938], [6], [576834283], [12583104], [], [], [], [], [], []

Error 600 happened during db open, shutting down database

USER (ospid: 6357664): terminating the instance due to error 600

Instance terminated by USER, pid = 6357664

ASM故障异常恢复

ORA-15066

Tue Nov 26 11:48:22 2024

NOTE: attached to recovery domain 2

NOTE: starting recovery of thread=1 ckpt=716.1536 group=2 (DATA)

NOTE: starting recovery of thread=2 ckpt=763.6248 group=2 (DATA)

NOTE: recovery initiating offline of disk 8 group 2 (*)

NOTE: cache initiating offline of disk 8 group DATA

NOTE: process _user15781_+asm1 (15781) initiating offline of disk 8.3911069996 (DATA_0008) with mask 0x7e in group 2

NOTE: initiating PST update: grp = 2, dsk = 8/0xe91e312c, mask = 0x6a, op = clear

GMON updating disk modes for group 2 at 84 for pid 27, osid 15781

ERROR: Disk 8 cannot be offlined, since diskgroup has external redundancy.

ERROR: too many offline disks in PST (grp 2)

WARNING: Offline for disk DATA_0008 in mode 0x7f failed.

Tue Nov 26 11:48:23 2024

NOTE: halting all I/Os to diskgroup 2 (DATA)

NOTE: recovery (pass 2) of diskgroup 2 (DATA) caught error ORA-15130

Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_15781.trc:

ORA-15130: diskgroup "DATA" is being dismounted

ORA-15066: offlining disk "DATA_0008" in group "DATA" may result in a data loss

ORA-15131: block 97 of file 8 in diskgroup 2 could not be read

ORA-15196: invalid ASM block header [kfc.c:7600] [endian_kfbh] [2147483656] [97] [0 != 1]

ORA-15196

Thu Aug 06 21:04:07 2015

WARNING: cache read (retry) a corrupt block: group=2(ARCH) dsk=0 blk=1 disk=0 (ARCH_0000) au=0 blk=1 count=1

Errors in file /u01/app/11.2.0/grid/log/diag/asm/+asm/+ASM1/trace/+ASM1_ora_27462.trc:

ORA-15196: invalid ASM block header [kfc.c:26076] [endian_kfbh] [2147483648] [1] [0 != 1]

NOTE: a corrupted block from group ARCH was dumped to /u01/app/11.2.0/ /trace/+ASM1_ora_27462.trc

WARNING: cache read (retry) a corrupt block: group=2(ARCH) dsk=0 blk=1 disk=0 (ARCH_0000) au=0 blk=1 count=1

Errors in file /u01/app/11.2.0/grid/log/diag/asm/+asm/+ASM1/trace/+ASM1_ora_27462.trc:

ORA-15196: invalid ASM block header [kfc.c:26076] [endian_kfbh] [2147483648] [1] [0 != 1]

ERROR: cache failed to read group=2(ARCH) dsk=0 blk=1 from disk(s): 0(ARCH_0000)

ORA-15196: invalid ASM block header [kfc.c:26076] [endian_kfbh] [2147483648] [1] [0 != 1]

常见错误信息

表或者索引坏块相关错误

ORA-01578/ORA-08103/ORA-01410/ORA-08102/ORA-600 kdsgrp1/ORA-600 qertbfetchbyrowid/ORA-01499/ORA-01555/ORA-26040/ORA-27046

控制文件异常

ORA-00202/ORA-600 kccsbck_first/ORA-600 kccscf_1/ORA-600[kccsbck_first]/ORA-600 kccsbck_first/ORA-00205/ORA-600 kccpb_sanity_check_2

REDO或者UNDO异常

ORA-00376/ORA-00600 4097/ORA-01595/ORA-600 4194/ORA-600 4193/ORA-600 kcfrbd_3/ORA-00600 4137/ORA-01594/ORA-01555/ORA-00704/ORA-00604/ORA-00607/ORA-600 4000/ORA-00600[3705]/ORA-00316/ORA-00312/ORA-00327/ORA-01623/ORA-01624/ORA-01194/ORA-600 2662/ORA-00368/ORA-00353/ORA-00305/ORA-00340/ORA-00345/ORA-00354

各种ORA-600错误

ORA-600 4497/ORA-600 6947/ORA-600 2662/ORA-600 4194/ORA-600 4193/ORA-00600 4137/ORA-600 4000/ORA- 600 kcrf_resilver_log_1/ORA- 600 kdxlin:psno out of range/ORA-600 3020/ORA-600 kccpb_sanity_check_2/ORA-600 3705/ORA-600 kccscf_1/ORA-600 kghstack_free2/ORA-600 kcfrbd_3/ORA-600 ktbdchk1: bad dscn/ORA-600 2252/ORA-600 kcratr_nab_less_than_odr/ORA-600 kccsbck_first/ORA-600 kcratr1_lostwrt/ORA-600 ktspNextL1:4/ORA-600 13013/ORA-600 kdsgrp1/ORA-600 kmgs_parameter_update_timeout_1/ORA-600 kcbgtcr_1/ORA-600 kcbgtcr_1a/ORA-600 kcbgtcr_3/ORA-600 kcbgtcr_4/ORA-600 kcbgtcr_5/ORA-600 kcbgtcr_6/ORA-600 kcbgtcr_7/ORA-600 kcbgtcr_10/ORA-600 kcbgtcr_12/ORA-600 kcbgtcr_13/ORA-600 qertbfetchbyrowid/ORA-600 kmgs_parameter_update_timeout_1