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:
Post a Comment