Transportable tablespaces, dataguard and ASM
Hi,
Has anybody migrated data from one database to another using cross platform transportable tablespaces(XTTS) with the target set-up having a standby database on ASM??
Our problem is that we can plug the tablespaces/datafiles into the primary and standby just fine but when we restart managed recovery the standby database file names are wrong and different to the ones that we plugged in on the standby side also. This means that when we try and open the standby database read only, the standby database complains about not being able to see datafiles.....
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5:
'+WADAP_DATA1/migtt1_stby/datafile/test_mig.364.710093301'
Has anyone carried out this procedure and know the correct steps please?.......many thanks