客户反映说一个库前几天因为磁盘损坏,导致操作系统宕机。几经折腾终于把盘恢复了,却又发现数据库无法启动了。并且已经使用trace里面的backup controlfile重建了控制文件,但还是无法正常启动。   检查之后

  首先来看一下故障发生的来龙去脉: 数据库版本:9.2.0.4 操作系统版本:5200-04 1、日志推进至95761,准备归档95760,未释放redo02.log Fri Feb 25 04:22:00 2011 Thread 1 advanced to log seq

alert.log内记录着: ==================== Mon May 17 11:15:49 2010 ALTER SYSTEM SET archive_lag_target=1800 SCOPE=MEMORY; 从归档日志的产生时间可以看出,归档能保证每30分钟切换一次。 到2010年5月24日,

dblink数据迁移时发生bug 环境.—————————– 主库hp ux 备库win 2003 在备库发起数据复制sp,通过属于备库的dblink,取远程主库的数据,插入到本地备

NLS (National Language Support) 1333333 OERI:84 on TO_DATE using ARABIC HIJRAH calendar 1531976 Bytes may be lost inserting multibyte data > 4k in length 1698153 Multibyte: CTA

Bugs fixed in the 9.0.1.1 Patch Set See Note:149018.1 for Support Status and Alerts affecting 9.0.1 releases. This Patch Set has been superceeded by the 9.0.1.4 Patch Set This note lists the bugs

Optimizer 1836101+ Memory Corruption from distributed query / query with binds (OERI:17114 / dump in kkecdn/kgh*/kke*) 1753899 DBMS_STATS can fail (ORA-904) for a table with a security

Bugs fixed in the 9.0.1.2 Patch Set See Note:149018.1 for Support Status and Alerts affecting 9.0.1 releases. This Patch Set has been superceeded by the 9.0.1.4 Patch Set This note lists the bugs

Parallel Query (PQO) 681179 Parallel TO_LOB(LONG) may dump 1020403 ORA-29900 possible from PQ using extensible ANCILLARY-PRIMARY operators 1685119 OERI:KCBLIBR_USER_FOU / hang whe

Bugs fixed in the 9.0.1.3 Patch Set See Note:149018.1 for Support Status and Alerts affecting 9.0.1 releases. This Patch Set has been superceeded by the 9.0.1.4 Patch Set This note lists the bugs

Direct Path operations 2424226 OERI:[ktspgfb-1] possible after direct load of bitmap managed segment Hash Join 2182779 Wrong results from HASH join when query has duplicate redunda

Bugs fixed in the 9.0.1.4 Patch Set See Note:149018.1 for Support Status and Alerts affecting 9.0.1 releases. This Patch Set has been superceeded by the 9.0.1.5 iAS Patch Set (for iAS Infrastructu

Optimizer 1946566 OERI:15160 possible from join of 5 or more table when CBO attempts STAR 2156913 Unique constraint SYS.I_MON_MODS$_OBJ violated gathering STALE statistics 2305613