发表于
2016-11-01 14:27:50
File #N is offline, but is part of an online tablespace
发表于
2016-10-29 03:07:48
ORA-27300 ORA-27301 ORA-27302
发表于
2016-10-24 12:49:48
ORA-600 kcrfr_update_nab_2 故障恢复
发表于
2016-10-24 11:04:52
存储精简卷导致asm磁盘组异常
联系：手机(+86 13429648788) QQ(107644445)标题：存储精简卷导致asm磁盘组异常作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有朋友在一个存储空间给asm使用，发生空间不足，然后使用另外一个存储中的lun给asm的data磁盘组增加asm disk,运行了大概1天之后,asm磁盘组直接dismount,数据库crash.然后就无法正常mount.包括这个存储上的几个其他磁盘组也无法正常mount.数据库异常日志Sun Oct 23 08:43:59 2016
SUCCESS: diskgroup DATA was dismounted
SUCCESS: diskgroup DATA was dismounted
Sun Oct 23 08:44:00 2016
Errors in file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lmon_79128.trc:
ORA-00202: control file: '+DATA/orcl/controlfile/current.278.892363163'
ORA-15078: ASM diskgroup was forcibly dismounted
Sun Oct 23 08:44:0
...继续阅读
(59)
发表于
2016-10-23 07:19:48
ORA-20011 KUP-11024错误分析
联系：手机(+86 13429648788) QQ(107644445)标题：ORA-20011 KUP-11024错误分析作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库alert日志出现ORA-20011 KUP-11024等错误Thu Sep 22 18:00:31 2016
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /u1/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_j002_2686.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.从报错的信息看应该是数据库收集统计信息报错(GATHER_STATS_JOB)，但是报错原因是由于访问外部表导致,而该外部表很可能和data pump有关系.查看trace日志[oracle@xifen
...继续阅读
(64)
发表于
2016-10-22 15:37:59
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets—201610
联系：手机(+86 13429648788) QQ(107644445)标题：Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets—201610作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]Patchsetsl12.1.0.2(12.1.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER)2141922111.2.0.4(11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER)1339067711.2.0.3(11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER)1040453011.2.0.2(11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER)1009881611.1.0.7(11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER)689083110.2.0.5(10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER)8202632d10.2.0.4(10.2.0.4
...继续阅读
(78)
发表于
2016-10-17 15:26:07
alter database create datafile 导致数据文件丢失恢复
发表于
2016-09-28 11:17:02
dul无法加载bootstrap实现unload table/user恢复
联系：手机(+86 13429648788) QQ(107644445)标题：dul无法加载bootstrap实现unload table/user恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]最近有朋友误操作引起了非常大的事故,差点吃了官司.在做数据库迁移的时候，远程误操作删除了原库的system等几个数据库初始安装的文件,而且该磁盘空间使用率非常高,还有少量写入.最后结果比较悲剧,通过文件系统层面无法直接恢复出来数据文件,而且该库无任何有效备份,又没有表名,列名等信息,无奈之下只能通过底层io block重组来恢复数据文件,可是悲剧又一次发生,这个磁盘上以前也有一份system等文件,最后经过多方重组恢复出来一份相对理想的数据文件.但是第三方公司通过这样重组出来的数据文件和未被删除的业务文件恢复出来的数据大量有问题，依旧需要我们进一步分析恢复处理.这篇文章主要描述了dul在无法加载bootstrap命令之后通过一些方法依旧可以正常使用unload table/user 等命令实现数据尽可能恢复.你要知道几百张表没有表名/列名要把他们区分出来那是什么样的工作量……在dul中配置system文件D:\xifenfei\system01.dbf
D:\TEMP\recover\dul\bak>dul
Data Un
...继续阅读
(55)
发表于
2016-09-09 01:23:01
通过kfed说明asm disk header定义
联系：手机(+86 13429648788) QQ(107644445)标题：通过kfed说明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.check: 2932902794 ; 0x00c: 0xaed08b
...继续阅读
(54)
发表于
2016-09-06 03:04:48
通过update _NEXT_OBJECT 实现obj$.obj#和obj$.dataobj#跳号
发表于
2016-09-05 11:52:29
使用alter system events导致库crash
联系：手机(+86 13429648788) QQ(107644445)标题：使用alter system events导致库crash作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于数据库导入大量数据的时候io等待比较高，新的存储无法直接挂过来，考虑使用nfs挂载过来，然后存放redo缓解io压力。数据库版本信息SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production挂载参数(mount命令查看)10.240.10.1 /top/data4/nfs /back1 nfs
...继续阅读
(59)
发表于
2016-08-27 15:33:05
hp平台rdisk中磁盘丢失导致asm启动报ORA-15042恢复
发表于
2016-08-08 13:58:03
ORA-600 kcbz_check_objd_typ_1 处理
联系：手机(+86 13429648788) QQ(107644445)标题：ORA-600 kcbz_check_objd_typ_1 处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户数据库异常(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 filesystem or ASM diskgroup.
Mon Aug 8 12:19:33 2016
Errors in file /home/or
...继续阅读
(64)
发表于
2016-08-07 15:07:35
linux 7(redhat,oracle linux,centos)中使用udev
联系：手机(+86 13429648788) QQ(107644445)标题：linux 7(redhat,oracle linux,centos)中使用udev作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]慢慢的linux 7的使用人越来越多了,但是linux 7相对于5和6的版本,变动确实比较大,本文主要描写在linux 7中如何实现udev,实现设备持久化,权限和所属组的修改linux版本Oracle Linux Server release 7.1
[root@www.xifenfei.com ~]# uname -a
Linux www.xifenfei.com 3.10.0-229.el7.x86_64 #1 SMP Fri Mar 6 04:05:24 PST 2015 x86_64 x86_64 x86_64 GNU/LinuxVMware Workstation中显示uuid需要在vmx文件中增加disk.enableUUID = "TRUE"查看磁盘分区[root@www.xifenfei.com ~]# fdisk -l
Disk /dev/sdb: 21.5 GB, 21474836480 bytes, 41943040 sectors
Units = sectors of 1 *
...继续阅读
(65)
发表于
2016-08-06 04:06:45
MON_MODS$表ORA-600 13013报错处理
联系：手机(+86 13429648788) QQ(107644445)标题：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_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of sp
...继续阅读
(104)
发表于
2016-08-05 05:40:18
ORA-600 4042 故障恢复
发表于
2016-08-04 06:04:29
ORA-600 4194/ORA-600 4193/ORA-600 4137故障解决
联系：手机(+86 13429648788) QQ(107644445)标题：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], [#], [#], [], [], [], [], []
This error indicates that a mismatch has been detected between redo records and rollback
...继续阅读
(89)
发表于
2016-08-04 04:24:24
ORA-600 3020
联系：手机(+86 13429648788) QQ(107644445)标题：ORA-600 3020作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]ORA-600 3020官方解释说明ERROR:
Format: ORA-600 [3020] [a] [b] {c} [d] [e]
VERSIONS:
version 6.0 and above
DESCRIPTION:
This is called a 'STUCK RECOVERY'.
There is an inconsistency between the information stored in the redo
and the information stored in a database block being recovered.
ARGUMENTS:
For Oracle 9.2 and earlier:
Arg [a] Block DBA
Arg [b] Redo Thread
Arg 1 Redo RBA Seq
Arg [d] Redo RBA Block No
Arg [e] Redo RBA Offset.
For Oracle 10.1
Arg [a] Absolute file num
...继续阅读
(80)
发表于
2016-08-03 12:50:07
ORA-600 kdsgrp1
联系：手机(+86 13429648788) QQ(107644445)标题：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. An non-existent rowid pointed to by a c
...继续阅读
(123)
发表于
2016-08-02 10:05:41
ORA-600 2663
联系：手机(+86 13429648788) QQ(107644445)标题：ORA-600 2663作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在大家熟悉的ORA-600 2662错误中还有一个类似的ORA-600 2663的错误,以下是对该2663的解释说明ERROR:
Format: ORA-600 [2663] [a] [b] 1 [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
Arg [b] Current SCN BASE
Arg 1 dependent SCN WRAP
...继续阅读
(87)
发表于
2016-08-01 12:19:50
ORA-600 2662
联系：手机(13429648788) QQ(107644445)标题：ORA-600 2662作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在数据库恢复中,ORA-600 2662我想是很多人都非常熟悉的错误,下文是对于该错误的一些解释ORA-600 2662解释说明ERROR:
Format: ORA-600 [2662] [a] [b] 1 [d] [e]
VERSIONS:
versions 6.0 to 12.1
DESCRIPTION:
A data block SCN is ahead of the current SCN.
The ORA-600 [2662] 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 [2662]
internal error.
ARGUMENTS:
Arg [a] Current SCN WRAP
Arg [b] Current SCN BASE
Arg
...继续阅读
(93)
发表于
2016-08-01 03:49:02
ORA-600 999 异常恢复
发表于
2016-07-31 12:04:42
_ALLOW_RESETLOGS_CORRUPTION
联系：手机(13429648788) QQ(107644445)标题：_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 but to rebuild the complete Database. This parameter could
be used when we
...继续阅读
(81)
发表于
2016-07-30 10:22:25
数据库恢复的敏感性—重建控制文件使用不合适数据文件
发表于
2016-07-30 08:06:27
kfed找出来asm 磁盘组中数据文件别名对应的文件号—amdu恢复
联系：手机(13429648788) QQ(107644445)标题：kfed找出来asm 磁盘组中数据文件别名对应的文件号—amdu恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]前段时间有多个朋友问我,在amdu中,如果数据文件命名不是omf的方式,该如何找出来数据文件的asm file_number,从而实现通过amdu对不能mount的磁盘组中的数据文件进行恢复,这里通过测试给出来处理方法.根据我们对asm的理解,asm file_number 6为asm file的别名文件记录所在地,我们通过分析kfed这些au中的记录即可获得相关数据文件的别名对应的asm文件号模拟各种别名D:\app\product\10.2.0\db_1\bin>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on 星期三 7月 27 22:48:48 2016
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the P
...继续阅读
(72)
发表于
2016-07-29 04:26:19
mount数据库也可能有LOCAL=NO的进程
联系：手机(13429648788) QQ(107644445)标题：mount数据库也可能有LOCAL=NO的进程作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在一次无意中发现mount状态的数据库也有LOCAL=NO的进程,经过分析确定是由于主库连接到备库的nls或者arch进程连接到备库引起的发现mount库中有LOCAL=NO的进程[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jul 29 11:59:57 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select database_role ,open_mode from v$database;
D
...继续阅读
(81)
发表于
2016-07-28 12:04:31
_OFFLINE_ROLLBACK_SEGMENTS/_CORRUPTED_ROLLBACK_SEGMENTS
发表于
2016-07-28 03:11:40
oracle asm系列文章汇总
联系：手机(13429648788) QQ(107644445)标题：oracle asm系列文章汇总作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]为了方便大家更容易的查看相关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恢复—ASM恢复案例通过ftp/http拷贝asm中文件ASM DISK HEADER 备份与恢复手工修复ASM DISK HEADER 异常asm disk header 彻底损坏恢复—ASM恢复案例ASM未正常启动,使用dd找回数据文件asm disk被
...继续阅读
(74)
发表于
2016-07-27 13:06:32
ORA-600 4193 错误说明和解决
联系：手机(13429648788) QQ(107644445)标题：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 seq number
Arg [b] Redo record
...继续阅读
(122)
发表于
2016-07-26 12:20:14
How to resolve ORA-600 [4194] errors
联系：手机(13429648788) QQ(107644445)标题：How to resolve ORA-600 [4194] errors作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在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 reported when the
...继续阅读
(55)