首页 > 数据库 >断电引起文件scn异常数据库恢复---惜分飞

断电引起文件scn异常数据库恢复---惜分飞

时间：2024-03-03 16:45:03浏览次数：26  
标签：2024 scn DATABASE 分飞 XFF --- file backup ORA

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

标题：断电引起文件scn异常数据库恢复

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

由于异常断电，数据库最初启动报错

Fri Mar 01 08:41:17 2024 ALTER DATABASE   MOUNT Successful mount of redo thread 1, with mount id 1865809648 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE   MOUNT Fri Mar 01 08:41:24 2024 ALTER DATABASE OPEN Errors in file /home/oracle/app/diag/rdbms/XFF/XFF/trace/XFF_ora_25243.trc: ORA-01113: file 13 needs media recovery ORA-01110: data file 13: '/data2/oracle/oradata/data/data00.dbf' ORA-1113 signalled during: ALTER DATABASE OPEN...

经过应用厂商一系列操作，主要是如下操作

Fri Mar 01 11:10:56 2024 ALTER DATABASE RECOVER  datafile 13  Media Recovery Start Serial Media Recovery started WARNING! Recovering data file 13 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. ORA-279 signalled during: ALTER DATABASE RECOVER  datafile 13  ... Fri Mar 01 11:11:09 2024 ALTER DATABASE RECOVER    CONTINUE DEFAULT  Media Recovery Log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc Errors with log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ... ALTER DATABASE RECOVER    CONTINUE DEFAULT  Media Recovery Log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc Errors with log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ... ALTER DATABASE RECOVER CANCEL Media Recovery Canceled Completed: ALTER DATABASE RECOVER CANCEL Fri Mar 01 11:16:50 2024 db_recovery_file_dest_size of 10240 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Fri Mar 01 11:51:56 2024 Starting ORACLE instance (normal) Fri Mar 01 12:11:35 2024 alter database datafile 13 offline ORA-1145 signalled during: alter database datafile 13 offline... Fri Mar 01 12:12:29 2024 alter database recover cancel ORA-1112 signalled during: alter database recover cancel... Fri Mar 01 12:13:24 2024 ALTER DATABASE RECOVER  database until cancel  Media Recovery Start  started logmerger process Fri Mar 01 12:13:24 2024 WARNING! Recovering data file 13 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 14 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 15 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 16 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 17 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 18 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 19 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 20 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 21 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. WARNING! Recovering data file 22 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. Parallel Media Recovery started with 48 slaves ORA-279 signalled during: ALTER DATABASE RECOVER  database until cancel  ... ALTER DATABASE RECOVER    CONTINUE DEFAULT  Media Recovery Log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc Errors with log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc Errors in file /home/oracle/app/diag/rdbms/XFF/XFF/trace/XFF_pr00_38097.trc: ORA-00308:cannot open archived log '/home/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ... ALTER DATABASE RECOVER    CONTINUE DEFAULT  Media Recovery Log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc Errors with log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc Errors in file /home/oracle/app/diag/rdbms/XFF/XFF/trace/XFF_pr00_38097.trc: ORA-00308:cannot open archived log '/home/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ... ALTER DATABASE RECOVER CANCEL Signalling error 1152 for datafile 1! Errors in file /home/oracle/app/diag/rdbms/XFF/XFF/trace/XFF_pr00_38097.trc: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/data1/oracle/oradata/XFF/system01.dbf' Slave exiting with ORA-1547 exception Errors in file /home/oracle/app/diag/rdbms/XFF/XFF/trace/XFF_pr00_38097.trc: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/data1/oracle/oradata/XFF/system01.dbf' ORA-10879 signalled during: ALTER DATABASE RECOVER CANCEL ... Fri Mar 01 13:23:05 2024 ALTER DATABASE DATAFILE '/data2/oracle/oradata/data/data00.dbf' OFFLINE DROP Completed: ALTER DATABASE DATAFILE '/data2/oracle/oradata/data/data00.dbf' OFFLINE DROP

接手现场之后,尝试单个文件recover操作

