찾다
데이터 베이스MySQL 튜토리얼Oracle 联机重做日志文件恢复(redo log)

非当前联机日志文件故障恢复 1.启动数据库时遇到ORA-00313,ORA-00312错误。 ORA-00313: open failed for members of log group

非当前联机日志文件故障恢复

1.启动数据库时遇到ORA-00313,ORA-00312错误。

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/home/Oracle/oradata/s1/redo01.log'

2.查看v$log视图。

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 11 52428800 1 YES INACTIVE 489912 09-NOV-12
3 1 10 52428800 1 YES INACTIVE 488868 08-NOV-12
2 1 12 52428800 1 NO CURRENT 519028 11-NOV-12

3.用clear命令重建该日志文件

如果该日志文件已经归档则:
SQL> alter database clear logfile group 1;

Database altered.

如果该日志文件还没有归档则:
SQL> alter database clear unarchived logfile group 3;

Database altered.

4.打开数据库,重新备份数据库(建议clear,特别是clear unarchived后做一次全备份)
SQL> alter database open;

Database altered.

当前联机日志文件故障恢复

归档模式下,当前日志文件损坏有两种情况

一、数据库正常关闭,日志文件中没有解决的事务要实例恢复,当前日志组的损坏可直接用户
alter database clear unarchived logfile group n来重建

二、日志文件中有活动事物,数据库需要介质恢复,有两种补救方法
a、在归档模式下,有可用备份
b、无可用备份,通过强制性恢复,但可能会导致数据库不一致

a.在归档模式下有可用备份(不完全恢复)
1.1.启动数据库时报错,并用v$log查看
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/home/oracle/oradata/s1/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 16 52428800 1 NO CURRENT 520744 11-NOV-12
2 1 15 52428800 1 YES ACTIVE 520712 11-NOV-12
3 1 14 52428800 1 YES INACTIVE 520705 11-NOV-12


2.试用clear恢复

SQL> alter database clear logfile group 1;

SQL> alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance s1 (thread 1)
ORA-00312: online log 1 thread 1: '/home/oracle/oradata/s1/redo01.log'

3.执行recover database until cancel先用户auto后用cancel,报错如下:
SQL> recover database until cancel;
ORA-00279: change 520744 generated at 11/11/2012 22:43:39 needed for thread 1
ORA-00289: suggestion : /archive1/1_16_798842981.dbf
ORA-00280: change 520744 for thread 1 is in sequence #16
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/archive1/1_16_798842981.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log '/archive1/1_16_798842981.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/oradata/s1/system01.dbf'

SQL> recover database until cancel;
ORA-00279: change 520744 generated at 11/11/2012 22:43:39 needed for thread 1
ORA-00289: suggestion : /archive1/1_16_798842981.dbf
ORA-00280: change 520744 for thread 1 is in sequence #16
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/oradata/s1/system01.dbf'
ORA-01112: media recovery not started

4.在rman下restore database;
RMAN> restore database;

5.在rman下recover database:报错如下:
RMAN> recover database;

Starting recover at 11-NOV-12
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/11/2012 22:54:15
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start
ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/home/oracle/oradata/s1/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
FiiO CP13 cassette player launches with transparent retro lookFiiO CP13 cassette player launches with transparent retro lookJun 16, 2024 am 09:52 AM

TheFiiOCP13cassetteplayerwasannouncedinJanuary.Now,FiiOisexpandingitsportfoliowithtwonewmodels-onewitharedfrontandonewithatransparentfront.Thelatternotonlyperfectlymatchestheretrocharmoftheangulardesign,butalso

区块链资料分析工具有哪些?区块链资料分析工具有哪些?Feb 21, 2025 pm 10:24 PM

区块链技术的迅速发展带来了对可靠且高效的分析工具的需求。这些工具对于从区块链交易中提取有价值的见解至关重要,以便更好地理解和利用其潜力。本文将探讨市场上一些领先的区块链数据分析工具,包括他们的功能、优势和局限性。通过了解这些工具,用户可以获得必要的见解,最大限度地利用区块链技术的可能性。

币安Launchpool第64期项目分析与价格预测:RedStone (RED)能否点燃市场?币安Launchpool第64期项目分析与价格预测:RedStone (RED)能否点燃市场?Mar 03, 2025 pm 11:45 PM

大家好,我是你们的老朋友,一个常年在币安广场和大家聊加密市场的小伙伴。币安Launchpool最近上线了第64期项目——RedStone(RED),作为一个多链预言机项目,它在上线前就引发了不少讨论。今天我们就来深度剖析一下RED,看看它的潜力如何,以及上线后的价格可能怎么走。币安Launchpool第64期项目分析与价格预测:RedStone(RED)能否点燃市场?项目背景与核心亮点RedStone(RED)是一个专注于去中心化金融(DeFi)的多链预言机平台,目标是为E

赛道遇冷,垂直领域的AI Agent能否打破僵局?赛道遇冷,垂直领域的AI Agent能否打破僵局?Mar 05, 2025 am 07:57 AM

