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)
duplicate error due to different db_recovery_file_dest between target database and auxiliary databas [message #654774] Fri, 12 August 2016 05:29 Go to next message
juniordbanewbie
Messages: 169
Registered: April 2014
Senior Member
Dear all,


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!
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 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
What is your DUPLICATE command?
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 Go to previous messageGo to next message
juniordbanewbie
Messages: 169
Registered: April 2014
Senior Member

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!
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 Go to previous message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
You may need to add a BACKUP LOCATION clause.
Previous Topic: rman snapshot controlfile
Next Topic: rman backup
Goto Forum:
  


Current Time: Thu Nov 23 21:46:56 CST 2017

Total time taken to generate the page: 0.20116 seconds