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.

RMAN>

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

RMAN>
Solution:

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

rman> SWITCH DATAFILE ALL;

 

 

 

 

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. 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