A melhor forma é através do RMAN, com o "backup as copy":
Steps To Migrate/Move a Database From Non-ASM to ASM And Vice-Versa [ID
252219.1]
Modified 22-DEC-2009 Type BULLETIN Status PUBLISHED
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
Information in this document applies to any platform.
Purpose
This article describes the steps to migrate a database from Non-ASM to ASM and
vice-versa.
To setup ASM, please follow
Note 452924.1 - How to Prepare Storage for ASM
Note 265633.1 - ASM Technical Best Practices
Note 249992.1 - New Feature on ASM (Automatic Storage Manager).
Scope and Application
A scheduled downtime is needed.
Steps To Migrate/Move a Database From Non-ASM to ASM And Vice-Versa
Step 1: Edit the pfile/spfile of DB to point the new control_file location on
ASM
E.g. : if your disk group name is '+DATA'
control_files='+DATA/<dbid>/control01.ctl'
The setting here is actually an alias for the controlfile.
For 10gR1 or you don't want to use an alias for controlfile, please set
control_files='+DATA' and use the following note to update the parameter again
in the pfile/spfile after the controlfile is created at step #3.
Note 468458.1 - How To Move Controlfile To ASM
If you later want to duplicate an extra copy of control file, please see
Note 345180.1 - How to duplicate a controlfile when ASM is involved
Step 2: Startup the database in nomount state
SQL> Startup nomount
Step 3: From RMAN session, copy the control file from old location to new
location
RMAN> CONNECT TARGET
RMAN> RESTORE CONTROLFILE FROM '/u01/TST/control01.ctl';
Here /u01/TST/control01.ctl is the old location of control file.
Step 4: From SQL session, mount the database
SQL> ALTER DATABASE MOUNT;
Step 5: Using RMAN, copy the datafile from NON-ASM to ASM
RMAN>BACKUP AS COPY DATABASE FORMAT '+DATA';
Step 6: Using RMAN, rename the datafile , using the following command
RMAN> SWITCH DATABASE TO COPY;
Step 7: Switch tempfile and open database.
RMAN> run {
set newname for tempfile 1 to '+DATA';
set newname for tempfile 2 to '+DATA';
...
switch tempfile all;
}
RMAN> ALTER DATABASE OPEN;
Step 8: Do the following maintenance
SQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE
a.group#=b.group#;
SQL> ALTER DATABASE ADD LOGFILE MEMBER '+ASM_Disk_group' TO GROUP 1;
SQL> ALTER DATABASE ADD LOGFILE MEMBER '+ASM_Disk_group' TO GROUP 2;
SQL> ALTER DATABASE DROP LOGFILE MEMBER '';
SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> ALTER DATABASE DROP LOGFILE MEMBER '';
SQL> ALTER SYSTEM SWITCH LOGFILE;
... repeat for *all* online redo log members.
A redo log member can only be dropped after being archived and being in
INACTIVE mode. If needed, switch logfile multiple times until the logfile is
ready for dropping.
Marcus Vinicius Miguel Pedro
OCP Database 9i
OCP Database 10g
OCE RAC 10g
OCP Database 11g
OCS Implementation 11g
mvmpe...@yahoo.com.br
Blog: http://www.viniciusdba.com.br
On 15/07/2010, at 08:10, ammorrimm wrote:
> Grandes Amigos,
>
> Gostaria de sugestões para realizar a migração dos dados de uma single
> instance para um RAC.
>
> Tenho uma migração para ser realizada de cerca de 300 GB para um cluster
> 11.1.0.6 e estou na dúvida qual seria o melhor procedimento...
>
> Pensei em realizar a migração via Rman....fazendo uso de um backup full e
> restaurando direto no ASM (+DATA). isso é possível ?
>
> Obrigado
>
>
[As partes desta mensagem que não continham texto foram removidas]
------------------------------------
--------------------------------------------------------------------------------------------------------------------------
>Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira
>responsabilidade de seus remetentes.
Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/
--------------------------------------------------------------------------------------------------------------------------
>Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure »
>Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE:
>http://www.oraclebr.com.br/
------------------------------------------------------------------------------------------------------------------------
Links do Yahoo! Grupos
<*> Para visitar o site do seu grupo na web, acesse:
http://br.groups.yahoo.com/group/oracle_br/
<*> Para sair deste grupo, envie um e-mail para:
oracle_br-unsubscr...@yahoogrupos.com.br
<*> O uso que você faz do Yahoo! Grupos está sujeito aos:
http://br.yahoo.com/info/utos.html
