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,
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!
|
|
|
|
|
|