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";
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
Postar um comentário