Mover datafile de FileSystem para ASM Disk Group

Pessoal, boa tarde.
Segue abaixo o procedimento para mover datafile criados em filesystem para o disco ASM (DiskGroup).

1- Para testarmos a movimentação do Datafile, vamos realizar primeiramente a criação do mesmo no filesystem.

SQL> CREATE TABLESPACE ORATBS DATAFILE '/u01/oradata/oratbs01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M ;

2- Verifique o diretório onde foi criado o datafile.

SQL> select name from v$datafile;

NAME

——————————————————————————–

+DATA/datafile/system.257.778261279

+DATA/datafile/sysaux.258.778261375

+DATA/datafile/undotbs1.259.778261441

+DATA/datafile/users.260.778261447

/u01/oradata/oratbs01.dbf

3- Conecte no RMAN.

[oracle@ORADB /oracle/ora11g]# rman target /

Recovery Manager: Release 11.2.0.1.0 – Production on Sun Mar 18 17:04:09 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORADB (DBID=3033221122)

4- Altere a tablespace para offline.

RMAN> sql “alter tablespace ORATBS offline”;

using target database control file instead of recovery catalog

sql statement: alter tablespace oratbs offline

5- Efetue a copia do datafile com RMAN, utilizando o comando de "Copy"  para o DiskGroup +DATA.

RMAN> copy datafile '/u01/oradata/oratbs01.dbf

' to '+DATA';

Starting backup at 18-MAR-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=58 device type=DISK

channel ORA_DISK_1: starting datafile copy

input datafile file number=00005 name=/u01/oradata/oratbs01.dbf

output file name=+DATA/datafile/oratbs.263.7733456677tag=TAG111234318T160609 RECID=13 STAMP=77987245

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:14

Finished backup at 18-MAR-14

RMAN> exit

Recovery Manager complete.

6- Conecte no SQL*Plus e renomeio o antigo datafile para criar o arquivo no ASM DiskGroup .

[oracle@ORADB /oracle/ora11g]# sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 18 17:09:12 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

SQL> alter database rename file '/u01/oradata/oratbs01.dbf' to '+DATA/datafile/oratbs.263.7733456677';

Database altered.

7- Altere a tablespace para online novamente.

SQL> alter tablespace ORATBS online;

Tablespace altered.

8- Valide através da view "v$datafile" se o datafile está no local correto.

SQL> select name from v$datafile;

NAME ——————————————————————————–

+DATA/datafile/system.257.778261279

+DATA/datafile/sysaux.258.778261375

+DATA/datafile/undotbs1.259.778261441

+DATA/datafile/users.260.778261447

+DATA/datafile/oratbs.263.7733456677

Qualquer dúvida, deixe o seu comentário!