首页 > 数据库 >难见的oracle 9i恢复---2023年---惜分飞

难见的oracle 9i恢复---2023年---惜分飞

时间：2023-05-15 22:34:01浏览次数：60  
标签：9i 15 May 09 分飞 --- Mon 2023 ORA

联系：手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题：难见的oracle 9i恢复—2023年

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

时过境迁,以前恢复大量oracle 8/9版本的库,现在一套oracle 9i的库都比较稀奇了.今天恢复客户一套9.2.0.6的aix环境rac库,通过分析确认主要问题:
1. 重建控制文件，resetlogs库遗漏数据文件
missing_dbf

2. 数据库启动主要报错ORA-600 2663和ORA-600 kclchkblk_4

 

Tue Nov  8 09:10:05 2022 Successfully onlined Undo Tablespace 1. Dictionary check beginning Tablespace 'TEMP' #2 found in data dictionary, but not in the controlfile. Adding to controlfile. File #84 found in data dictionary but not in controlfile. Creating OFFLINE file 'MISSING00084' in the controlfile. This file can no longer be recovered so it must be dropped. Dictionary check complete Tue Nov  8 09:10:05 2022 SMON: enabling tx recovery Tue Nov  8 09:10:05 2022 Database Characterset is ZHS16GBK Tue Nov  8 09:10:05 2022 Errors in file /u01/prod/proddb/9.2.0/admin/udump/prod1_ora_536662.trc: ORA-00600: internal error code, arguments: [2663], [3301], [2638369768], [3301], [2640322622], [], [], [] Tue Nov  8 09:10:06 2022 Errors in file /u01/prod/proddb/9.2.0/admin/bdump/prod1_smon_647352.trc: ORA-00600: internal error code, arguments: [kclchkblk_4], [3301], [18446744072061740072],[3301],[18446744072052954088] Tue Nov  8 09:10:06 2022 Errors in file /u01/prod/proddb/9.2.0/admin/udump/prod1_ora_536662.trc: ORA-00600: internal error code, arguments: [2663], [3301], [2638369768], [3301], [2640322622], [], [], [] Error 600 happened during db open, shutting down database USER: terminating instance due to error 600 Instance terminated by USER, pid = 536662 ORA-1092 signalled during: alter database open...

根据客户文件名称的规则,推算出来84号文件实际的文件名(因为使用的是lv[aix的hacmp管理的lv的裸设备方式]),通过dbv确认文件无坏块

DBVERIFY: Release 9.2.0.6.0 - Production on Sat May 13 16:44:09 2023   Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   DBVERIFY - Verification starting : FILE = /dev/ra_txn_ind12.dbf     DBVERIFY - Verification complete   Total Pages Examined         : 256000 Total Pages Processed (Data) : 0 Total Pages Failing   (Data) : 0 Total Pages Processed (Index): 299 Total Pages Failing   (Index): 0 Total Pages Processed (Other): 13 Total Pages Processed (Seg)  : 0 Total Pages Failing   (Seg)  : 0 Total Pages Empty            : 255688 Total Pages Marked Corrupt   : 0 Total Pages Influx           : 0 Highest block SCN            : 11177081099136 (2602.1576194944)

bbed验证文件该文件是否是84号文件

$ bbed blocksize=8192 filename='/dev/ra_txn_ind12.dbf'   Password:   BBED: Release 2.0.0.0.0 - Limited Production on Mon May 15 09:45:44 2023   Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   ************* !!! For Oracle Internal Use only !!! ***************   BBED> map  File: /dev/ra_txn_ind12.dbf (0)  Block: 1                                     Dba:0x00000000 ------------------------------------------------------------  Data File Header    struct kcvfh, 608 bytes                    @0          ub4 tailchk                                @8188        BBED> p kcvfh struct kcvfh, 608 bytes                     @0          struct kcvfhbfh, 20 bytes                @0             ub1 type_kcbh                         @0        0x0b       ub1 frmt_kcbh                         @1        0x02       ub1 spare1_kcbh                       @2        0x00       ub1 spare2_kcbh                       @3        0x00       ub4 rdba_kcbh                         @4        0x15000001       ub4 bas_kcbh                          @8        0x00000000       ub2 wrp_kcbh                          @12       0x0000       ub1 seq_kcbh                          @14       0x01       ub1 flg_kcbh                          @15       0x04 (KCBHFCKV)       ub2 chkval_kcbh                       @16       0x1b4a       ub2 spare3_kcbh                       @18       0x0000    struct kcvfhhdr, 76 bytes                @20            ub4 kccfhswv                          @20       0x09200000       ub4 kccfhcvn                          @24       0x08000000       ub4 kccfhdbi                          @28       0x05d15ccf       ……       ub4 kccfhcsq                          @40       0x00525a20       ub4 kccfhfsz                          @44       0x0003e800       s_blkz kccfhbsz                       @48       0x00       ub2 kccfhfno                          @52       0x0054       ub2 kccfhtyp                          @54       0x0003    ……    ub4 kcvfhrfn                             @528      0x00000054  ---确认是84号文件   ……

