Sunday, 21 December 2014

RMAN-03002: failure of switch command at ORA-19563: header validation failed for file

Solution:
I used below query to fix the path for the restored files, as path was wrong for some datafiles
select 'set newname for datafile '||file#||' to  ''/u01/oradata/jblprov/'|| SUBSTR (NAME, INSTR (NAME, '/', -1) + 1)||''';' from v$datafile order by 1



No comments:

Post a Comment

Number of Visitors