No question at this time
DBA Top 10
1 A. Kavsek 10900
2 M. Cadot 6200
3 P. Wisse 5000
4 B. Vroman 4500
5 T. Boles 2200
6 . Lauri 2000
7 J. Schnackenberg 1300
8 J. PĂ©ran 1100
9 R. Pattyn 700
10 T. P 500
10 G. Graham 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48425
Total active users1512
Act. users last 24h8
Act. users last hour2
Registered user hits last week172
Registered user hits last month818
Go up

Invalid header when restoring datafiles using RMAN
Next thread: How to show non-existing record from an in clause
Prev thread: user connect hung at sql prompt

Message Score Author Date
Hi, I am perfoming a restore (and a recovery) o...... Lauri Jun 22, 2019, 14:00
Hello Lauri, maybe this can help: MOS Doc ID 45...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Bruno Vroman Jun 23, 2019, 12:35
Hi Bruno, Thanks for the answer. In the meanti...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Lauri Jun 26, 2019, 18:25
Great! thanks for the explanation. Best regards,...... Bruno Vroman Jun 27, 2019, 08:34

Follow up by mail Click here


Subject: Invalid header when restoring datafiles using RMAN
Author: Lauri, Netherlands
Date: Jun 22, 2019, 14:00, 89 days ago
Os info: OEL 7.6
Oracle info: 12c
Error info: RMAN-03002, ORA-19563
Message: Hi,

I am perfoming a 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 that peice of RMAN code:

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
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Invalid header when restoring datafiles using RMAN
Author: Bruno Vroman, Belgium
Date: Jun 23, 2019, 12:35, 89 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello Lauri,

maybe this can help: MOS Doc ID 453123.1: RMAN Duplicate Fails With RMAN-06136 ORA-19563
(or other entries, there are several apparently interesting pointers when searching the web with ORA 19563)

HTH,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Invalid header when restoring datafiles using RMAN
Author: Lauri, Netherlands
Date: Jun 26, 2019, 18:25, 85 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Bruno,

Thanks for the answer.
In the meantime, I have found what the problem was.
I am provided with the RMAN backup, the name or SID of the database, and that the backup makes use of the FRA.
After investigation, by restoring the original spfile and controlfile, I found out that the database was a container database.
That means that there are sub-directories defined for each PDB.
The Bash shell script I had didn't take this feature in consideration.
Each PDB as well as the ROOT have for instance their own SYSTEM tablespace, with the same name, but at a different location.
In my situation they were all written in the same location, so "overlapping" each other, and hence that error message.
I created manually the sub-directories for each PDB, and re-created accordingly the RMAN restore and recover script.
The restore and recover worked successfully.

Kind Regards,

Lauri
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Invalid header when restoring datafiles using RMAN
Author: Bruno Vroman, Belgium
Date: Jun 27, 2019, 08:34, 85 days ago
Message: Great!
thanks for the explanation.
Best regards,
Bruno
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here