通过bbed修改文件相关信息,然后尝试rename文件,但是recover datafile 84报错

Mon May 15 09:49:44 2023 alter database rename file '/u01/prod/proddb/9.2.0/dbs/MISSING00084' to '/dev/ra_txn_ind12.dbf' Mon May 15 09:49:44 2023 Completed: alter database rename file '/u01/prod/proddb/9.2.0 Mon May 15 09:51:15 2023 ALTER DATABASE RECOVER  datafile 84  Media Recovery Start Mon May 15 09:51:15 2023 Errors in file /u01/prod/proddb/9.2.0/admin/udump/prod1_ora_467190.trc: ORA-07445: exception encountered: core dump [] [] [] [] [] []

通过处理之后,数据库recover 正常,但是open报ORA-600 4193错误

Mon May 15 09:57:53 2023 ALTER DATABASE RECOVER  DATABASE  Media Recovery Start Mon May 15 09:57:53 2023 Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0   Mem# 0 errs 0: /dev/rlog01a.dbf   Mem# 1 errs 0: /dev/rlog01b.dbf Media Recovery Complete Completed: ALTER DATABASE RECOVER  DATABASE  Mon May 15 09:59:24 2023 alter database open Mon May 15 09:59:24 2023 Beginning crash recovery of 1 threads Mon May 15 09:59:24 2023 Started redo scan Mon May 15 09:59:24 2023 Completed redo scan  75 redo blocks read, 0 data blocks need recovery Mon May 15 09:59:24 2023 Started recovery at  Thread 1: logseq 4, block 2, scn 3301.2638369687 Mon May 15 09:59:24 2023 Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0   Mem# 0 errs 0: /dev/rlog01a.dbf   Mem# 1 errs 0: /dev/rlog01b.dbf Mon May 15 09:59:24 2023 Completed redo application Mon May 15 09:59:24 2023 Ended recovery at  Thread 1: logseq 4, block 77, scn 3301.2638389765  0 data blocks read, 0 data blocks written, 75 redo blocks read Crash recovery completed successfully Mon May 15 09:59:25 2023 Thread 1 advanced to log sequence 5 Thread 1 opened at log sequence 5   Current log# 2 seq# 5 mem# 0: /dev/rlog02a.dbf   Current log# 2 seq# 5 mem# 1: /dev/rlog02b.dbf Successful open of redo thread 1 Mon May 15 09:59:25 2023 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon May 15 09:59:25 2023 SMON: enabling cache recovery Mon May 15 09:59:25 2023 ARC0: Media recovery disabled Mon May 15 09:59:25 2023 Successfully onlined Undo Tablespace 1. Dictionary check beginning Tablespace 'TEMP' #2 found in data dictionary, but not in the controlfile. Adding to controlfile. Dictionary check complete Mon May 15 09:59:25 2023 SMON: enabling tx recovery Mon May 15 09:59:25 2023 Database Characterset is ZHS16GBK Mon May 15 09:59:25 2023 Errors in file /u01/prod/proddb/9.2.0/admin/bdump/prod1_smon_413872.trc: ORA-00600: internal error code, arguments: [4193], [781], [6399], [], [], [], [], [] Mon May 15 09:59:25 2023 Errors in file /u01/prod/proddb/9.2.0/admin/udump/prod1_ora_844004.trc: ORA-00600: internal error code, arguments: [4193], [56042], [1895], [], [], [], [], [] Mon May 15 09:59:26 2023 Doing block recovery for fno: 12 blk: 153 Mon May 15 09:59:26 2023 Doing block recovery for fno: 12 blk: 2893 Mon May 15 09:59:26 2023 Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0   Mem# 0 errs 0: /dev/rlog02a.dbf Mon May 15 09:59:26 2023 Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0 Mon May 15 09:59:26 2023   Mem# 1 errs 0: /dev/rlog02b.dbf Mon May 15 09:59:26 2023   Mem# 0 errs 0: /dev/rlog02a.dbf   Mem# 1 errs 0: /dev/rlog02b.dbf Doing block recovery for fno: 12 blk: 3009 Mon May 15 09:59:26 2023 Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0   Mem# 0 errs 0: /dev/rlog02a.dbf   Mem# 1 errs 0: /dev/rlog02b.dbf Mon May 15 09:59:26 2023 Doing block recovery for fno: 12 blk: 89 Mon May 15 09:59:26 2023 Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0   Mem# 0 errs 0: /dev/rlog02a.dbf   Mem# 1 errs 0: /dev/rlog02b.dbf Mon May 15 09:59:26 2023 Errors in file /u01/prod/proddb/9.2.0/admin/udump/prod1_ora_844004.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4193], [56042], [1895], [], [], [], [], [] Error 607 happened during db open, shutting down database USER: terminating instance due to error 607 Instance terminated by USER, pid = 844004 ORA-1092 signalled during: alter database open...

