ORA-19563: header validation failed for file-阿里云开发者社区

开发者社区> 数据库> 正文

ORA-19563: header validation failed for file

简介:

在测试服务器还原数据库时遇到了ORA-19563错误。如下所示

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch command at 04/08/2015 19:59:06
ORA-19563:  header validation failed for file 

clip_image001

[oracle@getlnx01 ~]$ oerr ora 19563
19563, 00000, "%s header validation failed for file %s"
// *Cause:  When opening the file to be placed in a copy or backup set,
//          to be inspected, or used as the target for
//          an incremental restore, its header was not
//          recognized as a valid file header for a file of the indicated
//          type (data file, archived log, or control file) belonging
//          to the current database.
// *Action: Ensure that the correct files are being specified for the copy
//          or backup operation.

通过分析后发现两个文件名冲突,原数据库有两个同名的文件invsubmat_d18.dbf位于不同分区。我还原时,由于测试服务器的空间不足,我将原路文件的恢复目录做了调整。(由于增加数据文件时粗心大意,自己给自己挖了一个大坑,而且自己跳了进去!)

clip_image002

如下所示,结果在/u04/oradata/epps目录下,出现了两个invsubmat_d19.dbf文件。只需在set命令里面将文件恢复路径修改即可。

run
{
.................................................................
set newname for datafile 105    to "/u04/oradata/epps/invsubmat_d18.dbf";
.................................................................
set newname for datafile 109    to  "/u04/oradata/epps/invsubmat_d18.dbf";
set newname for datafile 121    to  "/u04/oradata/epps/ndotbs03.dbf";
set newname for datafile 122    to  "/u04/oradata/epps/undotbs04.dbf";
restore database ;
switch datafile all;
}

修改为如下所示,restore还原成功!

run
{
.................................................................
set newname for datafile 105    to "/u04/oradata/epps/invsubmat_d18.dbf";
.................................................................
set newname for datafile 109    to  "/u04/oradata/epps/invsubmat_d20.dbf";
set newname for datafile 121    to  "/u04/oradata/epps/ndotbs03.dbf";
set newname for datafile 122    to  "/u04/oradata/epps/undotbs04.dbf";
restore database ;
switch datafile all;
}

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章