联系：手机/微信(+86 17813235971) QQ(107644445)标题：A____Z____RECOVER____DATA勒索恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有客户MySQL数据库被黑,业务库中表被删除,并创建A____Z____RECOVER____DATA库,里面有一张readme表,内容为:mysql> select * from readme \G; *************************** 1. row *************************** zh_content: 请尽快与我们取得联系，否则我们将会公布你的数据库信息在网络中，联系邮件：datacenterback@keemail.me en_content: 请尽快与我们取得联系，否则我们将会公布你的数据库信息在网络中，联系邮件：datacenterback@keemail.me email: datacenterback@keemail.me 1 row in set (0.00 sec)对于这种情况,本质就是mysql drop 库或者drop表级别的恢复,通过反删除软件恢复,可惜恢复效果很差（底层发生了大量的覆盖）对于这种情况,只能采用底层block级别恢复,通过底层扫描分析并解析扫描结果恢复需 ...继续阅读 (111)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：A____Z____RECOVER____DATA勒索恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有客户MySQL数据库被黑,业务库中表被删除,并创建A____Z____RECOVER____DATA库,里面有一张readme表,内容为:mysql> select * from readme \G; *************************** 1. row *************************** zh_content: 请尽快与我们取得联系，否则我们将会公布你的数据库信息在网络中，联系邮件：datacenterback@keemail.me en_content: 请尽快与我们取得联系，否则我们将会公布你的数据库信息在网络中，联系邮件：datacenterback@keemail.me email: datacenterback@keemail.me 1 row in set (0.00 sec)对于这种情况,本质就是mysql drop 库或者drop表级别的恢复,通过反删除软件恢复,可惜恢复效果很差（底层发生了大量的覆盖）对于这种情况,只能采用底层block级别恢复,通过底层扫描分析并解析扫描结果恢复需 ...继续阅读 (93)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-1200/ORA-1207数据库恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于系统性能问题或者底层io问题,数据库alert日志报一下控制文件损坏错误然后crash掉Mon Nov 13 08:06:44 2023 Thread 1 advanced to log sequence 12100 (LGWR switch) Current log# 1 seq# 12100 mem# 0: /u01/oracle/oradata/xifenfei/redo01.log Mon Nov 13 09:23:59 2023 ********************* ATTENTION: ******************** The controlfile header block returned by the OS has a sequence number that is too old. The controlfile might be corrupted. PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE without following the steps be ...继续阅读 (100)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-1200/ORA-1207数据库恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于系统性能问题或者底层io问题,数据库alert日志报一下控制文件损坏错误然后crash掉Mon Nov 13 08:06:44 2023 Thread 1 advanced to log sequence 12100 (LGWR switch) Current log# 1 seq# 12100 mem# 0: /u01/oracle/oradata/xifenfei/redo01.log Mon Nov 13 09:23:59 2023 ********************* ATTENTION: ******************** The controlfile header block returned by the OS has a sequence number that is too old. The controlfile might be corrupted. PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE without following the steps be ...继续阅读 (77)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储断电导致ORA-00325故障恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于存储断电,数据库启动最初报错Reconfiguration complete parallel recovery started with 32 processes Started redo scan Completed redo scan read 22887 KB redo, 2025 data blocks need recovery Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl11/trace/orcl11_ora_25449.trc (incident=25522): ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [203596], [1537], [3046], [] Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl11/incident/incdir_25522/orcl11_ora_25449_i25522.trc ...继续阅读 (112)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储断电导致ORA-00325故障恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于存储断电,数据库启动最初报错Reconfiguration complete parallel recovery started with 32 processes Started redo scan Completed redo scan read 22887 KB redo, 2025 data blocks need recovery Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl11/trace/orcl11_ora_25449.trc (incident=25522): ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [203596], [1537], [3046], [] Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl11/incident/incdir_25522/orcl11_ora_25449_i25522.trc ...继续阅读 (89)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：重建ctl遭遇ORA-01163 ORA-01110和ORA-600 kccccfl_1错误作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有客户联系我,数据库强制关闭之后无法正常启动,通过他们一系列尝试,数据库报open 报ORA-01555错误通过分析确认是由于客户屏蔽一致性强制拉库失败导致Wed Nov 01 19:49:03 2023 alter database open resetlogs 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 1199697777 Archived Log entry 68106 added for thread 1 sequence 3829 ID 0x761a769a dest 1: Archived Log entry 68107 added for thread 1 sequence 3830 ID 0x ...继续阅读 (112)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：RFS[22349]: Database mount ID mismatch作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]今天检查数据库发现一套主库上面报大量RFS[22349]: Database mount ID mismatch之类的错误[oracle@hisdb2 trace]$ tail -f alert_hisdb2.log LNS: Standby redo logfile selected for thread 2 sequence 133319 for destination LOG_ARCHIVE_DEST_2 Mon Nov 06 20:56:09 2023 RFS[27080]: Assigned to RFS process 15518 RFS[27080]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) Mon Nov 06 20:57:09 2023 RFS[27081]: Assigned to RFS process 16299 RFS[27081]: Database mount ID mismatch [0x ...继续阅读 (116)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：触发器找出密码错误应用作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]经常会遇到修改oracle业务用户密码之后,由于部分应用密码没有被正确修改(忘记修改,或者修改错误了),导致数据库被hang或者用户被锁的情况,对于这样的情况,通过一个logon触发器可以快速找到create or replace trigger logon_denied_to_alert after servererror on database declare message varchar2(120); IP varchar2(15); v_os_user varchar2(80); v_module varchar2(50); v_action varchar2(50); v_pid varchar2(10); v_sid number; v_username varchar2(50); v_suser varchar2(50); begin IF (ora_is_servererror(1017)) THEN if sys_context('userenv', 'network_protocol') ...继续阅读 (112)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：redhat和oracle linux kernel对应关系—202310作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.] Oracle LinuxOracle Linux Release DateOracle Linux Kernel / Architecture / Release StringRed Hat Enterprise LinuxRed Hat Enterprise Linux Kernel / Release StringOracle Linux 9 Red Hat Enterprise Linux 9 Oracle Linux 9.111 Nov 2022UEKR7 5.15.0-3.60.5.1.el9uek ^ * (x86_64, aarch64)RHCK 5.14.0-162.6.1.el9_1 (x86_64, aarch64)redhat-release: Red Hat Enterprise Linux release 9.1 (Ootpa)system-release: Oracle Linux Server release 9.1oracle-release: Oracle Linux Serve ...继续阅读 (109)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：11.2.0.4最新patch信息（扩展补丁）–202310作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]11.2.0.4 Database Patch Set UpdateRelease DateVersionDownload linkIncluded in Windows Bundle17-Oct-202311.2.0.4.231017 (Oct 2023) Database Patch Set Update (DB PSU)Patch 35574075* Out of Error Correction18-Jul-202311.2.0.4.230718 (Jul 2023) Database Patch Set Update (DB PSU)Patch 35269283* Out of Error Correction18-Apr-202311.2.0.4.230418 (Apr 2023) Database Patch Set Update (DB PSU)Patch 34998337* Out of Error Correction17-Jan-202311.2.0.4.230117 (Jan 2023) Database Pa ...继续阅读 (105)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：再现ORA-600 4000故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有一个10g的库，由于redo损坏导致无法正常recover成功正常途径无法open成功,尝试强制打开库Wed Oct 18 11:23:25 2023 alter database open resetlogs Wed Oct 18 11:23:25 2023 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 236715370 Resetting resetlogs activation ID 4009817354 (0xef00f50a) Wed Oct 18 11:23:26 2023 Setting recovery target incarnation to 3 Wed Oct 18 11:23:26 2023 Assigning activation ID 4 ...继续阅读 (99)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 12807 修复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]这次阳了有点严重，客户现场打patch无法去，在家里远程值守,在电脑前面闲着就查询和重现了最近朋友和我说的他们的客户遇到ORA-600 12807的故障.查询了下mos,基本上可以确认是由于CON$.CON#达到理论最大值无法继续增加从而报该错误,参考文档:Mechanism to Recycle Database Constraint Identifiers (Doc ID 2925056.1)Bug 13781691 – ORA-600 [12807] if CON$.CON# very high due to bug 13784384 (Doc ID 13781691.8)Bug 25343563 – Mechanism to Implement Constraint Identifier (con#) Recycling (Doc ID 25343563.8)在12及其之后的版本中oracle发布了patch 25343563 并设置event启用该patch进行解决.但是如果是12c之前版本,官方没有提供直接的解决方案.最基本的解决方法就是 ...继续阅读 (110)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：非tns方式登录pdb方法作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]非tns方式登录pdb方法之—-alter session set container[oracle@db01 ~]$ env|grep ORA ORACLE_SID=DCXFF ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/19c/db_1 [oracle@db01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 9 22:10:34 2023 Version 19.20.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.20.0.0.0 SQL> show pdbs; CON_ID CON_NAME ...继续阅读 (112)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-07445: exception encountered: core dump [kdxlin()+4088]处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]abort方式关闭数据库，启动报错Tue Sep 19 21:52:56 2023 NOTE: dependency between database orcl and diskgroup resource ora.DATA.dg is established Tue Sep 19 21:52:57 2023 Reconfiguration started (old inc 4, new inc 6) List of instances: 1 (myinst: 1) Global Resource Directory frozen * dead instance detected - domain 0 invalid = TRUE Communication channels reestablished Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out ...继续阅读 (114)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：bbed解决ORA-01578作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]业务报ORA-01578坏块,无法正常使用,alert日志报错如下Reading datafile '/data/u01/ZLDOCXML01.DBF' for corruption at rdba: 0x02efdc97 (file 11, block 3136663) Reread (file 11, block 3136663) found same corrupt data Wed Sep 13 19:02:04 2023 Corrupt Block Found TSN = 10, TSNAME = ZLDOCXML RFN = 11, BLK = 3136663, RDBA = 49274007 OBJN = 73646, OBJD = 73646, OBJECT = SYS_LOB0000073645C00029$$, SUBOBJECT = SEGMENT OWNER = ZLDOC, SEGMENT TYPE = Lob Segment DDE: Problem Key 'ORA 1578 ...继续阅读 (122)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：asm disk被加入到另外一个磁盘组故障恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有朋友在aix环境对其中一个rac的asm磁盘组进行扩容之后另外一套rac的磁盘组直接dismountWed Aug 23 12:44:02 2023 NOTE: SMON starting instance recovery for group DATA domain 2 (mounted) NOTE: F1X0 found on disk 0 au 2 fcn 0.128808679 NOTE: SMON skipping disk 7 - no header NOTE: cache initiating offline of disk 7 group DATA NOTE: process _smon_+asm1 (1770932) initiating offline of disk 7.3422955792 (DATA_0007) with mask 0x7e in group 2 NOTE: initiating PST update: grp = 2, dsk = 7/0xcc062910, mask = 0x6a, op = clear Wed ...继续阅读 (116)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 ksuloget2 恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户在win 32位的操作系统上调至sga超过2G,数据库运行过程中报ORA-600 ksuloget2错误Thread 1 cannot allocate new log, sequence 43586 Checkpoint not complete Current log# 1 seq# 43585 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG Fri Aug 04 14:57:02 2023 Errors in file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_42996.trc (incident=67481): ORA-00600: 内部错误代码, 参数: [ksuloget2], [0xFEBA6208], [0xFEBA3B08], [500], [0xFEBA622C], [], [], [], [], [] Thread 1 advanced to log sequence 43586 (LGWR switch) Current log# 2 seq ...继续阅读 (104)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-10485: Real-Time Query cannot be enabled while applying migration redo.作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]对于数据库打psu和jvm patch之后,dg备库同步会出现类似ORA-10485: Real-Time Query cannot be enabled while applying migration redo.异常Tue Aug 15 18:48:18 2023 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION Attempt to start background Managed Standby Recovery process (orcl) Tue Aug 15 18:48:18 2023 MRP0 started with pid=33, OS id=15486 MRP0: Background Managed Standby Recovery process started (orcl) started ...继续阅读 (117)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Patch SCN一键解决ORA-600 2662故障作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户强制重启库之后,数据库启动报ORA-600 2037,ORA-745 kcbs_reset_pool/kcbzre1等错误Wed Aug 09 13:25:38 2023 alter database mount exclusive Successful mount of redo thread 1, with mount id 1672229586 Database mounted in Exclusive Mode Lost write protection disabled Completed: alter database mount exclusive alter database open Beginning crash recovery of 1 threads parallel recovery started with 15 processes Started redo scan Completed redo scan read 84074 KB redo, 37037 data blocks need recovery We ...继续阅读 (105)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：amdu参数详解作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]最近发现amdu命令比以前认知中的强大,记录下相关参数[oracle@xifenfei ~]$ amdu help=y a/usize AU size for corrupt disks -ausize: This option must be set when -baddisks is set. It must be a power of 2. This size is required to scan a disk looking for metadata, and it is normally read from the disk header. The value applies to all disks that do not have a valid header. The value from the disk header will be used if a valid header is found. ba/ddisks Include disks with bad headers -b ...继续阅读 (135)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 kghstack_underflow_internal_2作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]aix平台运行11.2.0.4 rac,突然一个节点crash,lms2进程报ORA-600 kghstack_underflow_internal_2错误Thu Aug 03 18:43:16 2023 Errors in file /u01/oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_lms2_2884404.trc (incident=761244): ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2], [0x11074D658], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/oracle/app/oracle/diag/rdbms/xff/xff2/incident/incdir_761244/xff2_lms2_2884404_i761244.trc Errors in file /u ...继续阅读 (103)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：WRH$_LATCH, WRH$_SYSSTAT, WRH$_PARAMETER对象较大作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]通过awrinfo查看发现sysaux中以下对象大小属于top N********************************** (3b) Space usage within AWR Components (> 500K) ********************************** COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE --------- --------- --------------------------------------------------------------------- --------------- FIXED 136.0 WRH$_PARAMETER_PK.WRH$_PARAME_1600597976_0 - 68% INDEX PARTITION ...继续阅读 (129)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle 19C 报ORA-704 ORA-01555故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]异常断电导致数据库无法启动,尝试对数据文件进行recover操作,报ORA-00283 ORA-00742 ORA-00312错误,由于redo写丢失无法正常应用D:\check_db>sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on 星期日 7月 30 07:49:19 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. 连接到: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> recover datafile 1; ORA-00283: 恢复会话因错误而取消 ORA-00742: 日志读取在线程 1 序列 9274 块 18057 中检测到写入丢失情况 ORA-00312: 联机日志 1 线程 1: ' ...继续阅读 (136)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Exadata磁盘损坏导致磁盘组无法mount恢复（oracle一体机磁盘组异常恢复）作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]Oracle Exadata客户,在换盘过程中,cell节点又一块磁盘损坏,导致datac1磁盘组（该磁盘组是normal方式冗余)无法mountThu Jul 20 22:01:21 2023 SQL> alter diskgroup datac1 mount force NOTE: cache registered group DATAC1 number=1 incarn=0x0728ad12 NOTE: cache began mount (first) of group DATAC1 number=1 incarn=0x0728ad12 NOTE: Assigning number (1,35) to disk (o/192.168.10.9;192.168.10.10/DATAC1_CD_11_dm01celadm03) NOTE: Assigning number (1,31) to disk (o/192.168.10.9;192.168.10.10/DATAC1_CD_07_dm01celadm03) ...继续阅读 (135)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：.faust加密勒索数据库恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有客户的win服务器被勒索病毒加密,里面运行有用友系统的Oracle数据库，加密提示为（camry2020@aol.com）：加密的数据文件类似（.DBF.id[0E564ACA-3493].[camry2020@aol.com].faust）:通过工具检测发现少量block被加密破坏对于这种级别的损坏,可以通过我开发的Oracle数据文件勒索加密恢复工具直接重构文件头然后直接open数据库,并且导出数据,实现数据库非常完美的恢复(这个是目前除直接解密之外最好的恢复效果,没有之一)对于类似这种被加密的勒索的数据文件,我们可以实现比较好的恢复效果,如果此类的数据库(oracle,mysql,sql server)等被加密,需要专业恢复技术支持，请联系我们:电话/微信:17813235971 Q Q:107644445 E-Mail:dba@xifenfei.com系统安全防护措施建议：1.多台机器，不要使用相同的账号和口令2.登录口令要有足够的长度和复杂性，并定期更换登录口令3.重要资料的共享文件夹应设置访问权限控制，并进行定期备份4.定期检测系统和软件中的安全 ...继续阅读 (125)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases-202307作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]由于19c之前版本的patch,oracle在标准补丁中,已经不再提供,这里主要列举19c/21c相关主要patch 21.0.0.0 RUsDescriptionDatabase UpdateGI UpdateWindows Bundle PatchJUL2023  (21.11.0.0.0)354289783542790735347974APR2023 (21.10.0.0.0)351349343513256635046488JAN2023 (21.9.0.0.0)348397413483841534750812Oct2022 (21.8.0.0.0)345270843452614234468137JUL2022 (21.7.0.0.0)341604443415558934110698APR2022 (21.6.0.0.0)33843745338593953382914 ...继续阅读 (125)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-01122 ORA-01208 故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库突然故障ORA-01122 ORA-01208,导致实例crashTue Jul 11 09:06:43 2023 Thread 1 cannot allocate new log, sequence 254989 Private strand flush not complete Current log# 3 seq# 254988 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\xff\REDO03.LOG Thread 1 advanced to log sequence 254989 (LGWR switch) Current log# 1 seq# 254989 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\xff\REDO01.LOG Tue Jul 11 09:09:46 2023 Read of datafile 'E:\APP\ADMINISTRATOR\ORADATA\xff\SYSTEM01.DBF' (fno 1) header failed with ORA-012 ...继续阅读 (133)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：硬件故障恢复出文件之后数据库故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户那边硬件故障(raid损坏磁盘超过了极限,导致raid offline),通过硬件恢复出来数据文件,然后尝试自行恢复,我接手的时候大量数据文件resetlogs scn异常.重建控制文件报错WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release Errors in file /home/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_ora_5949.trc: ORA-01189: file is from a different RESETLOGS than previous files ORA-01110: data file 153: '/home/oracle/oracledata/orcl/sysaux02.dbf' ORA-15 ...继续阅读 (121)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：dul支持arm版本Oracle数据库恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]确认数据库名字,DBID,运行在ARM平台SQL> select name,dbid,PLATFORM_ID,PLATFORM_NAME from v$database; NAME DBID PLATFORM_ID --------- ---------- ----------- PLATFORM_NAME -------------------------------------------------------------------------------- ARMDB 1195886419 23 Linux OS (AARCH64)dul恢复ARM平台数据库 [oracle@xifenfei dul]$ ./dul Data UnLoader: 12.2.0.2.5 - Internal Only - on Sun Jul 9 22:05:51 2023 with 64-bit io functions and the decompression option Copyright (c) 1994 ...继续阅读 (123)