Migrating Non-ASM Tablespace to ASM Tablespace

Bom dia galera,

Estou eu aqui de novo... Hoje precisei mover uma tablespace que "não estava em ASM" para ASM.
Muito simples!!! Segue abaixo o proceçdimento.

$ rman target /
RMAN> sql "alter tablespace TESTE_REWRY2 offline";
RMAN> backup as copy tablespace TESTE_REWRY2 format '+DADOS';

Starting backup at 20-JUL-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=250 instance=SOA_1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00023 name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/teste_rewry.dbf
output file name=+DADOS/soa/datafile/teste_rewry2.319.756986355 tag=TAG20110720T095914 RECID=1 STAMP=756986355
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 20-JUL-11

Starting Control File and SPFILE Autobackup at 20-JUL-11
piece handle=+FRA/soa/autobackup/2011_07_20/s_756986356.289.756986357 comment=NONE
Finished Control File and SPFILE Autobackup at 20-JUL-11

RMAN> switch tablespace TESTE_REWRY2 to copy;

datafile 23 switched to datafile copy "+DADOS/soa/datafile/teste_rewry2.325.756986849"

RMAN> sql "alter tablespace TESTE_REWRY2 online";

Comentários