原本oracle的话，字段不区分大小写，创建表后好像会自动转成大写；但如果创建时，使用了双引号，那么就会按照创建时的指定，严格区分大小写。像我这种情况，访问时，也需要使用双引号。前几天在某个oracle库上创建了几张表，程序运行时就报错了，提示ORA-00904。将SQL语句直接拿到PL/SQL上运行也报错。我想不出什么好办法，只能删掉重建，重建时将双引号去掉。原因出在创建表时使用的脚本上。该脚本如下，字段都使用了双引号。ORA-00904的意思就是找不到这个字段。 ...继续阅读 (1)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：删除asmlib磁盘导致磁盘组故障恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有客户执行drop disk磁盘组操作之后,然后立刻从oracle asmlib层面执行了oracleasm deletedisk,并且在操作系统层面delete partition(删除磁盘分区),导致磁盘组直接dismountTue Nov 26 16:44:04 2024 SQL> alter diskgroup data drop disk DATA_0008 NOTE: GroupBlock outside rolling migration privileged region Tue Nov 26 08:44:05 2024 NOTE: stopping process ARB0 NOTE: rebalance interrupted for group 2/0x28dec0d5 (DATA) NOTE: requesting all-instance membership refresh for group=2 NOTE: membership refresh pending for group 2/0x28dec0d5 (DATA) Tue Nov ...继续阅读 (4)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：删除asmlib磁盘导致磁盘组故障恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有客户执行drop disk磁盘组操作之后,然后立刻从oracle asmlib层面执行了oracleasm deletedisk,并且在操作系统层面delete partition(删除磁盘分区),导致磁盘组直接dismountTue Nov 26 16:44:04 2024 SQL> alter diskgroup data drop disk DATA_0008 NOTE: GroupBlock outside rolling migration privileged region Tue Nov 26 08:44:05 2024 NOTE: stopping process ARB0 NOTE: rebalance interrupted for group 2/0x28dec0d5 (DATA) NOTE: requesting all-instance membership refresh for group=2 NOTE: membership refresh pending for group 2/0x28dec0d5 (DATA) Tue Nov ...继续阅读 (5)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 krse_arc_complete.4作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]11.2.0.4版本数据库对于虚拟化环境中的备库进行克隆,然后尝试failover方式激活备库,结果遭遇ORA-600 krse_arc_complete.4错误SQL> ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE; ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE * ERROR at line 1: ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: '/u01/app/oracle/oradata/hisdb/system.256.975233377'alert日志显示Wed Oct 23 21:45:46 2024 ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY D ...继续阅读 (12)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 krse_arc_complete.4作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]11.2.0.4版本数据库对于虚拟化环境中的备库进行克隆,然后尝试failover方式激活备库,结果遭遇ORA-600 krse_arc_complete.4错误SQL> ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE; ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE * ERROR at line 1: ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: '/u01/app/oracle/oradata/hisdb/system.256.975233377'alert日志显示Wed Oct 23 21:45:46 2024 ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY D ...继续阅读 (10)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户虚拟化环境,由于断电,启动数据库报ORA-01157错误,通过操作系统层面查看,发现文件是存在的,但是dbv检测报不可访问感觉是文件系统损坏了,尝试把该文件拷贝到其他磁盘查看操作系统事件,确认是ntfs文件系统的MFT损坏基于这种情况,通过文件系统恢复工具进行恢复该文件尝试,提示恢复文件大小和实际元数据中记录大小不一致通过对比实际恢复大小和文件本身大小,发现7811899392-7791460352,几乎等于20M大小（也就是说恢复出来的数据文件少了20M）,通过分析数据库alert日志,确认该系统在前端时间刚好扩展了20M(增加数据文件之时指定了每次扩展20m)2023-08-11T11:29:21.397236+08:00 ALTER TABLESPACE "HSHIS" ADD DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\HIS\HSHIS01.DBF' SIZE 10M AUTOEXTEND ON NEXT 20M MAXSIZE 8001M Completed: ALTER TABLESPA ...继续阅读 (12)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户虚拟化环境,由于断电,启动数据库报ORA-01157错误,通过操作系统层面查看,发现文件是存在的,但是dbv检测报不可访问感觉是文件系统损坏了,尝试把该文件拷贝到其他磁盘查看操作系统事件,确认是ntfs文件系统的MFT损坏基于这种情况,通过文件系统恢复工具进行恢复该文件尝试,提示恢复文件大小和实际元数据中记录大小不一致通过对比实际恢复大小和文件本身大小,发现7811899392-7791460352,几乎等于20M大小（也就是说恢复出来的数据文件少了20M）,通过分析数据库alert日志,确认该系统在前端时间刚好扩展了20M(增加数据文件之时指定了每次扩展20m)2023-08-11T11:29:21.397236+08:00 ALTER TABLESPACE "HSHIS" ADD DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\HIS\HSHIS01.DBF' SIZE 10M AUTOEXTEND ON NEXT 20M MAXSIZE 8001M Completed: ALTER TABLESPA ...继续阅读 (17)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：清空redo,导致ORA-27048: skgfifi: file header information is invalid作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户由于空间不足,使用> redo命令清空了oracle的redo文件数据库挂掉之后,启动报错Fri Oct 04 10:32:57 2024 alter database open Beginning crash recovery of 1 threads parallel recovery started with 31 processes Started redo scan Errors in file /home/oracle/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_24876.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/xifenfei/redo03.log' ORA-27048: skgfifi ...继续阅读 (15)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：清空redo,导致ORA-27048: skgfifi: file header information is invalid作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户由于空间不足,使用> redo命令清空了oracle的redo文件数据库挂掉之后,启动报错Fri Oct 04 10:32:57 2024 alter database open Beginning crash recovery of 1 threads parallel recovery started with 31 processes Started redo scan Errors in file /home/oracle/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_24876.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/xifenfei/redo03.log' ORA-27048: skgfifi ...继续阅读 (14)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]12.1.0.2数据库由于异常断电，导致无法正常启动,通过alert日志对客户的整个操作过程进行分析(不含我的操作部分)通过alert日志分析最初故障原因是由于控制文件有坏块导致Tue Sep 24 11:49:48 2024 alter database open Tue Sep 24 11:49:48 2024 Ping without log force is disabled . Tue Sep 24 11:49:48 2024 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4715.trc: ORA-01113: file 10 needs media recovery ORA-01110: data file 10: '/u01/app/oracle/oradata/xifenfei.dbf' ORA-1113 signalled during: alter database open... alter database recover data ...继续阅读 (14)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]12.1.0.2数据库由于异常断电，导致无法正常启动,通过alert日志对客户的整个操作过程进行分析(不含我的操作部分)通过alert日志分析最初故障原因是由于控制文件有坏块导致Tue Sep 24 11:49:48 2024 alter database open Tue Sep 24 11:49:48 2024 Ping without log force is disabled . Tue Sep 24 11:49:48 2024 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4715.trc: ORA-01113: file 10 needs media recovery ORA-01110: data file 10: '/u01/app/oracle/oradata/xifenfei.dbf' ORA-1113 signalled during: alter database open... alter database recover data ...继续阅读 (21)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]一个10g的库应用访问报ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME通过分析alert日志,确认是数据库启动报ORA-600 4194错误Mon Sep 23 16:12:42 2024 SMON: enabling cache recovery Mon Sep 23 16:12:43 2024 Successfully onlined Undo Tablespace 1. Mon Sep 23 16:12:43 2024 SMON: enabling tx recovery Mon Sep 23 16:12:43 2024 Database Characterset is ZHS16GBK Mon Sep 23 16:12:43 2024 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\udump\xifenfei_ora_7832.trc: ORA-00600: 内部错误代码, 参数: [4194], ...继续阅读 (16)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]一个10g的库应用访问报ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME通过分析alert日志,确认是数据库启动报ORA-600 4194错误Mon Sep 23 16:12:42 2024 SMON: enabling cache recovery Mon Sep 23 16:12:43 2024 Successfully onlined Undo Tablespace 1. Mon Sep 23 16:12:43 2024 SMON: enabling tx recovery Mon Sep 23 16:12:43 2024 Database Characterset is ZHS16GBK Mon Sep 23 16:12:43 2024 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\udump\xifenfei_ora_7832.trc: ORA-00600: 内部错误代码, 参数: [4194], ...继续阅读 (16)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-01092 ORA-00604 ORA-01558故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户一个11.2.0.1的库,在重启之前报ORA-00604和ORA-01558: out of transaction ID’s in rollback segment SYSTEM错误Sat Mar 16 05:51:44 2024 Errors in file /opt/oracle/app/diag/rdbms/xff/xff/trace/xff_smon_47709.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01558: out of transaction ID's in rollback segment SYSTEM Sat Mar 16 05:51:55 2024 Errors in file /opt/oracle/app/diag/rdbms/xff/xff/trace/xff_smon_47709.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01558: ...继续阅读 (16)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-01092 ORA-00604 ORA-01558故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户一个11.2.0.1的库,在重启之前报ORA-00604和ORA-01558: out of transaction ID’s in rollback segment SYSTEM错误Sat Mar 16 05:51:44 2024 Errors in file /opt/oracle/app/diag/rdbms/xff/xff/trace/xff_smon_47709.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01558: out of transaction ID's in rollback segment SYSTEM Sat Mar 16 05:51:55 2024 Errors in file /opt/oracle/app/diag/rdbms/xff/xff/trace/xff_smon_47709.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01558: ...继续阅读 (19)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-65088: database open should be retried作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在12.2以及后续的cdb版本中,如果重建ctl并且resetlogs库,很可能会遇到ORA-65088: database open should be retried错误SQL> startup nomount force pfile='//.ora'; ORACLE instance started. Total System Global Area 1593835520 bytes Fixed Size 8793256 bytes Variable Size 402654040 bytes Database Buffers 1174405120 bytes Redo Buffers 7983104 bytes SQL> !vi ctl.sql SQL> @ctl.sql Control file created. SQL> select count(*) ,fhsta from x$kcvfh group ...继续阅读 (21)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-65088: database open should be retried作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在12.2以及后续的cdb版本中,如果重建ctl并且resetlogs库,很可能会遇到ORA-65088: database open should be retried错误SQL> startup nomount force pfile='//.ora'; ORACLE instance started. Total System Global Area 1593835520 bytes Fixed Size 8793256 bytes Variable Size 402654040 bytes Database Buffers 1174405120 bytes Redo Buffers 7983104 bytes SQL> !vi ctl.sql SQL> @ctl.sql Control file created. SQL> select count(*) ,fhsta from x$kcvfh group ...继续阅读 (17)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 19c异常恢复—ORA-01209/ORA-65088作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于raid卡bug故障,导致文件系统异常,从而使得数据库无法正常启动,客户找到我之前已经让多人分析,均未恢复成功,查看alert日志,发现他们恢复的时候尝试resetlogs库,然后报ORA-600 kcbzib_kcrsds_1错误2024-09-15T17:07:32.553215+08:00 alter database open resetlogs 2024-09-15T17:07:32.569110+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 274757454692 time .... (PID:8074): Clearing online redo logfile 1 /opt/oracle/o ...继续阅读 (16)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 19c异常恢复—ORA-01209/ORA-65088作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于raid卡bug故障,导致文件系统异常,从而使得数据库无法正常启动,客户找到我之前已经让多人分析,均未恢复成功,查看alert日志,发现他们恢复的时候尝试resetlogs库,然后报ORA-600 kcbzib_kcrsds_1错误2024-09-15T17:07:32.553215+08:00 alter database open resetlogs 2024-09-15T17:07:32.569110+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 274757454692 time .... (PID:8074): Clearing online redo logfile 1 /opt/oracle/o ...继续阅读 (23)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 16703故障再现作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]从第一次发现ORA-600 16703(警告：互联网中有oracle介质被注入恶意程序导致—ORA-600 16703)至今已经7年多时间了,最近依旧有客户中招,提醒各位注意该问题Sat Sep 14 21:43:29 2024 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Sep 14 21:43:29 2024 SMON: enabling cache recovery Errors in file D:\ORACLE\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_6264.trc (incident=8561): ORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Incident details in: D:\ORACLE\APP\ADMINISTRATOR\diag\rdbms\orcl\orc ...继续阅读 (20)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 16703故障再现作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]从第一次发现ORA-600 16703(警告：互联网中有oracle介质被注入恶意程序导致—ORA-600 16703)至今已经7年多时间了,最近依旧有客户中招,提醒各位注意该问题Sat Sep 14 21:43:29 2024 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Sep 14 21:43:29 2024 SMON: enabling cache recovery Errors in file D:\ORACLE\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_6264.trc (incident=8561): ORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Incident details in: D:\ORACLE\APP\ADMINISTRATOR\diag\rdbms\orcl\orc ...继续阅读 (16)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：数据库启动报ORA-27102 OSD-00026 O/S-Error: (OS 1455)作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]一个win上运行的11.2.0.4库启动的时候报ORA-27102 OSD-00026 O/S-Error: (OS 1455)错误SQL> STARTUP ORA-27102: out of memory OSD-00026: 附加错误信息 O/S-Error: (OS 1455) 页面文件太小，无法完成操作。数据库alert日志信息Fri Sep 13 17:17:39 2024 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 24 Number of processor cores in the system is 12 Number of processor sockets in the system is 1 Picked latch-free SCN scheme 3 Error: Failed to allocate SGA g ...继续阅读 (20)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 19c RAC 替换私网操作作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]19c的三节点集群,需要替换一个私网网卡(如果有足够的停机窗口有一个更加简单的方法,直接通过修改网卡名称实现替换,不过需要主机重启一次,参考:Linux 8 修改网卡名称)1. 先在主机层面确认新配置网络能够相互ping通,在hosts文件加入私网信息,并且确认ssh 可以相互访问ssh xffdb1-priv3 date;ssh xffdb2-priv3 date;ssh xffdb3-priv3 date;2. 删除掉需要删除的网络上的asm监听和该network信息[grid@xffdb1 ~]$ srvctl config listener -asmlistener Name: ASMNET1LSNR_ASM Type: ASM Listener Owner: grid Subnet: 172.16.16.0 Home:End points: TCP:1525 Listener is enabled. Listener is individually enabled on nodes: Listener is individually disabled o ...继续阅读 (27)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 19c RAC 替换私网操作作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]19c的三节点集群,需要替换一个私网网卡(如果有足够的停机窗口有一个更加简单的方法,直接通过修改网卡名称实现替换,不过需要主机重启一次,参考:Linux 8 修改网卡名称)1. 先在主机层面确认新配置网络能够相互ping通,在hosts文件加入私网信息,并且确认ssh 可以相互访问ssh xffdb1-priv3 date;ssh xffdb2-priv3 date;ssh xffdb3-priv3 date;2. 删除掉需要删除的网络上的asm监听和该network信息[grid@xffdb1 ~]$ srvctl config listener -asmlistener Name: ASMNET1LSNR_ASM Type: ASM Listener Owner: grid Subnet: 172.16.16.0 Home:End points: TCP:1525 Listener is enabled. Listener is individually enabled on nodes: Listener is individually disabled o ...继续阅读 (20)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]从oracle 12c引入pdb特性之后,数据库非常规恢复中就有一个ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt]的噩梦,一般是在recreate controlfile之后resetlogs库之后,在open pdb会遇到这个错误,mos上主要bug信息Bug 22709877 open resetlogs fails with ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt]Bug 16784143 ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] with PDBsBug 31686545 RMAN: Open PDB fails with ORA-00600 [kcvfdb_pdb_set_clean_scn: cleanckpt]对于这些bug引起的ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt]问题,尽可能规避掉这些bu ...继续阅读 (27)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]从oracle 12c引入pdb特性之后,数据库非常规恢复中就有一个ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt]的噩梦,一般是在recreate controlfile之后resetlogs库之后,在open pdb会遇到这个错误,mos上主要bug信息Bug 22709877 open resetlogs fails with ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt]Bug 16784143 ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] with PDBsBug 31686545 RMAN: Open PDB fails with ORA-00600 [kcvfdb_pdb_set_clean_scn: cleanckpt]对于这些bug引起的ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt]问题,尽可能规避掉这些bu ...继续阅读 (22)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 krhpfh_03-1210故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]rac数据库多个节点均处于open状态,数据查询正常,但是应用入库有些时候会失败报类似ORA-01187: cannot read from file because it failed verification tests错误：故障最初原因是由于有坏盘,换盘之后,有两个节点数据实例crashMon Aug 19 21:16:47 2024 Read of datafile '+DATA/xifenfei99.dbf' (fno 1399) header failed with ORA-01207 Rereading datafile 1399 header failed with ORA-01207 Errors in file /u01/app/oracle/diag/rdbms/xff/xff5/trace/xff5_ckpt_75779.trc: ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01122: database file 1 ...继续阅读 (29)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 krhpfh_03-1210故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]rac数据库多个节点均处于open状态,数据查询正常,但是应用入库有些时候会失败报类似ORA-01187: cannot read from file because it failed verification tests错误：故障最初原因是由于有坏盘,换盘之后,有两个节点数据实例crashMon Aug 19 21:16:47 2024 Read of datafile '+DATA/xifenfei99.dbf' (fno 1399) header failed with ORA-01207 Rereading datafile 1399 header failed with ORA-01207 Errors in file /u01/app/oracle/diag/rdbms/xff/xff5/trace/xff5_ckpt_75779.trc: ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01122: database file 1 ...继续阅读 (32)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：19c库启动报ORA-600 kcbzib_kcrsds_1作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]一套19c的库由于某种情况,发现异常,当时的技术使用隐含参数强制拉库,导致数据库启动报ORA-00704 ORA-600 kcbzib_kcrsds_1错误2024-08-24T06:11:25.494304+08:00 ALTER DATABASE OPEN 2024-08-24T06:11:25.494370+08:00 TMI: adbdrv open database BEGIN 2024-08-24 06:11:25.494324 Smart fusion block transfer is disabled: instance mounted in exclusive mode. 2024-08-24T06:11:25.515306+08:00 Beginning crash recovery of 1 threads parallel recovery started with 7 processes Thread 1: Recovery starting at checkpoint rba (logseq 2 block ...继续阅读 (43)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：19c库启动报ORA-600 kcbzib_kcrsds_1作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]一套19c的库由于某种情况,发现异常,当时的技术使用隐含参数强制拉库,导致数据库启动报ORA-00704 ORA-600 kcbzib_kcrsds_1错误2024-08-24T06:11:25.494304+08:00 ALTER DATABASE OPEN 2024-08-24T06:11:25.494370+08:00 TMI: adbdrv open database BEGIN 2024-08-24 06:11:25.494324 Smart fusion block transfer is disabled: instance mounted in exclusive mode. 2024-08-24T06:11:25.515306+08:00 Beginning crash recovery of 1 threads parallel recovery started with 7 processes Thread 1: Recovery starting at checkpoint rba (logseq 2 block ...继续阅读 (30)