标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (100)
- 数据库 (1,589)
- DB2 (22)
- MySQL (70)
- Oracle (1,459)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (526)
- Oracle安装升级 (83)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (13)
- PostgreSQL恢复 (3)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
- Oracle 19C 备库DML重定向—DML Redirection
- ORA-01595/ORA-600 4194处理
- 从ORA-00283 ORA-16433报错开始恢复
- 近期又遇到ORA-600 16703和ORA-702故障
- RECOVER_YOUR_DATA勒索恢复
- ORA-01033: ORACLE initialization or shutdown in progress 故障处理
- Oracle 19c/21c最新patch信息-202401
- 存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理
- ORA-600 kcrf_resilver_log_1故障处理
月归档:二月 2019
redhat 7安装Oracle缺少compat-libstdc++
在redhat 7版本中compat-libstdc++-33-3.2.3包被从ISO文件中移除,但是12c及其以后版本安装均需要该包,导致数据库在安装的时候检查无法通过
redhat 7光盘中无compat-libstdc包
[oracle@localhost media]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/rhel-root 90G 15G 76G 17% / devtmpfs 7.8G 0 7.8G 0% /dev tmpfs 7.8G 0 7.8G 0% /dev/shm tmpfs 7.8G 12M 7.8G 1% /run tmpfs 7.8G 0 7.8G 0% /sys/fs/cgroup /dev/sda1 1014M 146M 869M 15% /boot /dev/mapper/rhel-home 1014M 33M 982M 4% /home tmpfs 1.6G 0 1.6G 0% /run/user/0 /dev/sr0 4.2G 4.2G 0 100% /media [oracle@localhost media]$ cd /media/ [oracle@localhost media]$ ls -l total 962 dr-xr-xr-x. 4 root root 2048 Oct 10 14:34 addons dr-xr-xr-x. 3 root root 2048 Oct 10 14:34 EFI -r--r--r--. 1 root root 8266 Apr 4 2014 EULA -r--r--r--. 1 root root 1455 Oct 10 14:02 extra_files.json -r--r--r--. 1 root root 18092 Mar 6 2012 GPL dr-xr-xr-x. 3 root root 2048 Oct 10 14:34 images dr-xr-xr-x. 2 root root 2048 Oct 10 14:34 isolinux dr-xr-xr-x. 2 root root 2048 Oct 10 14:34 LiveOS -r--r--r--. 1 root root 114 Oct 10 14:09 media.repo dr-xr-xr-x. 2 root root 931840 Oct 10 14:34 Packages dr-xr-xr-x. 2 root root 4096 Oct 10 14:34 repodata -r--r--r--. 1 root root 3375 Sep 21 10:59 RPM-GPG-KEY-redhat-beta -r--r--r--. 1 root root 3211 Sep 21 10:59 RPM-GPG-KEY-redhat-release -r--r--r--. 1 root root 1796 Oct 10 14:34 TRANS.TBL [oracle@localhost media]$ cat media.repo [InstallMedia] name=Red Hat Enterprise Linux 7.6 mediaid=1539194970.388895 metadata_expire=-1 gpgcheck=0 cost=500 [oracle@localhost media]$ cd Packages/ [oracle@localhost Packages]$ ls -l |grep compat-libstdc [oracle@localhost Packages]$
通过mos相关描述,该包主要是影响数据库的Oracle Text中的相关功能,如果不使用该功能,可以通过忽略该包继续安装,如果需要使用该功能,可以通过下载compat-libstdc来安装.
参考文档:Missing or Ignored package compat-libstdc++-33-3.2.3 causes Text Issues (Doc ID 2254198.1)
Installation of 12.1.0.2 Oracle Database Server/Client on RHEL 7/OL7 reports pre-requisite package ‘compat-libstdc++’ missing. (Doc ID 2062336.1)
一般来说,在linux 7系统中如果需要可以下载使用rpm 命令进行安装compat-libstdc++-33
Oracle 19C 依旧支持bbed
Oracle 19c
SQL> select BANNER from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/ORA19C/system01.dbf /u01/app/oracle/oradata/ORA19C/sysaux01.dbf /u01/app/oracle/oradata/ORA19C/undotbs01.dbf /u01/app/oracle/oradata/ORA19C/pdbseed/system01.dbf /u01/app/oracle/oradata/ORA19C/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/ORA19C/users01.dbf /u01/app/oracle/oradata/ORA19C/pdbseed/undotbs01.dbf /u01/app/oracle/oradata/ORA19C/pdb/system01.dbf /u01/app/oracle/oradata/ORA19C/pdb/sysaux01.dbf /u01/app/oracle/oradata/ORA19C/pdb/undotbs01.dbf /u01/app/oracle/oradata/ORA19C/pdb/users01.dbf
bbed查看文件头
[oracle@localhost db_1]$ bbed Password: BBED: Release 2.0.0.0.0 - Limited Production on Thu Feb 28 15:39:02 2019 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> BBED> BBED> set filename '/u01/app/oracle/oradata/ORA19C/system01.dbf' FILENAME /u01/app/oracle/oradata/ORA19C/system01.dbf BBED> set blocksize 8192 BLOCKSIZE 8192 BBED> map File: /u01/app/oracle/oradata/ORA19C/system01.dbf (0) Block: 1 Dba:0x00000000 ------------------------------------------------------------ Data File Header struct kcvfh, 1272 bytes @0 ub4 tailchk @8188 BBED> p kcvfh struct kcvfh, 1272 bytes @0 struct kcvfhbfh, 20 bytes @0 ub1 type_kcbh @0 0x0b ub1 frmt_kcbh @1 0xa2 ub2 wrp2_kcbh @2 0x0000 ub4 rdba_kcbh @4 0x00400001 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 0x6896 ub2 spare3_kcbh @18 0x0000 struct kcvfhhdr, 76 bytes @20 ub4 kccfhswv @20 0x00000000 ub4 kccfhcvn @24 0x13000000 ub4 kccfhdbi @28 0x3edc1c96 text kccfhdbn[0] @32 O text kccfhdbn[1] @33 R text kccfhdbn[2] @34 A text kccfhdbn[3] @35 1 text kccfhdbn[4] @36 9 text kccfhdbn[5] @37 C text kccfhdbn[6] @38 text kccfhdbn[7] @39 ub4 kccfhcsq @40 0x0000040f ub4 kccfhfsz @44 0x0001bd00 s_blkz kccfhbsz @48 0x00 ub2 kccfhfno @52 0x0001 ub2 kccfhtyp @54 0x0003 ub4 kccfhacid @56 0x00000000 ub4 kccfhcks @60 0x00000000 text kccfhtag[0] @64 text kccfhtag[1] @65 text kccfhtag[2] @66 text kccfhtag[3] @67 text kccfhtag[4] @68 text kccfhtag[5] @69 text kccfhtag[6] @70 text kccfhtag[7] @71 text kccfhtag[8] @72 text kccfhtag[9] @73 text kccfhtag[10] @74 text kccfhtag[11] @75 text kccfhtag[12] @76 text kccfhtag[13] @77 text kccfhtag[14] @78 text kccfhtag[15] @79 text kccfhtag[16] @80 text kccfhtag[17] @81 text kccfhtag[18] @82 text kccfhtag[19] @83 text kccfhtag[20] @84 text kccfhtag[21] @85 text kccfhtag[22] @86 text kccfhtag[23] @87 text kccfhtag[24] @88 text kccfhtag[25] @89 text kccfhtag[26] @90 text kccfhtag[27] @91 text kccfhtag[28] @92 text kccfhtag[29] @93 text kccfhtag[30] @94 text kccfhtag[31] @95 ub4 kcvfhrdb @96 0x00400208 struct kcvfhcrs, 8 bytes @100 ub4 kscnbas @100 0x00000008 ub2 kscnwrp @104 0x8000 ub2 kscnwrp2 @106 0x0000 ub4 kcvfhcrt @108 0x3b90f0c2 ub4 kcvfhrlc @112 0x3bb086d8 struct kcvfhrls, 8 bytes @116 ub4 kscnbas @116 0x001cb1dd ub2 kscnwrp @120 0x8000 ub2 kscnwrp2 @122 0x0000 ub4 kcvfhbti @124 0x00000000 struct kcvfhbsc, 8 bytes @128 ub4 kscnbas @128 0x00000000 ub2 kscnwrp @132 0x0000 ub2 kscnwrp2 @134 0x0000 ub2 kcvfhbth @136 0x0000 ub2 kcvfhsta @138 0x2004 (KCVFHOFZ) struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 ub4 kscnbas @484 0x001d44f9 ub2 kscnwrp @488 0x8000 ub2 kscnwrp2 @490 0x0000 ub4 kcvcptim @492 0x3bb08892 ub2 kcvcpthr @496 0x0001 union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x00000002 ub4 kcrbabno @504 0x000143d1 ub2 kcrbabof @508 0x0010 ub1 kcvcpetb[0] @512 0x02 ub1 kcvcpetb[1] @513 0x00 ub1 kcvcpetb[2] @514 0x00 ub1 kcvcpetb[3] @515 0x00 ub1 kcvcpetb[4] @516 0x00 ub1 kcvcpetb[5] @517 0x00 ub1 kcvcpetb[6] @518 0x00 ub1 kcvcpetb[7] @519 0x00 ub4 kcvfhcpc @140 0x00000032 ub4 kcvfhrts @144 0x3bb08686 ub4 kcvfhccc @148 0x00000031 struct kcvfhbcp, 36 bytes @152 struct kcvcpscn, 8 bytes @152 ub4 kscnbas @152 0x00000000 ub2 kscnwrp @156 0x0000 ub2 kscnwrp2 @158 0x0000 ub4 kcvcptim @160 0x00000000 ub2 kcvcpthr @164 0x0000 union u, 12 bytes @168 struct kcvcprba, 12 bytes @168 ub4 kcrbaseq @168 0x00000000 ub4 kcrbabno @172 0x00000000 ub2 kcrbabof @176 0x0000 ub1 kcvcpetb[0] @180 0x00 ub1 kcvcpetb[1] @181 0x00 ub1 kcvcpetb[2] @182 0x00 ub1 kcvcpetb[3] @183 0x00 ub1 kcvcpetb[4] @184 0x00 ub1 kcvcpetb[5] @185 0x00 ub1 kcvcpetb[6] @186 0x00 ub1 kcvcpetb[7] @187 0x00 ub4 kcvfhbhz @312 0x00000000 struct kcvfhxcd, 16 bytes @316 ub4 space_kcvmxcd[0] @316 0x00000000 ub4 space_kcvmxcd[1] @320 0x00000000 ub4 space_kcvmxcd[2] @324 0x00000000 ub4 space_kcvmxcd[3] @328 0x00000000 sword kcvfhtsn @332 0 ub2 kcvfhtln @336 0x0006 text kcvfhtnm[0] @338 S text kcvfhtnm[1] @339 Y text kcvfhtnm[2] @340 S text kcvfhtnm[3] @341 T text kcvfhtnm[4] @342 E text kcvfhtnm[5] @343 M text kcvfhtnm[6] @344 text kcvfhtnm[7] @345 text kcvfhtnm[8] @346 text kcvfhtnm[9] @347 text kcvfhtnm[10] @348 text kcvfhtnm[11] @349 text kcvfhtnm[12] @350 text kcvfhtnm[13] @351 text kcvfhtnm[14] @352 text kcvfhtnm[15] @353 text kcvfhtnm[16] @354 text kcvfhtnm[17] @355 text kcvfhtnm[18] @356 text kcvfhtnm[19] @357 text kcvfhtnm[20] @358 text kcvfhtnm[21] @359 text kcvfhtnm[22] @360 text kcvfhtnm[23] @361 text kcvfhtnm[24] @362 text kcvfhtnm[25] @363 text kcvfhtnm[26] @364 text kcvfhtnm[27] @365 text kcvfhtnm[28] @366 text kcvfhtnm[29] @367 ub4 kcvfhrfn @368 0x00000001 struct kcvfhrfs, 8 bytes @372 ub4 kscnbas @372 0x00000000 ub2 kscnwrp @376 0x0000 ub2 kscnwrp2 @378 0x0000 ub4 kcvfhrft @380 0x00000000 struct kcvfhafs, 8 bytes @384 ub4 kscnbas @384 0x00000000 ub2 kscnwrp @388 0x0000 ub2 kscnwrp2 @390 0x0000 ub4 kcvfhbbc @392 0x00000000 ub4 kcvfhncb @396 0x00000000 ub4 kcvfhmcb @400 0x00000000 ub4 kcvfhlcb @404 0x00000000 ub4 kcvfhbcs @408 0x00000000 ub2 kcvfhofb @412 0x000a ub2 kcvfhnfb @414 0x000a ub4 kcvfhprc @416 0x3b90f0b9 struct kcvfhprs, 8 bytes @420 ub4 kscnbas @420 0x00000001 ub2 kscnwrp @424 0x0000 ub2 kscnwrp2 @426 0x0000 struct kcvfhprfs, 8 bytes @428 ub4 kscnbas @428 0x00000000 ub2 kscnwrp @432 0x0000 ub2 kscnwrp2 @434 0x0000 ub4 kcvfhtrt @444 0x00000000
由于scn做了调整,能够支持更大的scn值,因此在19C的bbed中明显能够看到kscnwrp2
ORA-600 kcbzib_kcrsds_1报错
数据库版本
客户存储故障,修复之后,多套库增加_allow_resetlogs_corruption隐含参数强制拉库出现都类似错误ORA-600 kcbzib_kcrsds_1,出现这个错误,一般都是由于数据库不一致强制拉库导致
2019-02-23T01:25:43.125621+08:00 alter database open resetlogs 2019-02-23T01:25:43.231990+08:00 RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 149251865354 time Clearing online redo logfile 1 +DG_XFF/xifenfei/ONLINELOG/group_1.258.983824407 Clearing online redo logfile 2 +DG_XFF/xifenfei/ONLINELOG/group_2.259.983824409 Clearing online redo logfile 3 +DG_XFF/xifenfei/ONLINELOG/group_3.266.983825461 Clearing online redo logfile 4 +DG_XFF/xifenfei/ONLINELOG/group_4.267.983825461 Clearing online log 1 of thread 1 sequence number 20749 Clearing online log 2 of thread 1 sequence number 20750 Clearing online log 3 of thread 2 sequence number 1371 Clearing online log 4 of thread 2 sequence number 1372 2019-02-23T01:25:44.669890+08:00 ALTER SYSTEM SET remote_listener=' xifenfeidb-cluster-scan:1521' SCOPE=MEMORY SID='xifenfei2'; 2019-02-23T01:25:44.671436+08:00 ALTER SYSTEM SET listener_networks='' SCOPE=MEMORY SID='xifenfei2'; 2019-02-23T01:25:46.990077+08:00 Clearing online redo logfile 1 complete Clearing online redo logfile 2 complete Clearing online redo logfile 3 complete Clearing online redo logfile 4 complete Resetting resetlogs activation ID 3002369299 (0xb2f48513) Online log +DG_XFF/xifenfei/ONLINELOG/group_1.258.983824407: Thread 1 Group 1 was previously cleared Online log +DG_XFF/xifenfei/ONLINELOG/group_2.259.983824409: Thread 1 Group 2 was previously cleared Online log +DG_XFF/xifenfei/ONLINELOG/group_3.266.983825461: Thread 2 Group 3 was previously cleared Online log +DG_XFF/xifenfei/ONLINELOG/group_4.267.983825461: Thread 2 Group 4 was previously cleared 2019-02-23T01:25:47.137701+08:00 Setting recovery target incarnation to 2 2019-02-23T01:25:47.152393+08:00 This instance was first to open Ping without log force is disabled: not an Exadata system. Picked broadcast on commit scheme to generate SCNs Endian type of dictionary set to little 2019-02-23T01:25:47.597502+08:00 Assigning activation ID 3019587675 (0xb3fb405b) 2019-02-23T01:25:47.625734+08:00 TT00: Gap Manager starting (PID:22467) 2019-02-23T01:25:47.910026+08:00 Thread 2 opened at log sequence 1 Current log# 3 seq# 1 mem# 0: +DG_XFF/xifenfei/ONLINELOG/group_3.266.983825461 Successful open of redo thread 2 2019-02-23T01:25:47.911069+08:00 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set 2019-02-23T01:25:47.971709+08:00 Sleep 5 seconds and then try to clear SRLs in 2 time(s) 2019-02-23T01:25:48.065008+08:00 start recovery: pdb 0, passed in flags x10 (domain enable 0) 2019-02-23T01:25:48.065177+08:00 Instance recovery: looking for dead threads Instance recovery: lock domain invalid but no dead threads validate pdb 0, flags x10, valid 0, pdb flags x84 * validated domain 0, flags = 0x80 Instance recovery complete: valid 1 (flags x10, recovery domain flags x80) 2019-02-23T01:25:48.803746+08:00 Errors in file /oracle/base/oracle/diag/rdbms/xifenfei/xifenfei2/trace/xifenfei2_ora_21292.trc (incident=128552): ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2019-02-23T01:25:49.947062+08:00 ***************************************************************** An internal routine has requested a dump of selected redo. This usually happens following a specific internal error, when analysis of the redo logs will help Oracle Support with the diagnosis. It is recommended that you retain all the redo logs generated (by all the instances) during the past 12 hours, in case additional redo dumps are required to help with the diagnosis. ***************************************************************** 2019-02-23T01:25:50.334684+08:00 Errors in file /oracle/base/oracle/diag/rdbms/xifenfei/xifenfei2/trace/xifenfei2_ora_21292.trc: ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], [] 2019-02-23T01:25:50.334880+08:00 Errors in file /oracle/base/oracle/diag/rdbms/xifenfei/xifenfei2/trace/xifenfei2_ora_21292.trc: ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], [] Error 600 happened during db open, shutting down database 2019-02-23T01:25:50.362808+08:00 Errors in file /oracle/base/oracle/diag/rdbms/xifenfei/xifenfei2/trace/xifenfei2_ora_21292.trc (incident=128553): ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], [] 2019-02-23T01:25:51.521133+08:00 opiodr aborting process unknown ospid (21292) as a result of ORA-603
另外出现该错误之后,数据库再次恢复会出现类似,这个是由于open库的过程中导致文件损坏而出现的错误.
2019-02-23T22:52:39.390966+08:00 ALTER DATABASE RECOVER database 2019-02-23T22:52:39.391125+08:00 Media Recovery Start Started logmerger process 2019-02-23T22:52:39.471904+08:00 Media Recovery failed with error 16433 2019-02-23T22:52:39.996235+08:00 Errors in file /oracle/base/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_m000_1593.trc: ORA-01110: data file 11: '+DG_XFF/xifenfei/DATAFILE/ls_zh.274.984235699' 2019-02-23T22:52:40.224440+08:00 Errors in file /oracle/base/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_m000_1593.trc: ORA-01110: data file 12: '+DG_XFF/xifenfei/DATAFILE/sf_zh.275.984235715' 2019-02-23T22:52:40.459606+08:00 Errors in file /oracle/base/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_m000_1593.trc: ORA-01110: data file 13: '+DG_XFF/xifenfei/DATAFILE/tj_gl.276.984235729' 2019-02-23T22:52:40.574563+08:00 Recovery Slave PR00 previously exited with exception 283 ORA-283 signalled during: ALTER DATABASE RECOVER database ...