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;
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:
Post a Comment