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