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:

SHRD0014: GLLEZL - process exiting with failure

  SYMPTOMS Journal Import completes with the following error: Error ------ ORA-01653 : unable to extend table GL.GL_IMPORT_REFERENCES ORA-01...