联系：手机/微信(+86 17813235971) QQ(107644445)标题：resetlogs强制拉库失败并使用备份system文件还原数据库故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]接手一个库,在open的过程中遭遇到ORA-600 2662错误Sun May 26 10:15:54 2024 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 84303583 Clearing online redo logfile 1 /data/OracleData/xff/redo01.log Clearing online log 1 of thread 1 sequence number 8330 Clearing online redo logfile 1 complete Clearing online redo logfile 2 /data/Oracle ...继续阅读 (64)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：resetlogs强制拉库失败并使用备份system文件还原数据库故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]接手一个库,在open的过程中遭遇到ORA-600 2662错误Sun May 26 10:15:54 2024 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 84303583 Clearing online redo logfile 1 /data/OracleData/xff/redo01.log Clearing online log 1 of thread 1 sequence number 8330 Clearing online redo logfile 1 complete Clearing online redo logfile 2 /data/Oracle ...继续阅读 (40)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]硬件故障,客户自行强制resetlogs库,报ORA-600 kcbzib_kcrsds_1错误2024-01-17T17:30:33.094367+08:00 alter database open resetlogs 2024-01-17T17:30:33.105461+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 16456823130015 time .... (PID:1584): Clearing online redo logfile 1 /u01/app/oracle/oradata/XFF/redo01.log .... (PID:1584): Clearing online redo logfile 2 ...继续阅读 (101)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储故障,强制拉库报ORA-600 kcbzib_kcrsds_1处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]硬件故障,客户自行强制resetlogs库,报ORA-600 kcbzib_kcrsds_1错误2024-01-17T17:30:33.094367+08:00 alter database open resetlogs 2024-01-17T17:30:33.105461+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 16456823130015 time .... (PID:1584): Clearing online redo logfile 1 /u01/app/oracle/oradata/XFF/redo01.log .... (PID:1584): Clearing online redo logfile 2 ...继续阅读 (75)

联系：手机(13429648788) QQ(107644445)标题：Exadata火线救援：10TB级数据恢复—强制拉库篇作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]这个库的恢复有一些历史故事(【力荐】Exadata火线救援：10TB级数据修复经典案例详解！)：xx运营商x2的1/4配置的oracle exadata机器，跑了近6年，最近有一个cell节点主机异常,在rebalance过程中,只有两个节点的cell其中一个节点坏了一个硬盘导致.导致asm diskgroup无法正常mount,最后该运营商运维三方通过amdu把该一体机中的数据文件全部抽出来,然后在恢复过程中出现大量错误无法解决,请求我们支持数据库open过程报ORA-01555错误Thu Jul 14 00:01:04 2016 alter database open Thu Jul 14 00:01:04 2016 Thread 1 advanced to log sequence 2 (thread open) Thread 1 opened at log sequence 2 Current log# 2 seq# 2 mem# 0: /data/amdu/redo/DATA_EC_260.f Successful open of ...继续阅读 (59)

本站文章除注明转载外，均为本站原创：转载自love wife & love life —Roger 的Oracle技术博客本文链接地址:11.2.0.4 ASM RAC 恢复一个例子这是一个朋友的客户的数据库，数据库出故障之后，无法顺利打开，如下是数据库在open的时候所报的错误:ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ... ALTER DATABASE RECOVER CONTINUE DEFAULT Media Recovery Log /space/sys_software/oracle/app/product/11.2.0/db_1/dbs/arch1_1_885005686.dbf Errors with log /space/sys_software/oracle/app/product/11.2.0/db_1/dbs/arch1_1_885005686.dbf Errors in file /space/sys_software/oracle/app/diag/rdbms/bexasmdb/bexasmdb1/trace/bexasmdb1_pr00_43377.trc: ORA-00308: cannot ...继续阅读 (84)