Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid header when restoring datafiles using RMAN

LauryJun 22 2019 — edited Jun 26 2019

Hi,

I am trying to restore (and a recovery) of a database to another server.

The backup is copied from the source server to the target server.

I restored the spfile and controlfile to a different location.

The backup files have been registered with the RMAN catalog command.

The target database is nouw in the MOUNT mode.

I try to restore the datafiles with a peice of RMAN code that looks like:

connect target /                                                                                                                                         

run {                                                                                                                                                    

# Rename files                                                                                                                                           

set newname for datafile '/u02/oracle/data/ASGARD/system01.dbf' to '/u01/oracle/data/ASGARD/system01.dbf';                                               

set newname for datafile '/u02/oracle/data/ASGARD/sysaux01.dbf' to '/u01/oracle/data/ASGARD/sysaux01.dbf';                                               

... 

restore database;

switch datafile all;

}                                                                                                                                                        

But I end up with this eror:

RMAN-03002: failure of switch command at 06/22/2019 13:52:29

ORA-19563: Inspect Datafile Copy: SCN number validation unsuccessful header validation failed for file /u01/oracle/data/ASGARD/system01.dbf

Does someone has any if this is an isue related on the source or target server?

Kind Regards

This post has been answered by Laury on Jun 26 2019
Jump to Answer
Comments
Post Details
Added on Jun 22 2019
3 comments
2,361 views