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-06512: at "SYS.DBMS_ISCHED"

Database -  Oracle Database 23AI Cause:   An attempt was made to perform a scheduler operation without the required privileges. Action:  Ask...