DisplayAdd1

TechnoTechDB is a platform, which will help to grow your carrier in Information sector. Having 15 years of Experience in Oracle/MongoDB/Postgres/Mysql databases, along with having good expertise level of knowledge in Scripting to automate database task. Our goal to start with zero to hero level expertise in Database. You can access/refer my some blogs on https://mrorcldba.blogspot.com link and post your comments and your suggestion to motive us.

Saturday, 23 January 2016

ORA-19563: header validation failed for file

Error : 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/18/2016 08:07:15
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database:
ORA-19563:  header validation failed for file

Cause :

This error may occurs during migration of database from NON-ASM to ASM/RAC using duplicate or restore database command.
because on NON-ASM environment database having on same name on different different mount points.

Soultion:

Check alerts log in target and get the file number/name for which throwing this error .

SELECT FILE#, NAME FROM V$DATAFILE where  NAME like '%system%';

FILE#           NAME
-----------      -------------
1                   /u01/orcl/datafile/system01.dbf
20                 /u02/orcl/datafile/system01.dbf

Rename the file ( /u02/orcl/datafile/system01.dbf) on primary database


set line 200
col file_name for a60
set pages 1000
select TABLESPACE_NAME,STATUS from dba_tablespaces where STATUS NOT IN ('ONLINE');
select TABLESPACE_NAME, FILE_NAME,STATUS from dba_data_files where FILE_NAME like '%system%';
ALTER TABLESPACE system OFFLINE;
cp  /u02/orcl/datafile/system01.dbf  /u02/orcl/datafile/system02.dbf
sqlplus / as sysdba
ALTER DATABASE RENAME FILE ' /u02/orcl/datafile/system01.dbf' TO '/u02/orcl/datafile/system01.dbf';
ALTER TABLESPACE system ONLINE;
select TABLESPACE_NAME,STATUS from dba_tablespaces where STATUS NOT IN ('ONLINE');

NOW try to  restore/duplicate database on ASM at target server.

rman  target sys/sys_pwd@orcl auxiliary  sys/sys_pwd@orcl_dev

run
{
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel C1 device type disk;
allocate auxiliary channel C2 device type disk;
allocate auxiliary channel C3 device type disk;
allocate auxiliary channel C4 device type disk;
allocate auxiliary channel C5 device type disk;
#duplicate target database for standby from active database;
#DUPLICATE TARGET DATABASE TO orcl_dev FROM ACTIVE DATABASE;
}




No comments:

Post a Comment

Steps to Rename Host in Oracle RESTART (ASM) in Linux

  oracle@localhost ] asmcmd ASMCMD> lsdg State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_...