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’;
Posts Tagged ‘backup’
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 »
List RMan Backups
Posted by philiphowe on April 7, 2009
list backup summary;
Posted in RMAN | Tagged: backup, RMAN | Leave a Comment »
Philip Howe's Oracle Blog 