I am performing a database refresh from production server to a demo server. Our Production database is 184.108.40.206 and it is using ASM filesystem to keep the data, redo and other files in ASM disks.
On the other hand demo server is not having ASM, all the database files are stored in a local filesytem.
I have taken a fresh backup of our production database, but I am not sure to perform the restore part as the demo server is not having ASM.
Can anyone suggest me how to perform this, I mean datafile restore from ASM to local filesystem.
Any usefull links will be helpful.
You can restore the backup of your Production database which is using ASM to your demo server (using file system).
Make sure that the control_files parameter in the pfile/spfile is pointing to the file system location where you want to have contol files located on the demo server.
Next, before you use the restore command to restore the database, provide the location of the datafile where you need to restore using the "set newname" clause.
set newname for datafile 1 to '<file-system-location-on-demo-server>';
set newname for datafile 2 to '<file-system-location-on-demo-server>';
. . . . .
. . . . .
switch datafile all;
You can refer this http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/
Though the above link is from ASM to ASM, there are steps involved on moving to non-ASM as well.
If you feel that the reply was helpful, then please consider providing appropriate points ;)