绕过该错误之后,数据库启动报ORA-600 2662错误

$ sqlplus "/ as sysdba"   SQL*Plus: Release 9.2.0.6.0 - Production on Mon May 15 10:04:44 2023   Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   Connected to an idle instance.   SQL> startup mount pfile='/tmp/pfile' ORACLE instance started.   Total System Global Area 1102023336 bytes Fixed Size                   744104 bytes Variable Size             922746880 bytes Database Buffers          167772160 bytes Redo Buffers               10760192 bytes Database mounted. SQL> alter database open; alter database open * ERROR at line 1: ORA-03113: end-of-file on communication channel
Mon May 15 10:05:03 2023 SMON: enabling cache recovery Mon May 15 10:05:03 2023 ARC0: Media recovery disabled Mon May 15 10:05:03 2023 SMON: enabling tx recovery Mon May 15 10:05:03 2023 Database Characterset is ZHS16GBK Mon May 15 10:05:03 2023 Errors in file /u01/prod/proddb/9.2.0/admin/bdump/prod1_smon_413880.trc: ORA-00600: internal error code, arguments: [2662], [3301], [2638409995], [3301], [2644132966], [4195678] Mon May 15 10:05:04 2023 Non-fatal internal error happenned while SMON was doing temporary segment drop. SMON encountered 1 out of maximum 100 non-fatal internal errors. Mon May 15 10:05:04 2023 Errors in file /u01/prod/proddb/9.2.0/admin/bdump/prod1_smon_413880.trc: ORA-00600: internal error code, arguments: [2662], [3301], [2638409998], [3301], [2644132966], [4195678] Mon May 15 10:05:04 2023 Errors in file /u01/prod/proddb/9.2.0/admin/bdump/prod1_smon_413880.trc: ORA-00600: internal error code, arguments: [2662], [3301], [2638409998], [3301], [2644132966], [4195678] SMON: terminating instance due to error 600 Instance terminated by SMON, pid = 413880

解决该错误之后,数据库open正常

$ sqlplus "/ as sysdba"   SQL*Plus: Release 9.2.0.6.0 - Production on Mon May 15 10:10:30 2023   Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   Connected to an idle instance.   SQL> startup mount pfile='/tmp/pfile' ORACLE instance started.   Total System Global Area 1102023336 bytes Fixed Size                   744104 bytes Variable Size             922746880 bytes Database Buffers          167772160 bytes Redo Buffers               10760192 bytes Database mounted. SQL> alter database open;   Database altered.

逻辑方式导出数据,本次恢复任务基本完成.

