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



3 comments:

  1. A true friend is one who overlooks your failures and tolerates your success! See the link below for more info.


    #failures
    www.ufgop.org

    ReplyDelete
  2. A true friend is one who overlooks your failures and tolerates your success! See the link below for more info.


    #failures
    www.ufgop.org

    ReplyDelete
  3. I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


    edupdf.org

    ReplyDelete

Number of Visitors