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;
}
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