标签：9i,15,May,09,分飞,---,Mon,2023,ORA
From： https://www.cnblogs.com/xifenfei/p/17403342.html

相关文章

  • Linux操作系统分析-课程总结
     结合虚拟化技术分析Linux系统的一般执行过程一、     Linux系统运行一般场景：用户进程之间切换                     （1）用户态进程X调用系统调用或触发异常用户态进程X需要进行进程切换时，可以通过调用一些特定的系统调用（例如fork、exec等）或者......
  • springboot(8)--定制服务
    springboot的服务配置除了application.properties，还可以通过implements WebServerFactoryCustomizer<T>定制服务，例如指定容器，端口，协议等等我们只要在继承类中添加自己的配置即可*@ClassnameTomcatServerConfiger*@CreatedbyMichael*@Date2023/5/15*@Descriptio......
  • Rockchip RK3399-官方固件方式加载uboot
    ----------------------------------------------------------------------------------------------------------------------------开发板 ：NanoPC-T4开发板eMMC  ：16GBLPDDR3：4GB显示屏 ：15.6英寸HDMI接口显示屏u-boot  ：2017.09---------------------------------------......
  • 深度学习---视觉领域分类
    深度学习在视觉领域分类一、图像分类图像分类是指将数字图像自动分类到不同的预先定义类别中。二、目标检测目标检测是指在图像或视频中自动识别和定位特定物体的任务。与图像分类不同，它不仅需要确定物体的类别，还需要找出物体在图像中的位置。按照框分类又可以分为平行框检......
  • 【Azure Redis 缓存】使用开源工具redis-copy时遇见6379端口无法连接到Redis服务器的
    问题描述当使用AzureRedis服务时，需要把一个Redis服务的数据导入到另一个Redis上，因为Redis服务没有使用高级版，所以不支持直接导入/导出RDB文件。以编程方式来读取数据并写入到新的Redis服务端，使用开源工具Redis-Copy却遇见了6379端口无法连接的问题。而用redis-cli.exe却......
  • Docker入门与实战-Docker镜像的使用
    Docker入门与实战二.Docker镜像的使用1.获取镜像​ 命令：docker[image]pullimage-name[:tag]​ 说明：​ name为镜像仓库名称,严格来说，该name应该由注册服务器地址+镜像仓库名称组成，这样做可以避免不同仓库(注册服务器)下的镜像名称冲突的问 题，如果该注册服务器地......
  • CF269D - Maximum Waterfall
    比较迷糊，比较乱搞。我们考虑从上往下进行\(dp\)，\(dp_i\)表示从顶上水槽\(i\)最多的流量。然后我们发现，每个高度，能用来进行转移的区间一定没有被完全覆盖。也就是，只有在遮挡关系中被覆盖的区间可能被用来转移。同时，每个区间还是有要求的，比如\([1,3]\)的\([2,3]\)部分后来......
  • SQL--每日两道sql题，天天健康好身体
    每天会在网上找两三道sql题练习练习，提高自己的sql语句的使用能力（先自己思考出答案，再和别人的答案做一下对比，然后深入思考一下）以下是四个表信息： 问题1、查询所有同学的学号，姓名，选课数，总成绩答案1：selectsid,sname,table2.zongchengji,table2.xuankeshufromstudent_info_t......
  • Intellij Idea教程_编程入门自学教程_菜鸟教程-免费教程分享
    教程简介IDEA全称IntelliJIDEA，是java编程语言的集成开发环境。IntelliJ在业界被公认为最好的Java开发工具，尤其在智能代码助手、代码自动提示、重构、JavaEE支持、各类版本工具(git、svn等)、JUnit、CVS整合、代码分析、创新的GUI设计等方面的功能可以说是超常的。IDEA是JetBra......
  • ALO蚁狮优化算法优化KELM核极限学习机（ALO-KELM）回归预测MATLAB代码 代码注释清楚。
    ALO蚁狮优化算法优化KELM核极限学习机（ALO-KELM）回归预测MATLAB代码代码注释清楚。main为主程序，可以读取EXCEL数据。很方便，容易上手。（电厂运行数据为例）温馨提示：联系请考虑是否需要，程序代码商品，一经售出，概不退换。ID:6145665078586548......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99