etapa, os Redo log files: Terceira etapa, movendo os redo logs: Vamos verificar a localizacao atual dos redo: select * from v$logfile /u01/oracle/oradata/bkp1/orcl/datafile/redo01a.dbf/u01/oracle/oradata/bkp1/orcl/datafile/redo02a.dbf Moveremos para : /u02/oracle/oradata/orcl/datafile/redo01a.dbf/u02/oracle/oradata/orcl/datafile/redo02a.dbf Primeiramente paramos nosso banco srvctl stop database d orcl o immediate Movemos os redo pelo sqlplus : HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/redo01a.dbf /u02/oracle/oradata/orcl/datafile/redo01a.dbf ;HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/redo02a.dbf /u02/oracle/oradata/orcl/datafile/redo02a.dbf ; Agora iniciamos o banco em modo mount, afinal os redo sao utilizados na fase de abertura certo? srvctl start database d orcl o mount Agora alteramos no spfile a localizacao dos redo: ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/redo01a.dbf' TO '/u02/oracle/oradata/orcl/datafile/redo01a.dbf';ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/redo02a.dbf' TO '/u02/oracle/oradata/orcl/datafile/redo02a.dbf'; Agora e so abrir o banco: alter database open; Quarta Fase mover os archives logs No meu caso por ser uma base de testes, estava configurado em noarchivelog assim foi so habilitar o archive mode: Pare o banco e inicie em mount: SQL> startup mountORACLE instance started.Total System Global Area 184549376 bytesFixed Size 1300928 bytesVariable Size 157820480 bytesDatabase Buffers 25165824 bytesRedo Buffers 262144 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter database open;Database altered.Feito , proxima etapa os datafiles.Fase cinco movendo os datafiles.Nos caso dos datafiles podemos ter serios problemas caso ocorra um erro em um datafile interno do Oracle como o system.Por isso e claro que antes de qualquer coisa devemos realizar uma backup so por via das duvidas, isso esta escrito no manual do DBA cagao e nunca faz mal seguir, afinal tambem e uma das regras de ouro lembram? regra de ouro numero 2: nunca se coloque em uma situacao sem volta , sempre tenha um backup!Vamos verificar a localizacao atual dos datafiles:select * from v$datafile/u01/oracle/oradata/bkp1/orcl/datafile/data_i001.001.dbf/u01/oracle/oradata/bkp1/orcl/datafile/data_t001.001.dbf/u01/oracle/oradata/bkp1/orcl/datafile/sysaux_01.dbf/u01/oracle/oradata/bkp1/orcl/datafile/system_01.dbf/u01/oracle/oradata/bkp1/orcl/datafile/undotbs1_01.dbf/u01/oracle/oradata/bkp1/orcl/datafile/undotbs2_01.dbf/u01/oracle/oradata/bkp1/orcl/datafile/users_01.dbfVamos mover para esta localizacao:/u02/oracle/oradata/orcl/datafile/data_i001.001.dbf/u02/oracle/oradata/orcl/datafile/data_t001.001.dbf/u02/oracle/oradata/orcl/datafile/sysaux_01.dbf/u02/oracle/oradata/orcl/datafile/system_01.dbf/u02/oracle/oradata/orcl/datafile/undotbs1_01.dbf/u02/oracle/oradata/orcl/datafile/undotbs2_01.dbf/u02/oracle/oradata/orcl/datafile/users_01.dbfParamos o bancoE movemos usando o sqlplus HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/data_i001.001.dbf /u02/oracle/oradata/orcl/datafile/data_i001.001.dbf ;HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/data_t001.001.dbf /u02/oracle/oradata/orcl/datafile/data_t001.001.dbf ; HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/sysaux_01.dbf /u02/oracle/oradata/orcl/datafile/sysaux_01.dbf ;HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/system_01.dbf /u02/oracle/oradata/orcl/datafile/system_01.dbf ;HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/undotbs1_01.dbf /u02/oracle/oradata/orcl/datafile/undotbs1_01.dbf ;HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/undotbs2_01.dbf /u02/oracle/oradata/orcl/datafile/undotbs2_01.dbf ;HOST mv /u01/oracle/oradata/bkp1/orcl/datafile/users_01.dbf /u02/oracle/oradata/orcl/datafile/users_01.dbf ;Iniciamos em mount e alteramos a localizacao dos datafiles:STARTUP MOUNTALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/data_i001.001.dbf' to '/u02/oracle/oradata/orcl/datafile/data_i001.001.dbf';ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/data_t001.001.dbf' to '/u02/oracle/oradata/orcl/datafile/data_t001.001.dbf';ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/sysaux_01.dbf' to '/u02/oracle/oradata/orcl/datafile/sysaux_01.dbf';ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/system_01.dbf' to '/u02/oracle/oradata/orcl/datafile/system_01.dbf';ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/undotbs1_01.dbf' to '/u02/oracle/oradata/orcl/datafile/undotbs1_01.dbf';ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/undotbs2_01.dbf' to '/u02/oracle/oradata/orcl/datafile/undotbs2_01.dbf';ALTER DATABASE RENAME FILE '/u01/oracle/oradata/bkp1/orcl/datafile/users_01.dbf' to '/u02/oracle/oradata/orcl/datafile/users_01.dbf';Agora abrimos o banco e vida nova:ALTER DATABASE OPEN; Feito banco totalmente migrado para o novo disco, os temp files podem ser dropados e re-criados, nao e necessario copiar afinal sao dados temporarios ne!Bom era isso, espero que aproveitem e se divirtam tanto quanto eu me diverti nessa! Ate a proxima.