ORA-19563: header validation failed for file RMAN

 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.

Comments

Post a Comment

Popular posts from this blog

Step by step Oracle Apex 20.1 / 21.1 installation on Windows and Unix/Linux systems.

  Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Here are the step by step instructions to install Oracle Apex 20.1 on Windows and Unix/Linux systems.  Oracle Apex Installation Requirements Oracle Application Express release 20.1 requires  an Oracle Database release 18c or later, OS Windows 10 / Linux  There are the steps to install Oracle Application Express release 20.1. Step 1 Download Apex To download Oracle Application Express release 20.1, go to following link: https://www.oracle.com/tools/downloads/apex-201-downloads.html Step 2. Unzip in desired location  After downloading, you will get a zip file named something like - apex_20.1. Copy the file from the default download folder and paste it to the folder in which you want to install Oracle Apex 20.1, for example, I moved this file to F:\oracle\apex20, and after extracting the file, I got the
Read more

ORA-01172: recovery of thread 1 stuck at block 3024 of file 19

  ERROR :  SQL> startup ORACLE instance started. Total System Global Area 2.1475E+10 bytes Fixed Size                 12170960 bytes Variable Size            3019901232 bytes Database Buffers         1.8388E+10 bytes Redo Buffers               54935552 bytes Database mounted. ORA-01172: recovery of thread 1 stuck at block 3024 of file 19 ORA-01151: use media recovery to recover block, restore backup if needed Cause:  This error usually means that blocks of file 19 are corrupted, In this case we need to recover file 19. Crash recovery or instance recovery could not apply a change to a block because it was not the next change.  This can happen if the block was corrupted and then repaired during recovery. SOLUTION :-  We need to recover all of corrupted block by using data file recovery or Database recovery.  In my case I have recover datafile 19. SQL>  recover datafile 19; Media recovery complete. SQL> alter database open; Database altered. SQL> select name,OPEN_MODE from v$d
Read more