Moving datafiles to different diskgroup
Hi.
I use ASM with multiple diskgroups and I have to move some datafiles between those diskgroups. Question is: Did I choose the best way?
My steps are:
sql 'alter tablespace XYZ read only';
copy datafile 123 to '+DG2';
sql 'alter tablespace XYZ offline';
switch datafile 123 to copy;
sql 'alter tablespace online';
sql 'alter tablespace read write';
delete noprompt copy of datafile 123;
All data in this tablespace are in partitioned objects and are not refferenced during this operation. Is this the best way to move datafiles between diskgroups?
I use ASM with multiple diskgroups and I have to move some datafiles between those diskgroups. Question is: Did I choose the best way?
My steps are:
sql 'alter tablespace XYZ read only';
copy datafile 123 to '+DG2';
sql 'alter tablespace XYZ offline';
switch datafile 123 to copy;
sql 'alter tablespace online';
sql 'alter tablespace read write';
delete noprompt copy of datafile 123;
All data in this tablespace are in partitioned objects and are not refferenced during this operation. Is this the best way to move datafiles between diskgroups?
0