我的编程空间,编程开发者的网络收藏夹
学习永远不晚

ORA-19625: error identifying file

短信预约 信息系统项目管理师 报名、考试、查分时间动态提醒
省份

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号立即预约

请填写图片验证码后获取短信验证码

看不清楚,换张图片

免费获取短信验证码

ORA-19625: error identifying file

问题描述:rman进行备份的时候,出现报错ORA-19625,无效的文件

进行数据库备份,然后就出现了报错,没有这个24号的归档日志

RMAN> run{

2> allocate channel ch_1 type disk;

3> allocate channel ch_2 type disk;

4> backup database format "/u01/app/oracle/oradata/Backup/database_%t_%u_%c.bak";

5> backup archivelog all format "/u01/app/oracle/oradata/Backup/archive_%t_%u_%c.bak";

6> }

 

 

想起来之前是做SCN增量备份的时候,把24号归档就不知道是删除了还是mv到哪了,反正就是丢了,这个其它文档交代的很清楚,操作系统删除了这个归档日志,但是还没备份过,找不到归档就出错了。然后就执行以下命令,发现了failed for archived log

RMAN> change archivelog all crosscheck;       (物理上删除了归档,但是控制文件不知道,需要交叉同步消息

 

 

 

 

 

 

 3.一开始不知道直接以为执行change archivelog all crosscheck; 告诉控制文件这个归档已经不行了,找不到了,就可以了。然后就进行备份,在我本地的备份路径上所有东西都是ok的,但是rman备份的时候发现24号归档还是被备份进去了,这里没有来的及截图,下边可以备份到完整的bak

RMAN> run{

2> allocate channel ch_1 type disk;

3> allocate channel ch_2 type disk;

4> backup database format "/u01/app/oracle/oradata/Backup/database_%t_%u_%c.bak";

5> backup archivelog all format "/u01/app/oracle/oradata/Backup/archive_%t_%u_%c.bak";

6> }

 

 

 

这里就牵扯到另外一条命令:delete expired archivelog all;   这条命令才是同步控制文件和实际物理文件的信息的,之前的change archivelog all crosscheck; 是比较一下控制文件和物理文件的差别的,所以我又把备份文件全都删除,重新备了一遍

删除备份

delete expired archivelog all;  同步信息

重新rman备份

 

 

 

 5.完成

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

ORA-19625: error identifying file

下载Word文档到电脑,方便收藏和打印~

下载Word文档

猜你喜欢

ORA-19625: error identifying file

问题描述:rman进行备份的时候,出现报错ORA-19625,无效的文件1.进行数据库备份,然后就出现了报错,没有这个24号的归档日志RMAN> run{2> allocate channel ch_1 type disk;3> allocate channe
ORA-19625: error identifying file
2019-04-28

ORA-19625: error identifying file string ORACLE 报错 故障修复 远程处理

文档解释ORA-19625: error identifying file stringCause: A file specified as input to a copy or backup operation, or as the
ORA-19625: error identifying file string ORACLE 报错 故障修复 远程处理
2023-11-04

ORA-09202: sfifi: error identifying file ORACLE 报错 故障修复 远程处理

文档解释ORA-09202: sfifi: error identifying fileCause: db_block_size specified in init.ora could be incorrectAction: See
ORA-09202: sfifi: error identifying file ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-01585: error identifying backup file string ORACLE 报错 故障修复 远程处理

文档解释ORA-01585: error identifying backup file stringCause: An operating system error occurred when attempting to
ORA-01585: error identifying backup file string ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-00205: error in identifying control file, check alert log for more info ORACLE 报错 故障修复 远程处理

文档解释ORA-00205: error in identifying control file, check alert log for more infoCause: The system could not find a
ORA-00205: error in identifying control file, check alert log for more info ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-00234: error in identifying or opening snapshot or copy control file ORACLE 报错 故障修复 远程处理

文档解释ORA-00234: error in identifying or opening snapshot or copy control fileCause: A snapshot or copy control file of
ORA-00234: error in identifying or opening snapshot or copy control file ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-31609: error loading file “string” from file system directory “string” O

文档解释ORA-31609: error loading file string from file system directory stringCause: The installation script
ORA-31609: error loading file “string” from file system directory “string” O
2023-11-05

ORA-48166: error with opening ADR block file because file does not exist [string] [string] ORACLE 报错

文档解释ORA-48166: error with opening ADR block file because file does not exist [string] [string]Cause: An error was
ORA-48166: error with opening ADR block file because file does not exist [string] [string] ORACLE 报错
2023-11-05

ORA-01294: error occurred while processing information in dictionary file string, possible corruptio

文档解释ORA-01294: error occurred while processing information in dictionary file string, possible corruptionCause: The
ORA-01294: error occurred while processing information in dictionary file string, possible corruptio
2023-11-04

ORA-27040: file create error, unable to create file ORACLE 报错 故障修复 远程处理

文档解释ORA-27040: file create error, unable to create fileCause: create system call returned an error, unable to create
ORA-27040: file create error, unable to create file ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-01301: error writing to file during flat file build ORACLE 报错 故障修复 远程处理

文档解释ORA-01301: error writing to file during flat file buildCause: Error writing to file during flat file buildAction:
ORA-01301: error writing to file during flat file build ORACLE 报错 故障修复 远程处理
2023-11-04

ORA-48178: error encountered while reading an ADR block file during ADR initialization [string] ORAC

文档解释ORA-48178: error encountered while reading an ADR block file during ADR initialization [string]Cause: An error was
ORA-48178: error encountered while reading an ADR block file during ADR initialization [string] ORAC
2023-11-05

ORA-07230: slemcr: fopen error, unable to open error file. ORACLE 报错 故障修复 远程处理

文档解释ORA-07230: slemcr: fopen error, unable to open error file.Cause: Fopen failed to open file.Action: Try to determine
ORA-07230: slemcr: fopen error, unable to open error file. ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-19502: write error on file “string”, block number string (block size=string) ORACLE

文档解释ORA-19502: write error on file string, block number string (block size=string)Cause: write error on output
ORA-19502: write error on file “string”, block number string (block size=string) ORACLE
2023-11-05

ORA-29284: file read error ORACLE 报错 故障修复 远程处理

文档解释ORA-29284: file read errorCause: An attempt to read from a file failed.Action: Verify that the file exists, and
ORA-29284: file read error ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-29285: file write error ORACLE 报错 故障修复 远程处理

文档解释ORA-29285: file write errorCause: Failed to write to, flush, or close a file.Action: Verify that the file exists,
ORA-29285: file write error ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-09791: slembdf: translation error, unable to translate error file name. ORACLE 报错 故障修复 远程处理

文档解释ORA-09791: slembdf: translation error, unable to translate error file name.Cause: Additional information indicates
ORA-09791: slembdf: translation error, unable to translate error file name. ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-07242: slembfn: translation error, unable to translate error file name. ORACLE 报错 故障修复 远程处理

文档解释ORA-07242: slembfn: translation error, unable to translate error file name.Cause: Additional information indicates
ORA-07242: slembfn: translation error, unable to translate error file name. ORACLE 报错 故障修复 远程处理
2023-11-05

ORA-02362: error closing file: string ORACLE 报错 故障修复 远程处理

文档解释ORA-02362: error closing file: stringCause: An attempt to close the specified file for data export/import
ORA-02362: error closing file: string ORACLE 报错 故障修复 远程处理
2023-11-04

编程热搜

目录