Duplicated 10.2 database from Windows to Linux
209473May 27 2010 — edited May 28 2010Hi,
I am trying to duplicate a database with rman. The messages I get from the duplicate command show strange directories paths which are not what I want.
For example E:\U01\APP\ORACLE\ORADATA\DEV2\SYSTEM_01.DBF should be /u01/app/oracle/oradata/DEV2/system_01.dbf
the next one does not even make sense
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/db_1/dbs/F:OR
ADATADEV1BACKUPORA_DF720031421_S4_S1"
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\U01\APP\ORACLE\ORADATA\DEV2\SYSTEM_01.DBF
restoring datafile 00003 to E:\U01\APP\ORACLE\ORADATA\DEV2\SYSAUX_01.DBF
restoring datafile 00005 to E:\U01\APP\ORACLE\ORADATA\DEV2\STRMADMIN_01.DBF
channel ORA_AUX_DISK_1: reading from backup piece F:\ORADATA\DEV1\BACKUP\ORA_DF7
20031421_S4_S1
channel ORA_AUX_DISK_2: starting datafile backupset restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00002 to E:\U01\APP\ORACLE\ORADATA\DEV2\UNDOTBS_01.DBF
restoring datafile 00004 to E:\U01\APP\ORACLE\ORADATA\DEV2\INFORM_01.DBF
restoring datafile 00006 to E:\U01\APP\ORACLE\ORADATA\DEV2\TOOLS_01.DBF
channel ORA_AUX_DISK_2: reading from backup piece F:\ORADATA\DEV1\BACKUP\ORA_DF7
20031421_S3_S1
ORA-19870: error reading backup piece */u01/app/oracle/product/10.2.0/db_1/dbs/F:*
ORADATADEV1BACKUPORA_DF720031421_S4_S1
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/db_1/dbs/F:OR
ADATADEV1BACKUPORA_DF720031421_S4_S1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /u01/app/oracle/product/10.2.0/db_1/dbs/F:
ORADATADEV1BACKUPORA_DF720031421_S3_S1
ORA-19505: failed to identify file "/u01/app/oracle/product/10.2.0/db_1/dbs/F:OR
ADATADEV1BACKUPORA_DF720031421_S3_S1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\U01\APP\ORACLE\ORADATA\DEV2\SYSTEM_01.DBF
restoring datafile 00002 to E:\U01\APP\ORACLE\ORADATA\DEV2\UNDOTBS_01.DBF
restoring datafile 00003 to E:\U01\APP\ORACLE\ORADATA\DEV2\SYSAUX_01.DBF
restoring datafile 00004 to E:\U01\APP\ORACLE\ORADATA\DEV2\INFORM_01.DBF
restoring datafile 00005 to E:\U01\APP\ORACLE\ORADATA\DEV2\STRMADMIN_01.DBF
restoring datafile 00006 to E:\U01\APP\ORACLE\ORADATA\DEV2\TOOLS_01.DBF
so at the end I get
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore