发表于
2016-09-28 14:49:43
kfed read asm disk header
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/kfed-read-asm-disk-header.html标题：kfed read asm disk header作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]kfed读取数据磁盘头主要参数解释说明% kfed read /dev/raw/raw1
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.chec
...继续阅读
(78)
发表于
2016-09-28 14:44:24
通过update _NEXT_OBJECT 实现obj$.obj#和obj$.dataobj#跳号
发表于
2016-09-28 14:42:19
ORA-15042—hp rdisk丢失
发表于
2016-09-28 14:41:26
ORA-600 kcbz_check_objd_typ_N恢复
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-600-kcbz_check_objd_typ_n%e6%81%a2%e5%a4%8d.html标题：ORA-600 kcbz_check_objd_typ_N恢复作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]客户数据库异常(ORA-600 kcbz_check_objd_typ_1),让我们远程给分析处理ORA-600 kcbz_check_objd_typ_1异常Mon Aug 8 12:19:28 2016
Completed: ALTER DATABASE OPEN
Mon Aug 8 12:19:29 2016
db_recovery_file_dest_size of 20480 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesyst
...继续阅读
(79)
发表于
2016-09-28 14:33:23
MON_MODS$表ORA-600 13013报错处理
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/mon_mods%e8%a1%a8ora-600-13013%e6%8a%a5%e9%94%99%e5%a4%84%e7%90%86.html标题：MON_MODS$表ORA-600 13013报错处理作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]有朋友反馈数据库启动运行一点时间之后,然后就自动crash,让我们帮忙找原因,通过分析是由于smon进程触发ORA-600 13013导致数据库异常alert日志报错信息Thu Aug 4 18:39:44 2016
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=33, OS id=22935
Thu Aug 4 18:39:44 2016
Completed: ALTER DATABASE OPEN
Thu Aug 4 18:39:44 2016
db_recovery_fi
...继续阅读
(66)
发表于
2016-09-28 14:32:10
ORA-600 4042
发表于
2016-09-28 14:27:37
ORA-600 4194/ORA-600 4193/ORA-600 4137 恢复思路
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-600-4194ora-600-4193ora-600-4137-%e6%81%a2%e5%a4%8d%e6%80%9d%e8%b7%af.html标题：ORA-600 4194/ORA-600 4193/ORA-600 4137 恢复思路作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]对于常见的undo异常错误,ORA-600 4193,ORA-600 4194,ORA-600 4137等错误的处理一般步骤.适用版本Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.报错现象The following error is occurring in the alert.log right before the database crashes.
ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [],
...继续阅读
(70)
发表于
2016-09-28 14:20:45
ORA-600 kdsgrp1
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-600-kdsgrp1.html标题：ORA-600 kdsgrp1作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]在硬件恢复,断电,redo异常等恢复case中ORA-600 [kdsgrp1]是一个比较常见的错误,这里该出来官方关于该错误的解释说明和处理方法RROR:
Format: ORA-600 [kdsgrp1]
VERSIONS:
versions 10.1 and above
DESCRIPTION:
This error was introduced in 10g with the fix to Bug 2442351, it provides
for an extra health check on a block, we detected a null row header,
see Note:2442351.9 for more information.
Error may be caused by:
Case 1. A row referenced in an index that does not exist in the table.
Case 2. A
...继续阅读
(76)
发表于
2016-09-28 14:18:22
ORA-600 2663分析
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-600-2663%e5%88%86%e6%9e%90.html标题：ORA-600 2663分析作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]在大家熟悉的ORA-600 2662错误中还有一个类似的ORA-600 2663的错误,以下是对该2663的解释说明ERROR:
Format: ORA-600 [2663] [a] [b] {c} [d]
VERSIONS:
versions 10.1 to 11.1
DESCRIPTION:
A data block SCN is ahead of the current SCN.
The ORA-600 [2663] occurs when an SCN is compared to the dependent SCN
stored in a UGA variable.
If the SCN is less than the dependent SCN then we signal the ORA-600 [2663]
internal error.
ARGUMENTS:
Arg [a] Current SCN WRAP
...继续阅读
(75)
发表于
2016-08-01 05:57:27
_ALLOW_RESETLOGS_CORRUPTION 参数
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/_allow_resetlogs_corruption-%e5%8f%82%e6%95%b0.html标题：_ALLOW_RESETLOGS_CORRUPTION 参数作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]我相信_ALLOW_RESETLOGS_CORRUPTION 这个参数一定很多人都熟悉,是redo异常恢复的杀手锏之一,以下文章是来自官方的解释DB_Parameter _ALLOW_RESETLOGS_CORRUPTION
========================================
This documentation has been prepared avoiding the mention of the complex
structures from the code and to simply give an insight to the 'damage it could
cause'. The usage of this parameter leads to an in-consistent Database with no
other alternative b
...继续阅读
(112)
发表于
2016-08-01 05:55:23
ORA-600 999
发表于
2016-08-01 05:47:49
_OFFLINE_ROLLBACK_SEGMENTS _CORRUPTED_ROLLBACK_SEGMENTS
发表于
2016-08-01 05:46:50
oracle asm系列文章汇总—www.xifenfie.com
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/oracle-asm%e7%b3%bb%e5%88%97%e6%96%87%e7%ab%a0%e6%b1%87%e6%80%bb-www-xifenfie-com.html标题：oracle asm系列文章汇总—www.xifenfie.com作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]为了方便大家更容易的查看相关asm内容,今天(2016年7月28日)对asm的相关文章进行了汇总整理.如果有asm相关的其他问题,可以通过手机(13429648788)或者QQ(107644445)交流远程访问ASMASMCMD常用命令ASM简单管理(1)ASM简单管理(2)找回ASM中数据文件bbed修改ASM中数据ASM迁移至文件系统普通库迁移至ASM存储使用dd复制asm中文件配置Oracle ASM磁盘ASM中磁盘组权限设置监控asm disk磁盘性能create spfile to asmpvid=yes导致asm无法mount—ASM恢复案例asm数据文件迁移(os–>asm)asm数据文件迁移(asm–>asm)asm数据文件迁移(asm–>os)asm disk格式化为ntfs恢复—A
...继续阅读
(93)
发表于
2016-08-01 05:45:39
ORA-600 [4193]
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-600-4193.html标题：ORA-600 [4193]作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]ORA-600 4193 解释说明ERROR:
Format: ORA-600 [4193] [a] [b]
VERSIONS:
versions 6.0 to 12.1
DESCRIPTION:
A mismatch has been detected between Redo records and Rollback (Undo)
records.
We are validating the Undo block sequence number in the undo block against
the Redo block sequence number relating to the change being applied.
This error is reported when this validation fails.
ARGUMENTS:
Arg [a] Undo record
...继续阅读
(100)
发表于
2016-08-01 05:44:32
ORA-600 [4194]
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-600-4194.html标题：ORA-600 [4194]作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]在oracle恢复中ORA-600 4194是一个非常常见的错误,该错误的主要原因是由于redo记录和undo(rollback)记录不匹配.ORA 600 4194错误原因以及含义ERROR:
Format: ORA-600 [4194] [a] [b]
VERSIONS:
versions 6.0 to 12.1
DESCRIPTION:
A mismatch has been detected between Redo records and rollback (Undo)
records.
We are validating the Undo record number relating to the change being
applied against the maximum undo record number recorded in the undo block.
This error is r
...继续阅读
(93)
发表于
2016-08-01 05:43:36
oracle exadata force open
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/oracle-exadata-force-open.html标题：oracle exadata force open作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]这个库的恢复有一些历史故事(【力荐】Exadata火线救援：10TB级数据修复经典案例详解！)：xx运营商x2的1/4配置的oracle exadata机器，跑了近6年，最近有一个cell节点主机异常,在rebalance过程中,只有两个节点的cell其中一个节点坏了一个硬盘导致.导致asm diskgroup无法正常mount,最后该运营商运维三方通过amdu把该一体机中的数据文件全部抽出来,然后在恢复过程中出现大量错误无法解决,请求我们支持数据库open过程报ORA-01555错误Thu Jul 14 00:01:04 2016
alter database open
Thu Jul 14 00:01:04 2016
Thread 1 advanced to log sequence 2 (thread open)
Thread 1 opened at log sequence 2
Current log# 2 seq# 2 mem# 0: /dat
...继续阅读
(101)
发表于
2016-08-01 05:41:09
Oracle 12c undo recovery
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/oracle-12c-undo-recovery.html标题：Oracle 12c undo recovery作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]在12c pdb环境中如果root pdb的undo文件异常，数据库该如何恢复呢？这篇文章模拟undo丢失的情况下进行恢复模拟环境三个会话，其中第一个会话对pdb1中的表进行操作，并且有事务未提交,第二个会话对pdb2进行操作，也未提交事务；第三个会话直接abort库，模拟突然库异常，然后删除root pdb下面的undo文件--会话1
[oracle@ora1221 oradata]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.0.3 Production on Thu Jun 16 22:24:20 2016
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global
...继续阅读
(103)
发表于
2016-08-01 05:39:57
Oracle 12c redo Recovery
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/oracle-12c-redo-recovery.html标题：Oracle 12c redo Recovery作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]模拟redo丢失对数据库的一个pdb模拟事务操作，然后abort库，并且删除所有redo，模拟生产环境redo丢失的case[oracle@ora1221 oradata]$ ss
SQL*Plus: Release 12.2.0.0.3 Production on Wed Jun 15 10:13:20 2016
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2516582400 bytes
Fixed Size 8260048 bytes
Variable Size 671090224 bytes
Database Buffers
...继续阅读
(97)
发表于
2016-08-01 05:37:05
Oracle 12c oradebug
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/oracle-12c-oradebug.html标题：Oracle 12c oradebug作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]最近有不少朋友咨询12.1.0.2及其以后的版本使用oradebug去修改scn失败,这里做了一个测试正常情况下确实无法修改(oradebug poke报 ORA-32519 或者 ORA-32521) ,这里进行了一系列修改测试最后修改成功.数据库版本SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Relea
...继续阅读
(101)
发表于
2016-05-28 05:41:29
Solaris rm datafile recovery
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/solaris-rm-datafile-recovery.html标题：Solaris rm datafile recovery作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]今天早上接到有客户恢复请求，他一不小心在solaris系统中使用rm -rf oradata命令把一个分区下面的所有数据文件全部删除了。现在不知道怎么办,请求我们给予支持.上去检查发现比较幸运,数据库没有crash,看来直接考虑使用句柄进行恢复root@CNISORCLSVR # uname -a
SunOS CNISORCLSVR 5.9 Generic_112233-08 sun4u sparc SUNW,Sun-Fire-880
root@CNISORCLSVR # ps -ef|grep lgwr
oracle 597 1 0 Mar 05 ? 17:14 ora_lgwr_xifenfei
root 28069 28043 0 18:51:17 pts/2 0:00 grep lgwr
root@CNISORCLSVR # ls -ltr
total 189348454
-r--r--
...继续阅读
(94)
发表于
2016-05-28 05:40:24
ORA-00354 ORA-00353 ORA-00312异常处理
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-00354-ora-00353-ora-00312%e5%bc%82%e5%b8%b8%e5%a4%84%e7%90%86.html标题：ORA-00354 ORA-00353 ORA-00312异常处理作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]数据库启动报错WIN平台oracle 9.2.0.6版本数据库redo log block header损坏，ORA-00354 ORA-00353 ORA-00312错误导致数据库无法启动SQL >alter database open;
*
ERROR at line 1:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1892904 change 281470950178815
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ZOYO\REDO03.LOG'Sun Jan 24 15:44:05 2016
Database mounted in Exclusive Mode.
Compl
...继续阅读
(80)
发表于
2016-05-28 05:39:45
分区无法识别导致asm diskgroup无法mount
发表于
2016-05-28 05:39:09
file 1 block 128 corrupted system回滚段坏块修复
发表于
2016-05-28 05:38:23
ORA-01172 ORA-01151 故障恢复
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-01172-ora-01151-%e6%95%85%e9%9a%9c%e6%81%a2%e5%a4%8d.html标题：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
T
...继续阅读
(78)
发表于
2016-05-28 05:37:42
csc(0×0000.1f8adab3) higher than block scn(0×0000.00000000)
发表于
2016-05-28 05:36:48
强制关机导致数据库无法正常启动恢复
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/%e5%bc%ba%e5%88%b6%e5%85%b3%e6%9c%ba%e5%af%bc%e8%87%b4%e6%95%b0%e6%8d%ae%e5%ba%93%e6%97%a0%e6%b3%95%e6%ad%a3%e5%b8%b8%e5%90%af%e5%8a%a8%e6%81%a2%e5%a4%8d.html标题：强制关机导致数据库无法正常启动恢复作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]有客户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
...继续阅读
(80)
发表于
2015-12-20 17:52:09
存储异常导致数据库不能启动恢复
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/%e5%ad%98%e5%82%a8%e5%bc%82%e5%b8%b8%e5%af%bc%e8%87%b4%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%8d%e8%83%bd%e5%90%af%e5%8a%a8%e6%81%a2%e5%a4%8d.html标题：存储异常导致数据库不能启动恢复作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]xx医院存储突然掉线,导致数据库异常,现场工程师折腾了一天,问题依旧没有解决,无奈之下找到我们,希望我们能够帮忙恢复数据库.启动报ORA-00600[2131]错误Fri Nov 06 14:50:59 2015
ALTER DATABASE MOUNT
This instance was first to mount
Fri Nov 06 14:50:59 2015
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.4.4)(PORT=1521))' SCOPE=MEMORY SID='xifenfei1';
NOTE: Loaded library: System
...继续阅读
(114)
发表于
2015-12-20 17:50:57
ORA-600 4155
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/ora-600-4155.html标题：ORA-600 4155作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]某客户使用win 2003，Oracle 11.2.0.1+ASM架构方式,由于存储异常并且做了存储恢复之后,ASM可以正常mount起来,但是数据库无法打开使用dbv检查system发现有少量坏块DBVERIFY - 开始验证: FILE = +DATA/xifenfei/datafile/system.256.764288125
页 3117 标记为损坏
Corrupt block relative dba: 0x00400c2d (file 1, block 3117)
Bad header found during dbv:
Data in bad block:
type: 11 format: 2 rdba: 0x00400001
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000b01
check
...继续阅读
(92)
发表于
2015-12-20 17:49:52
存储异常导致ORA-10562故障恢复
联系：手机(13429648788) QQ(107644445)链接：http://www.orasos.com/%e5%ad%98%e5%82%a8%e5%bc%82%e5%b8%b8%e5%af%bc%e8%87%b4ora-10562%e6%95%85%e9%9a%9c%e6%81%a2%e5%a4%8d.html标题：存储异常导致ORA-10562故障恢复作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]朋友数据库由于存储变动,导致数据库瞬间hang住,然后直接crash,之后无法正常启动,请求技术支持.数据库报ORA-00600[2131]错误不能mount,可以通过重建控制文件解决Mon Nov 30 20:35:38 2015
alter database mount
Mon Nov 30 20:35:38 2015
NOTE: Loaded library: System
Mon Nov 30 20:35:38 2015
SUCCESS: diskgroup DATADG was mounted
Mon Nov 30 20:35:38 2015
NOTE: dependency between database xifenfei and diskgroup resource ora.DATADG.dg is estab
...继续阅读
(98)
发表于
2015-12-20 17:48:31
asm disk格式化恢复
