搜索
首页数据库mysql教程rman备份archivelog出现ORA-19625
rman备份archivelog出现ORA-19625
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Jun 07, 2016 pm 04:48 PM

rman备份archivelog时出现以下错误： RMANgt; backup archivelog all delete input; Starting backup at 14-APR-14 current log

rman备份archivelog时出现以下错误：

RMAN> backup archivelog all delete input;

Starting backup at 14-APR-14

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 04/14/2014 18:40:23

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
 
ORA-19625: error identifying file /home/Oracle/PROD/1_2_844469007.dbf

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

--------------------------------------分割线 --------------------------------------

推荐阅读：

RMAN 配置归档日志删除策略

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密

--------------------------------------分割线 --------------------------------------

网上查了出错原因是由于操作系统下删除了这个归档日志，这个日志还没备份过，rman去备份的时候，找不到这个归档就出错了。可使用change archivelog all crosscheck命令来解决此问题，如下：
 
RMAN> change archivelog all crosscheck;

released channel: ORA_DISK_1

released channel: ORA_DISK_2

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=43 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=45 device type=DISK

validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_16_827176743.dbf RECID=1 STAMP=844399662
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_17_827176743.dbf RECID=2 STAMP=844460245
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_18_827176743.dbf RECID=3 STAMP=844461320
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_19_827176743.dbf RECID=4 STAMP=844461426
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_20_827176743.dbf RECID=5 STAMP=844461580
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_21_827176743.dbf RECID=6 STAMP=844461592
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_22_827176743.dbf RECID=7 STAMP=844461696
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_23_827176743.dbf RECID=8 STAMP=844462037
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_24_827176743.dbf RECID=9 STAMP=844462165
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_25_827176743.dbf RECID=10 STAMP=844462279
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_26_827176743.dbf RECID=11 STAMP=844462409
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_27_827176743.dbf RECID=12 STAMP=844465108
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_28_827176743.dbf RECID=13 STAMP=844469010
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=19 STAMP=844537684
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=17 STAMP=844533553
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_3_844532679.dbf RECID=20 STAMP=844537685
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_4_844532679.dbf RECID=18 STAMP=844537684
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=23 STAMP=844605032
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=21 STAMP=844575254
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=24 STAMP=844605033
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=22 STAMP=844581004
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_3_844537684.dbf RECID=25 STAMP=844605034
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844469007.dbf RECID=14 STAMP=844530587
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_1_844605031.dbf RECID=26 STAMP=844670045
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_2_844605031.dbf RECID=27 STAMP=844797748
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_3_844605031.dbf RECID=28 STAMP=844841532
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_4_844605031.dbf RECID=29 STAMP=844847317
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_5_844605031.dbf RECID=30 STAMP=844855807
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_6_844605031.dbf RECID=31 STAMP=844855838
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_7_844605031.dbf RECID=32 STAMP=844886422
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_8_844605031.dbf RECID=33 STAMP=844886590
 
validation succeeded for archived log

archived log file name=/home/oracle/PROD/1_9_844605031.dbf RECID=34 STAMP=844886622
 
Crosschecked 33 objects

 

validation failed for archived log

archived log file name=/home/oracle/PROD/1_2_844469007.dbf RECID=15 STAMP=844530793
 
Crosschecked 1 objects

--再次执行archivelog的rman备份就成功了，如下：

RMAN> backup archivelog all delete input;

 

Starting backup at 14-APR-14

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=16 RECID=1 STAMP=844399662

input archived log thread=1 sequence=17 RECID=2 STAMP=844460245

input archived log thread=1 sequence=18 RECID=3 STAMP=844461320

channel ORA_DISK_1: starting piece 1 at 14-APR-14

channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=1 RECID=16 STAMP=844533450

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_2: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1bp5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02

channel ORA_DISK_2: deleting archived log(s)

archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
 
channel ORA_DISK_2: starting compressed archived log backup set

channel ORA_DISK_2: specifying archived log(s) in backup set

input archived log thread=1 sequence=19 RECID=4 STAMP=844461426

input archived log thread=1 sequence=20 RECID=5 STAMP=844461580

input archived log thread=1 sequence=21 RECID=6 STAMP=844461592

input archived log thread=1 sequence=22 RECID=7 STAMP=844461696

input archived log thread=1 sequence=23 RECID=8 STAMP=844462037

input archived log thread=1 sequence=24 RECID=9 STAMP=844462165

input archived log thread=1 sequence=25 RECID=10 STAMP=844462279

channel ORA_DISK_2: starting piece 1 at 14-APR-14

channel ORA_DISK_1: finished piece 1 at 14-APR-14

piece handle=/home/oracle/backup/PROD_20140414_1ap5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

channel ORA_DISK_1: deleting archived log(s)

声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
相关文章
如何使用Alter Table语句在MySQL中更改表？如何使用Alter Table语句在MySQL中更改表？Mar 19, 2025 pm 03:51 PM

