If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to recover (clone) DB from RAC+ASM

Hi everybody,
i need help how to clone (recover) our prod database to another server from disk (tape). Our prod database is in RAC with ASM and I need to clone it to different server without ASM and RAC. Everything is Win2003 Srv.
I do it this way:

run {
Set newname for datafile 1 to 'e:\oradata\CLON\system.272.668509367';
Set newname for datafile 2 to 'e:\oradata\CLON\undotbs1.273.668509387';
Set newname for datafile 3 to 'e:\oradata\CLON\sysaux.263.668509393';
Set newname for datafile 4 to 'e:\oradata\CLON\ifsapp_archive_data.298.668509401';
Set newname for datafile 5 to 'e:\oradata\CLON\ifsapp_archive_index.258.668509401';

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Thanks for you answer,
but I do have the archived logs in my backup. The whole backup has this structure:
filenames:
1. 2qk18tcm_1_1 40GB = datafiles
2. 2rk193jm_1_1 15MB = controlfiles, spfile
3. 2sk193kn_1_1 5GB = archived logs
so the recovery process should use the archived logs. Even log from the backup shows, that the file is in the backup.