RMAN restoration ASM to NON ASM(file system) RAC to standalone
dear export,I have RAC version of 11.2g standard edition. I need to restore DB in to standalone server which is having standalone server with filesystem.
RAC db datafile /redlog/controlfile locations are follows.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/db/datafile/users.259.756835809
+DATA/db/datafile/undotbs1.258.756835809
+DATA/db/datafile/sysaux.257.756835807
+DATA/db/datafile/system.256.756835807
+DATA/db/datafile/undotbs2.264.756835919
+DATA/db/datafile/udara.268.764857359
+DATA/db/datafile/eta_prod_data01.269.764858287
+DATA/db/datafile/eta_test_data01.270.764859143
+DATA/db/datafile/eta_prod_indx01.271.768493763
+DATA/db/datafile/eta_prod_blob01.272.771258751
SQL> select MEMBER from v$logfile;
MEMBER
RAC db datafile /redlog/controlfile locations are follows.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/db/datafile/users.259.756835809
+DATA/db/datafile/undotbs1.258.756835809
+DATA/db/datafile/sysaux.257.756835807
+DATA/db/datafile/system.256.756835807
+DATA/db/datafile/undotbs2.264.756835919
+DATA/db/datafile/udara.268.764857359
+DATA/db/datafile/eta_prod_data01.269.764858287
+DATA/db/datafile/eta_test_data01.270.764859143
+DATA/db/datafile/eta_prod_indx01.271.768493763
+DATA/db/datafile/eta_prod_blob01.272.771258751
SQL> select MEMBER from v$logfile;
MEMBER
0