Author: mac

  If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help. Parnassusdata Software Database Recovery Team Service Hotline:  +86 13764045638 E-mail: [email protected]   This document provides an explanation of error ORA-15196, including the details of each argument, suggestions for the diagnostic of the error and finally includes a case…

ORA-00600[4511]错误的触发条件是当ORACLE检验一个行锁并发现该锁不再活动时。 当然也可以由于一个数据块中存放了4095条以上的行时，一般仅仅当使用32kb数据块时可能包含这么多行， 针对这种情况的一种workaround是限制块中的数据行数，可以通过设置pctfree为一个较高值。 ORA-00600[4511]错误属于内核事务块处理，该错误可能造成进程失败或者可能的坏块 如果自己搞不定可以找ASKMACLEAN专业数据库修复团队成员帮您恢复!   如果用户已经了解到是那张表上存在可能引起ORA-00600[4511]错误的问题数据块，则可以通过执行ANALYZE TABLE <表名> VALIDATE STRUCTURE CASCADE;命令来检验是否存在潜在的问题。也可以用DBV工具来扫描表所在的数据文件。 这也可能是Consistent Read一致性读引起的该问题，那么alter system flush buffer_cache或者重启实例都可能可以绕过该问题。   ORA-00600[4511]相关的BUG 信息： 9724970 11.2.0.1.BP08, 11.2.0.2.2, 11.2.0.2.BP02, 11.2.0.3, 12.1.0.1 Block Corruption with PDML UPDATE. ORA_600 [4511] OERI[kdblkcheckerror] by block check 4000840 9.2.0.7, 10.1.0.4, 10.2.0.1 Update of a row with more than 255 columns can cause block corruption

在11.2.0.1版本之后用户可能偶尔遇到ORA-600 [KCRF_RESILVER_LOG_1]错误，其错误堆栈通常如下： 如果自己搞不定可以找ASKMACLEAN专业数据库修复团队成员帮您恢复!   —– Current SQL Statement for this session (sql_id=1h50ks4ncswfn) —– ALTER DATABASE OPEN —– Call Stack Trace —– kgeasnmierr kcrf_write_zeroblks kcrfis kcrfais kcrfr_read_disk kcrfr_read kcrfrgv kcratr_scan kcratr kctrec kcvcrv   ORA-00600[kcrf_resilver_log_1]可能导致OPEN DATABASE打开数据库失败，与未发布的ug 9056657: BOX REBOOT DURING UPGRADE CAUSED ORA-600 [KCRF_RESILVER_LOG_1]相关。 触发的原因为实例崩溃导致到在线重做日志online redo logfile的写丢失。由于该问题会导致前滚失败，一般只能restore数据库并恢复到存在问题点redo log之前的时间点。   建议优先收集如下信息：     set pagesize 20000 set…

ORA-600[4193]的成因与ORA-600[4194]类似， 是ORACLE发现redo重做记录与rollback/undo 回滚/撤销数据不匹配。 当进程在校验undo block中的undo block sequence number以及对应的redo block sequence number时发现不一致，则会报该错误。称为 ORA-600 [4193] “seq# mismatch while adding undo record”。     如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队 服务热线 ： 13764045638   QQ号:47079569    邮箱：[email protected]   ORA-600[4913]错误的2个argument的含义, 该ORA-600[4913]属于内核undo事务模块 [a] Undo record seq number [b] Redo record seq number   ORA-600[4913]相关的bug如下： 14034244 11.2.0.3.BP09,  12.1.0.0 Lost write type corruption using ASM in 11.2.0.3 8240762…

存在以下这种情况， 由于误DROP DISKGROUP或者误将DISK DROP 出原Diskgroup，或者因为Bug 13331814: ASM DISKS TURNED INTO FORMER WHILE DISKGROUP IS MOUNTED， 导致ASM DISK的header_status=FORMER，而非正常的MEMBER状态。   如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队 服务热线 ： 13764045638   QQ号:47079569    邮箱：[email protected]   举例来说如下面的例子     [oracle@mlab2 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 19 21:55:09 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected…

  ORA-600[2662]错误的触发原因是ORACLE发现居然有数据块的SCN号要比我系统当前的SCN还要大，这是不被允许的，这通常说明 在前滚过程中应用的redo是不完整的，这导致系统SCN要比一些已经写到磁盘上的块的SCN还小一点。对于这种问题常见的方案就是调整SCN adjust scn 《手动递增SCN号的几种方法：How to increase System Change Number by manual》     如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队 服务热线 ： 13764045638   QQ号:47079569    邮箱：[email protected]   与ORA-00600[2662]相关一些 bug如下：     Bug 4453449 Abstract: Flashback to guaranteed restore point in orphan inc may result in ORA-600[3020] Versions affected: 10.2.0.1 Fixed in versions: 10.2.0.2 & 11.0 Backportable: Yes Symptoms:…

.DUL(Database Un-Loader)의 특징!   1)        최후의 recovery utility이다. 2) 공식 지원 utility가  아니다. datafile이 있어야 만 한다. Ex)tablespace drop후 backup이 없는 상태에서 아직 unix rm 명령어를 적용하여 removed되지 않은 상태에  유용함. sql*loader의 *.ctl,*.dat형태의 file을 제공한다. 일부 column에 제한이 있다.(long raw datatype)     .TEST SCENARIO   먼저 dul directory를 만든다. $ cd $ORACLE_HOME $ mkdir…

dictv8.ddl does not unload the data dictionary! Check the database was migrated from Oracle7 to Oracle8. A sure sign of this is that the rfile# of the first system datafile is NOT 1 but 4 or 16. The solution requires DUL version 8.0.6.3 or higher. Starting from this version DUL has a special bootstrap command.…

The idea is to unload lobs just from the lob segment. We need to find out: 1. Is it a clob or a blob 2. for clobs the character set, single byte or UCS16, byte size 3. the chunk size, lob page# in the header is a fat page number 4. missing pages should be…

Situation A table was truncated, need to recover the data. The tablespace has three files, one datafile is missing from the backup and cannot be restored. DUL Background DUL can unload in several ways. It needs to know which blocks to read for a table. The default behaviour is to use the extent maps in the…