SQL> recover datafile 1; ORA-00283: recovery session canceled due to errors ORA-00264: no recovery required SQL> recover datafile 2; Media recovery complete. SQL> recover datafile 3; Media recovery complete. SQL> recover datafile 4; Media recovery complete. SQL> recover datafile 5; Media recovery complete. SQL> recover datafile 6,7,8,9,10; Media recovery complete. SQL> recover datafile 11; Media recovery complete. SQL> recover datafile 12; Media recovery complete. SQL> recover datafile 13; ORA-00279: change 1474236715 generated at 02/29/2024 17:13:00 needed for thread 1 ORA-00289: suggestion : /home/oracle/app/program/11g/dbs/arch1_153563_1136037378.dbf ORA-00280: change 1474236715 for thread 1 is in sequence #153563     Specify log: {<RET>=suggested | filename | AUTO | CANCEL}   ORA-00308: cannot open archived log '/home/oracle/app/program/11g/dbs/arch1_153563_1136037378.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3     SQL> recover datafile 14; ORA-00279: change 1474236715 generated at 02/29/2024 17:13:00 needed for thread 1 ORA-00289: suggestion : /home/oracle/app/program/11g/dbs/arch1_153563_1136037378.dbf ORA-00280: change 1474236715 for thread 1 is in sequence #153563     Specify log: {<RET>=suggested | filename | AUTO | CANCEL}   ORA-00308: cannot open archived log '/home/oracle/app/program/11g/dbs/arch1_153563_1136037378.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3

基于这样的情况,通过Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)检查发现/data2挂载点所有数据文件异常,由于以前的操作日志已经被清空无法判断原因,初步怀疑和这个挂载点本身有关系
20240303160404
20240303160524
这种情况直接使用bbed修改文件头,然后open库,再逻辑导出数据,完成本次数据恢复工作,参考类似文档
bbed 修改datafile header
使用bbed让rac中的sysaux数据文件online
当然这类故障也可以通过自研的Oracle Recovery Tools工具进行修复处理,类似文档:
Oracle Recovery Tools解决ORA-00279 ORA-00289 ORA-00280故障

标签：2024,scn,DATABASE,分飞,XFF,---,file,backup,ORA
From： https://www.cnblogs.com/xifenfei/p/18050242

相关文章

  • 多线程限流工具类-Semaphore
    Semaphore介绍Semaphore（信号量）是JAVA多线程中的一个工具类，它可以通过指定参数来控制执行线程数量，一般用于限流访问某个资源时使用。Semaphore使用示例需求场景：用一个核心线程数为6，最大线程数为20的线程池执行任务，但是要求最多只能同时运行3个线程代码：publicclassdemo{......
  • Vue3学习（二十一）- 文档管理页面布局修改
    写在前面按照国际惯例，要先聊下生活，吐槽一番，今天是2月14日，也是下午听老妈说，我才知道！现在真的是对日期节日已经毫无概念可言，只知道星期几。现在已经觉得写博客也好，学习文章也罢，和写日记一样，已经融入到我的生活中，或者更确切的说，变成生活的一部分了。饭后和老妈闲聊了几句后，我发......
  • DC-8
    DC-8靶机渗透测试过程信息收集主机扫描nmap-sP192.168.238.0/24或arp-scan-l靶机ip192.168.238.196端口扫描nmap-A192.168.238.196有22，80端口开着目录扫描dirbhttp://192.168.238.196/|grep'CODE:2'或dirsearch-uhttp://192.168.238.196/这里能扫到......
  • 03-PCB设计
    目录一.过孔类型二.焊盘三.丝印四.阻焊五.PCB层叠结构六.元件符号与封装七.设计流程一.过孔类型二.焊盘三.丝印四.阻焊五.PCB层叠结构六.元件符号与封装七.设计流程......
  • Day01---Web前端基础
    1，换行，分割和超链接换行命令：分隔线命令：超链接命令：超链接有两种常用用法：页面跳转，下载文件<!DOCTYPEhtml><htmllang="en"><head><metacharset="UTF-8"><title>Title</title></head><body><!--页面跳转:如果href的值是网......
  • anki-usage
    ankiusageanki使用笔记Created:2024-03-03T15:51+08:00Published:2024-03-03T16:06+08:00Categories:Misc目录anki批量选择题什么是anki：Anki从入门到精通_哔哩哔哩_bilibili（大概是一个可以自定义内容的百词斩之类的软件，允许用户制作和分发卡组）anki批量选择题参......
  • C++ ++ 和 -- 运算符重载
    原文递增运算符（++）和递减运算符（--）是C++语言中两个重要的一元运算符。1、递增和递减一般是改变对象的状态，所以一般是重载为成员函数。2、重载递增递减，一定要和指针的递增递减区分开。因为这里的重载操作的是对象，而不是指针(由于指针是内置类型，指针的递增递减是无法重载的)，......
  • Go 100 mistakes - #94: Not being aware of data alignment
      ......
  • java - 流式编程
    1.获取流的方法：//1.从集合转化List<Integer>list=newArrayList<>();Stream<Integer>stream=list.stream();//转化为流stream.Collect(Collectors.toList());//转换为流，流再转回为集合。//2.自定义初始化Stream<Integer>stream=Stream.of(1,5,6，4，8，3，1，9); 2......
  • Go - Optimization - instruction-level parallelism (ILP)
      ......

赞助商

阅读排行

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

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

Copyright © 2020-2023 IPS99 版权所有 IPS99