Tuesday, 4 August 2015

Moving datafile form NON ASM to ASM

How to move the datafile which is created in NON-ASM in RAC environment.

Steps:
SQL> select file# from v$datafile where name='/u01/app/oracle/product/11.2.0/db_1/dbs/DATA_01';

SQL> select tablespace_name from dba_data_files where file_name='/u01/app/oracle/product/11.2.0/db_1/dbs/DATA_01';

++ Now Offline the tablespace
SQL> alter tablespace <Tablespace name> offline;

++ Login to RMAN to copy the datafile to ASM
RMAN> copy datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/DATA_01' to '+DATA_01' ;

++ Switch or rename the datafile
RMAN> switch datafile 74 to copy;

then check from both the nodes the datafile is accesable.
SQL> select name from v$datafile where file#=74;
++ Online the tablespace
SQL> alter tablespace <Tablespace name>  online;

No comments: