Move tablespace to another disk group in ASM with RMAN
Posted by philiphowe on December 15, 2011
Using RMAN:
backup as copy tablespace TBLSP1 format ‘+NEWGROUP’;
sql ‘alter tablespace TBLSP1 offline’;
switch tablespace TBLSP1 to copy;
recover tablespace TBLSP1;
sql ‘alter tablespace TBLSP1 online’;
Advertisement
