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’;
Archive for the ‘ASM’ Category
Move tablespace to another disk group in ASM with RMAN
Posted by philiphowe on December 15, 2011
Posted in ASM, Database, RAC, RMAN | Tagged: asm, backup, move, RMAN | Leave a Comment »
Philip Howe's Oracle Blog 