OraFAQ Forum: Backup & Recovery » duplicate error due to different db_recovery_file_dest between target database and auxiliary databas

Home » RDBMS Server » Backup & Recovery » duplicate error due to different db_recovery_file_dest between target database and auxiliary databas (11.2.0.4.160419 , windows 2012r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

duplicate error due to different db_recovery_file_dest between target database and auxiliary databas [message #654774]

Fri, 12 August 2016 05:29

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear all,

Code: [Select all] [Show/ hide]

channel aux1: starting datafile backup set restore
channel aux1: specifying datafile(s) to restore from backup set
channel aux1: restoring datafile 00001 to D:\APP\ORACLE\ORADATA\ZORCL\SYSTEM01.DBF
channel aux1: restoring datafile 00002 to D:\APP\ORACLE\ORADATA\ZORCL\SYSAUX01.DBF
channel aux1: restoring datafile 00003 to D:\APP\ORACLE\ORADATA\ZORCL\UNDOTBS01.DBF
channel aux1: restoring datafile 00004 to D:\APP\ORACLE\ORADATA\ZORCL\USERS01.DBF
channel aux1: restoring datafile 00005 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\UA_001.DBF
channel aux1: restoring datafile 00006 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\NFM_001.DBF
channel aux1: restoring datafile 00007 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\STOCKS_001.DBF
channel aux1: restoring datafile 00008 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\EVENT_001.DBF
channel aux1: restoring datafile 00009 to J:\APP\ORACLE\ORADATA\ZORCL\MAS_001.DBF
channel aux1: restoring datafile 00010 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPACE_001.DBF
channel aux1: restoring datafile 00011 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPACE_STAT_001.DBF
channel aux1: restoring datafile 00012 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\QRADMIN_001.DBF
channel aux1: restoring datafile 00013 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPACE_SEARCH_001.DBF
channel aux1: restoring datafile 00014 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\WIP_001.DBF
channel aux1: restoring datafile 00015 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPISEPP_001.DBF
channel aux1: restoring datafile 00016 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPACE_DB_001.DBF
channel aux1: restoring datafile 00017 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SEC_CONFIG_001.DBF
channel aux1: restoring datafile 00018 to D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPACE_002.DBF
channel aux1: restoring datafile 00019 to D:\APP\ORACLE\ORADATA\ZORCL\SYSTEM02.DBF
channel aux1: reading from backup piece D:\APP\ORACLE\FAST_RECOVERY_AREA\ZORCLDV\BACKUPSET\2016_08_11\O1_MF_NNND0_EORCLDV_20160812_INC_CTTF21OX_.BKP
channel aux1: ORA-19870: error while restoring backup piece D:\APP\ORACLE\FAST_RECOVERY_AREA\ZORCLDV\BACKUPSET\2016_08_11\O1_MF_NNND0_EORCLDV_20160812_INC_CTTF21OX_.BKP
ORA-19505: failed to identify file "D:\APP\ORACLE\FAST_RECOVERY_AREA\ZORCLDV\BACKUPSET\2016_08_11\O1_MF_NNND0_EORCLDV_20160812_INC_CTTF21OX_.BKP"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified
failover to previous backup

the above error occurs because in the source database's db_recovery_file_Dest =D:\APP\ORACLE\FAST_RECOVERY_AREA while the destination database (auxiliary database) is P:\APP\ORACLE\FAST_RECOVERY_AREA, so how do I resolve the above error?

many many thanks in advance!

Report message to a moderator

Re: duplicate error due to different db_recovery_file_dest between target database and auxiliary databas [message #654775 is a reply to message #654774]

Fri, 12 August 2016 05:39

John Watson
Messages: 8977
Registered: January 2010
Location: Global Village

Senior Member

What is your DUPLICATE command?

Report message to a moderator

Re: duplicate error due to different db_recovery_file_dest between target database and auxiliary databas [message #654776 is a reply to message #654775]

Fri, 12 August 2016 06:00

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Code: [Select all] [Show/ hide]

RMAN> SET ECHO ON
2> 
3> run{
4> ALLOCATE AUXILIARY CHANNEL aux1 type DISK;
5> duplicate target database TO 'zorcl'
6> NOFILENAMECHECK
7> DB_FILE_NAME_CONVERT=('D:\app\oracle\oradata\product\11.2.0\dbhome_1\database\MAS_001.DBF','J:\app\oracle\oradata\zorcl\MAS_001.DBF',
8> 'D:\app\oracle\oradata\oradata\eorcldv', 'D:\app\oracle\oradata\zorcl',
9> 'D:\APP\ORACLE\ORADATA\PRODUCT\11.2.0\DBHOME_1\DATABASE', 'D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE');
10> }
11> 
12> EXIT
echo set on

many thanks in advance!

Report message to a moderator

Re: duplicate error due to different db_recovery_file_dest between target database and auxiliary databas [message #654778 is a reply to message #654776]

Fri, 12 August 2016 06:08

John Watson
Messages: 8977
Registered: January 2010
Location: Global Village

Senior Member

You may need to add a BACKUP LOCATION clause.

Report message to a moderator

Previous Topic:	rman snapshot controlfile
Next Topic:	rman backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 09:51:22 CDT 2025