Web3垂直AIAgent:颠覆传统,重塑行业格局?本文探讨了Web2和Web3中AIAgent的应用差异及Web3Agent的未来潜力。Web2已广泛应用AIAgent提升效率,涵盖销售、营销等领域,并取得显著经济效益。而Web3Agent则结合区块链技术,开辟了全新应用场景,尤其在DeFi领域。其通过代币激励、去中心化平台和链上数据分析,展现出超越Web2Agent的潜力。尽管Web3Agent目前面临挑战,但其独特优势使其在中长期有望与Web2竞争,甚至重塑行业格局。Web2AI

尼康官宣完成对电影摄影机 RED 公司的收购尼康官宣完成对电影摄影机 RED 公司的收购Apr 13, 2024 pm 09:22 PM

本站4月13日消息,日前,尼康官宣已完成RED公司的收购,RED正式成为尼康子公司。根据官方公告,RED原总裁JarredLand和创始人JamesJannard将作为新公司顾问,任命尼康影像事业部KeijiOishi为RED新公司CEO,RED公司原执行副总裁TommyRios升任新公司联席CEO。公告称,RED目前的产品阵容、合作伙伴以及与经销商的关系不会有任何变化。RED将继续通过保修、维修服务、客户服务和整体产品支持政策。尼康表示,尼康和RED将合并两家公司的优势,开发独特的产品,同时利

垂直代理:加密原生代理的应用场景和颠覆性潜力解读垂直代理:加密原生代理的应用场景和颠覆性潜力解读Mar 04, 2025 am 10:21 AM

人工智能代理(AIAgents)正迅速融入企业日常运营,从大型公司到小型企业,几乎所有领域都已开始应用,包括销售、营销、财务、法律、IT、项目管理、物流、客户服务和工作流自动化等。我们正从人工处理数据、执行重复性任务和使用Excel表格的时代,转变为由AI代理全天候自主运行的时代,这不仅提高了效率,还显著降低了成本。Web2中AI代理的应用案例:YCombinator的视角Apten:一款结合AI和短信技术的销售与营销优化工具。BildAI:一款能够读取建筑蓝图,提

Redstone/RED币上市价格预测与代币经济学详解Redstone/RED币上市价格预测与代币经济学详解Mar 03, 2025 pm 10:42 PM

此次Redstone代币$RED将于币安TGE且上线binancelaunchpool!这也是币安第一次推出盘前交易涨停板的机制!首日限200%,3天后解禁,避免「开盘即巅峰」!Launchpool机制介绍参与Redstone的BinanceLaunchpool需要质押指定的代币(BNB、USDC、FDUSD)活动期限为48小时:2025年2月26日08:00UTC至2025年2月28日08:00UTC结束本次盘前涨停板规则:2025年02月28日18:00

一文详细了解传花旗银行将提供加密货币托管服务!下一步发行稳定币?一文详细了解传花旗银行将提供加密货币托管服务!下一步发行稳定币?Mar 04, 2025 am 10:42 AM

据《TheInformation》报道,美国第三大资产规模银行花旗集团正积极探索将加密货币托管服务融入其业务版图。据悉,花旗此举源于其2024年2月启动的一项试点项目,该项目成功展示了在区块链网络上发行和托管代币化私募股权基金的可行性。多家银行已获数字资产托管牌照目前,多家银行已获得不同国家/地区的数字资产托管服务资质,例如:纽约梅隆银行(BNYMellon)已获准提供除比特币和以太坊ETF外的数字资产托管服务;渣打银行(StandardChartered)在迪拜已搭建数字资产托管基础

See all articles

핫 AI 도구

Undresser.AI Undress

Undresser.AI Undress

사실적인 누드 사진을 만들기 위한 AI 기반 앱

AI Clothes Remover

AI Clothes Remover

사진에서 옷을 제거하는 온라인 AI 도구입니다.

Undress AI Tool

Undress AI Tool

무료로 이미지를 벗다

Clothoff.io

Clothoff.io

AI 옷 제거제

AI Hentai Generator

AI Hentai Generator

AI Hentai를 무료로 생성하십시오.

뜨거운 도구

안전한 시험 브라우저

안전한 시험 브라우저

안전한 시험 브라우저는 온라인 시험을 안전하게 치르기 위한 보안 브라우저 환경입니다. 이 소프트웨어는 모든 컴퓨터를 안전한 워크스테이션으로 바꿔줍니다. 이는 모든 유틸리티에 대한 액세스를 제어하고 학생들이 승인되지 않은 리소스를 사용하는 것을 방지합니다.

SublimeText3 Linux 새 버전

SublimeText3 Linux 새 버전

SublimeText3 Linux 최신 버전

SublimeText3 중국어 버전

SublimeText3 중국어 버전

중국어 버전, 사용하기 매우 쉽습니다.

메모장++7.3.1

메모장++7.3.1

사용하기 쉬운 무료 코드 편집기

SublimeText3 Mac 버전

SublimeText3 Mac 버전

신 수준의 코드 편집 소프트웨어(SublimeText3)