本文讨论了使用MySQL的Alter Table语句修改表，包括添加/删除列，重命名表/列以及更改列数据类型。

如何为MySQL连接配置SSL/TLS加密？如何为MySQL连接配置SSL/TLS加密？Mar 18, 2025 pm 12:01 PM

文章讨论了为MySQL配置SSL/TLS加密，包括证书生成和验证。主要问题是使用自签名证书的安全含义。[角色计数：159]

您如何处理MySQL中的大型数据集？您如何处理MySQL中的大型数据集？Mar 21, 2025 pm 12:15 PM

文章讨论了处理MySQL中大型数据集的策略，包括分区，碎片，索引和查询优化。

哪些流行的MySQL GUI工具（例如MySQL Workbench，PhpMyAdmin）是什么？哪些流行的MySQL GUI工具（例如MySQL Workbench，PhpMyAdmin）是什么？Mar 21, 2025 pm 06:28 PM

文章讨论了流行的MySQL GUI工具，例如MySQL Workbench和PhpMyAdmin，比较了它们对初学者和高级用户的功能和适合性。[159个字符]

如何使用Drop Table语句将表放入MySQL中？如何使用Drop Table语句将表放入MySQL中？Mar 19, 2025 pm 03:52 PM

本文讨论了使用Drop Table语句在MySQL中放下表，并强调了预防措施和风险。它强调，没有备份，该动作是不可逆转的，详细介绍了恢复方法和潜在的生产环境危害。

您如何用外国钥匙代表关系？您如何用外国钥匙代表关系？Mar 19, 2025 pm 03:48 PM

文章讨论了使用外国密钥来代表数据库中的关系，重点是最佳实践，数据完整性和避免的常见陷阱。

如何在JSON列上创建索引？如何在JSON列上创建索引？Mar 21, 2025 pm 12:13 PM

本文讨论了在PostgreSQL，MySQL和MongoDB等各个数据库中的JSON列上创建索引，以增强查询性能。它解释了索引特定的JSON路径的语法和好处，并列出了支持的数据库系统。

如何保护MySQL免受常见漏洞（SQL注入，蛮力攻击）？如何保护MySQL免受常见漏洞（SQL注入，蛮力攻击）？Mar 18, 2025 pm 12:00 PM

文章讨论了使用准备好的语句，输入验证和强密码策略确保针对SQL注入和蛮力攻击的MySQL。（159个字符）

See all articles

热AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智能驱动的应用程序，用于创建逼真的裸体照片

AI Clothes Remover

AI Clothes Remover

用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool

Undress AI Tool

免费脱衣服图片

Clothoff.io

Clothoff.io

AI脱衣机

AI Hentai Generator

AI Hentai Generator

免费生成ai无尽的。

显示更多

热门文章

R.E.P.O.能量晶体解释及其做什么（黄色晶体）
3 周前By尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳图形设置
3 周前By尊渡假赌尊渡假赌尊渡假赌
刺客信条阴影：贝壳谜语解决方案
1 周前ByDDD
R.E.P.O.如果您听不到任何人，如何修复音频
3 周前By尊渡假赌尊渡假赌尊渡假赌
在哪里可以找到原子中的起重机控制钥匙卡
1 周前ByDDD
显示更多

热工具

Atom编辑器mac版下载

Atom编辑器mac版下载

最流行的的开源编辑器

Dreamweaver Mac版

Dreamweaver Mac版

视觉化网页开发工具

安全考试浏览器

安全考试浏览器

Safe Exam Browser是一个安全的浏览器环境，用于安全地进行在线考试。该软件将任何计算机变成一个安全的工作站。它控制对任何实用工具的访问，并防止学生使用未经授权的资源。

DVWA

DVWA

Damn Vulnerable Web App (DVWA) 是一个PHP/MySQL的Web应用程序，非常容易受到攻击。它的主要目标是成为安全专业人员在合法环境中测试自己的技能和工具的辅助工具，帮助Web开发人员更好地理解保护Web应用程序的过程，并帮助教师/学生在课堂环境中教授/学习Web应用程序安全。DVWA的目标是通过简单直接的界面练习一些最常见的Web漏洞，难度各不相同。请注意，该软件中

mPDF

mPDF

mPDF是一个PHP库，可以从UTF-8编码的HTML生成PDF文件。原作者Ian Back编写mPDF以从他的网站上“即时”输出PDF文件，并处理不同的语言。与原始脚本如HTML2FPDF相比，它的速度较慢，并且在使用Unicode字体时生成的文件较大，但支持CSS样式等，并进行了大量增强。支持几乎所有语言，包括RTL（阿拉伯语和希伯来语）和CJK（中日韩）。支持嵌套的块级元素（如P、DIV），

显示更多

热门话题

gmail邮箱登陆入口在哪里
7416
15
CakePHP 教程
1359
52
steam的账户名称是什么格式
76
11
win11激活密钥永久
26
19
显示更多