VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

CTAS导致严重BUG一则

Posted by admin on 25th September 2013

某国内巨头的一起CASE,在系统繁忙情况下大量的CTAS 导致数据字典表的不一致,由原来10.0.2.4版本升级到10.0.2.5之后问题依旧。
具体表现为:
1. 尝试drop这些不一致的tablespace

15:00:18 SQL> @dropts_2012.0319.150[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

11.2.0.2 EXPDP 遭遇 ORA-4031

Posted by admin on 16th July 2012

一套oracle 11.2.0.2 数据仓库系统使用expdp导出数据时 进程hang 死 使用kill -9命令杀掉之后 database一直没有释放latch 通过下面的日志可以发现 pmon已经发现 ospid=15038的process dead 但是无法clean 进程在为 “fixed[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

ORA-16009 in alert log with standby and LGWR ASYNC

Posted by admin on 2nd December 2011

今天用10.2.0.1的一套物理DG 转 逻辑 standby 出现大量错误:

primary 端:

– Connected User is Valid
RFS[2]: Assigned to RFS process 30286
RFS[2]: Database moun[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »