Como converter arquivos de sistema para ASM Storage, usando o RMAN // How to convert file system to ASM Storage using RMAN

Hoje me foi solicitado instalar o ASM e mover os arquivos do sistema de arquivos para o armazenamento ASM. A grosso modo, o ASM permite que o oracle gerencie o seu storage.  // Today I was asked to install the ASM and move the file system files to ASM storage. Roughly, ASM allows Oracle to manage your storage.

Agora, basta localizar os arquivos de sistema, convertê-los para ASM (via rman), colocar os arquivos de sistemas "antigos" offline e renomear os arquivos de sistemas que passarão a ser utilizados. // Now, just find the system files , convert them to ASM (via rman ) , place the system offline files and rename the file systems which will be used.

Vamos ao que interessa! // Lets go to what matters!

1) Localizando os arquivos de sistema: // Finding the file system :

SQL> select name from V$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/example01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf


2) Por questão de segurança, é recomendado que se faça backup com os comandos de criação do control file. // For safety, it is recommended to back up with the control file creation commands.

SQL> alter database backup controlfile to trace;

2.1) Fazer um backup no rman. // Make a backup in rman.
RMAN> backup database;

3) Caso o banco esteja em Archivelog, deve-se fazer um arquivo por vez. // If the base is Archivelog , you should do one file at a time.

3.1) Colocando os arquivos de sistemas offline. // Putting the offline file systems.

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/example01.dbf' offline;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/system01.dbf' offline;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/sysaux01.dbf' offline;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/undotbs01.dbf' offline;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/users01.dbf' offline;


3.2) Convertendo para ASM (Esse processo demora um pouco! (: Tenha paciência!) // Converting to ASM ( This process takes a little ( : Be patient !)

RMAN> convert datafile '/u01/app/oracle/oradata/orcl/example01.dbf' format '+data';

Starting conversion at target at 18-APR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=51 device type=DISK
channel ORA_DISK_1: starting datafile conversion
input file name=/u01/app/oracle/oradata/orcl/example01.dbf

converted datafile=+DATA/ORCL/DATAFILE/example.256.909512635
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:20:05
Finished conversion at target at 18-APR-16

Agora faça em todos os outros arquivos de sistema. // Now do all other system files.

RMAN> convert datafile '/u01/app/oracle/oradata/orcl/system02.dbf' format '+data';
RMAN> convert datafile '/u01/app/oracle/oradata/orcl/sysaux01.dbf' format '+data';
RMAN> convert datafile '/u01/app/oracle/oradata/orcl/undotbs01.dbf' format '+data';
RMAN>


3.3) Renomeando os arquivos de sistemas que passarão a ser utilizados.  // Renaming the file systems which will be used.

SQL> alter database rename file '/u01/app/oracle/oradata/orcl/example01.dbf' to '+DATA/ORCL/DATAFILE/example.256.909512635';

SQL> alter database rename file '/u01/app/oracle/oradata/orcl/system01.dbf' to '+DATA/ORCL/DATAFILE/system.262.909524257';

SQL> alter database rename file '/u01/app/oracle/oradata/orcl/sysaux01.dbf' to '+DATA/ORCL/DATAFILE/example.256.909512635';

SQL> alter database rename file '/u01/app/oracle/oradata/orcl/undotbs01.dbf' to '+DATA/ORCL/DATAFILE/example.256.909512635';

SQL> alter database rename file '/u01/app/oracle/oradata/orcl/users01.dbf' to '+DATA/ORCL/DATAFILE/example.256.909512635';

3.4) Agora, localize os arquivos de sistema:  // Now locate the file system:

SQL> select name from V$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
+DATA/ORCL/DATAFILE/example.256.909512635
/u01/app/oracle/oradata/orcl/users01.dbf

3.5) Agora coloque os arquivos de sistema online. // Now putting the online file systems.

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/example01.dbf' online;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/system01.dbf' online;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/sysaux01.dbf' online;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/undotbs01.dbf' online;

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/users01.dbf' online;


4) Caso o banco esteja em Noarchivelog. // If the bank is in NOARCHIVELOG.
4.1) Execute esses comandos para gerar os comandos que serão utilizados no próximo passo. // Run these commands to generate the commands to be used in the next step.

select 'alter database datafile '||file_name||' offline;' from v$datafile;

select 'convert datafile '''||file_name||''' format '''+data''';'

select 'alter database datafile '||file_name||' online;' from v$datafile;

4.2) Coloque o banco em mount
SQL> shutdown immediate;
SQL> startup mount;

4.3) Colocando os arquivos de sistemas offline. // Putting the offline file systems.

4.4) Convertendo para ASM (Esse processo demora um pouco! (: Tenha paciência!) // Converting to ASM ( This process takes a little ( : Be patient !)

4.5) Renomeando os arquivos de sistemas que passarão a ser utilizados.  // Renaming the file systems which will be used.

4.6) Agora coloque os arquivos de sistema online. // Now putting the online file systems

É isso!! Grande abraço e até a próxima! // It is!! Big hug and see you soon!

My linkedin: https://www.linkedin.com/in/salom%C3%A3o-netto-0667851a?trk=nav_responsive_tab_profile