Total Pageviews

Tuesday, May 24, 2016

Moving of datafile from filesystem to ASM diskgroup

Moving of datafile from filesystem to ASM diskgroup


suppose current datafile path on file system is

/u01/pushpak01.dbf

ASM disk group path is 
+DATA

Now,
        To move the datafile  

1.Connect to Rman Target / 

2.Make tablespace offline first
    
rman> sql "alter tablespace pushpak offline";

3.Use copy command to move the datafile
    
  rman>copy datafile ' /u01/pushpak01.dbf' to '+DATA';

4.Now login to sqlplus prompt to make changes in the path from the controlfile.

   sql>alter database rename file '/u01/pushpak01.dbf' to 'new_path_generated';

5.Last step make tablespace online

sql>alter tablespace pushpak online;







No comments:

Post a Comment