RMAN-03002: failure of switch command

Rman restored successfully completed but at the end there is a switch statement which got failed.

rman last few lines which shows it is successfully restored.


channel ORA_DISK_2: reading from backup piece /orarman2/drrmanbackup/part2/rman2jofj96j_1_1

channel ORA_DISK_5: restored backup piece 1
piece handle=/orarman2/drrmanbackup/rman29ofj5er_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_5: restore complete, elapsed time: 00:39:59
channel ORA_DISK_4: restored backup piece 1
piece handle=/orarman2/drrmanbackup/part2/rman2aofj68k_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_4: restore complete, elapsed time: 00:40:24
channel ORA_DISK_3: restored backup piece 1
piece handle=/orarman2/drrmanbackup/rman2cofj6nl_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_3: restore complete, elapsed time: 00:41:45
channel ORA_DISK_6: restored backup piece 1
piece handle=/orarman2/drrmanbackup/part2/rman2iofj8o2_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_6: restore complete, elapsed time: 00:15:09
channel ORA_DISK_2: restored backup piece 1
piece handle=/orarman2/drrmanbackup/part2/rman2jofj96j_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_2: restore complete, elapsed time: 00:15:58
channel ORA_DISK_7: restored backup piece 1
piece handle=/orarman2/drrmanbackup/part2/rman2eofj7ir_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_7: restore complete, elapsed time: 00:32:26
channel ORA_DISK_1: restored backup piece 1
piece handle=/orarman2/drrmanbackup/rman2fofj82v_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_1: restore complete, elapsed time: 00:24:50
channel ORA_DISK_8: restored backup piece 1
piece handle=/orarman2/drrmanbackup/part3/rman2hofj8ml_1_1 tag=FULL_DATABASE_OPEN
channel ORA_DISK_8: restore complete, elapsed time: 00:23:39
Finished restore at 25-JUL-13

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch command at 07/25/2013 18:36:54
ORA-19563: header validation failed for file


switch datafile <datafile number> to copy;

I executed the above for all datafiles whos path was different and is resolved the error.

or one command for all is






About Sher khan

Senior Oracle DBA, Oracle 10g and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in rman. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s