Database Backup and Recovery (MOSC)

MOSC Banner

RMAN restore failed in "switch datafile all;" with RMAN-03002, ORA-19563: header validation failed

edited Aug 4, 2010 3:11AM in Database Backup and Recovery (MOSC) 8 commentsAnswered
Hello:

It is a production restore(cloning) by RMAN to another box; keep same DB name; disk structure is different.

It is done yesterday (July 27th morning), with July 26 level-1 incremental backup, July 25 level-0 (full backup).  The restore script:


RMAN> run {
2> set newname for datafile 1 to '/orabackupCR/system01.dbf
3> ';
4> set newname for datafile 2 to '/orabackupCR/undotbs01.dbf';
5> set newname for datafile 3 to '/orabackupCR/sysaux01.dbf';
6> set newname for datafile 4 to '/orabackupCR/users01.dbf';
7> set newname for datafile 5 to '/orabackupCR/scrmprd_index01.dbf';
8> set newname for datafile 6 to '/orabackupCR/scrmprd_data01.dbf';
9> set newname for datafile 7 to '/orabackupCR/scrmprd_data02.dbf';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center