Database Backup and Recovery (MOSC)

MOSC Banner

RMAN restoration ASM to NON ASM(file system) RAC to standalone

edited Mar 26, 2012 3:08AM in Database Backup and Recovery (MOSC) 1 commentAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center