datafilecopy header validation failure for file +DATA
This issue happens due to file move from file system to ASM via sqlplus
The renaming of the datafiles was done via SQL Plus and NOT
via RMAN with SWITCH command
Error message looks like "datafilecopy header validation failure for file +DATA"
Solution :
During RMAN COPY command to move
datafiles to a new location (ASM or otherwise), do NOT rename the file via
SQLPlus but use the RMAN SWITCH command instead (SWITCH DATAFILE ALL).
Check the alertlog for the message
alter database rename file '/u01user01.dbf to '+DATA’;
If SQLPlus has already been used to rename the files the rman metadata can be
corrected as follows:
1. Check name of the current datafiles:
RMAN>report schema;
2. Confirm the name of the datafile copies (this will show the SAME list of
datafiles):
RMAN>list copy of database;
3. Remove the datafilecopy entries from the rman repository (this will NOT
remove the physical
files but simply update the rman repository):
RMAN>change datafilecopy uncatalog;
You can get value from the list copy of database output - do this
for every datafile
that is 'duplicated' in the list copy output.
4. Confirm that the copies have been removed:
RMAN>list copy of database;
