ORA-19563: header validation failed for file

Encountered while restoring the server on test database.

Restore log file :-

Finished restore at 03-MAR-22

released channel: c1

released channel: c2

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

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

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

RMAN-03002: failure of switch command at 03/03/2022 22:58:55

ORA-19563:  header validation failed for file

RMAN>


CAUSE :-

Check alerts log in target and get the file number/name for which throwing this error .

SQL > SELECT FILE#, NAME FROM V$DATAFILE where  NAME like '%system%';

FILE#           NAME

-----------      -------------

 92            /u01/test/db/apps_st/data/system17.dbf

 139          /u01/test/db/apps_st/data/system17.dbf


Solution :-

Rename the file like (system17.dbf to system18.dbf)

SQL > SELECT FILE#, NAME FROM V$DATAFILE where  NAME like '%system%';

FILE#           NAME

-----------      -------------

 92            /u01/test/db/apps_st/data/system17.dbf

 139          /u01/test/db/apps_st/data/system18.dbf


NOW try to  restore again.

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...