https://www.brdnug.org/about/ Neste artigo irei explicar como mover/copiar um datafile que está num diskgroup para outro diskgroup do ASM 10g.
No meu exemplo estou com um Oracle RAC 10g, porem pode ser uma base single sem problemas.
Order Tramadol Online SQL> select name from v$datafile; NAME ---------------------------------------------------------- +DGARCH/racrafa/datafile/system.295.768771961 +DGARCH/racrafa/datafile/undotbs1.322.768771993 +DGARCH/racrafa/datafile/sysaux.323.768772011 +DGARCH/racrafa/datafile/undotbs2.327.768772027 +DGARCH/racrafa/datafile/users.314.768772045
here Vendo que por um equivoco coloquei os datafiles no diskgroup DGARCH e o correto deveria ser DGDADOS.
Assim primeiramente devemos colocar o database em modo mount.
Purchase Klonopin Online SQL> SHUTDOWN IMMEDIATE SQL> STARTUP MOUNT
https://brunobianco.com.br/denial-steve/ Em ambiente RAC que é o meu caso, irei parar o database immediatamente e em seguida iniciar em modo mount.
https://eternaclinic.com/exclusive-promotion/ $ srvctl stop database -d racrafa -o immediate $ srvctl start database -d racrafa -o mount
https://timlarison.com/contact-tim/ Feito o procedimento de iniciar o database em modo mount, devo me conectar no RMAN.
Clonazepam Purchase Online $ rman target / Recovery Manager: Release 10.2.0.5.0 - Production on Tue Dec 6 10:59:38 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: RACRAFA (DBID=2793334314, not open)
https://spareveil.com/spa-facials/ E iniciar o procedimento de copia dos datafiles para onde que devem estar corretamente:
https://www.aminhaclinica.com.br/check-up/ RMAN> copy datafile '+DGARCH/racrafa/datafile/system.295.768771961' to '+DGDADOS/racrafa/datafile/system01.dbf'; Starting backup at 06-DEC-11 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=144 instance=racrafa1 devtype=DISK channel ORA_DISK_1: starting datafile copy input datafile fno=00001 name=+DGARCH/racrafa/datafile/system.295.768771961 output filename=+DGDADOS/racrafa/datafile/system01.dbf tag=TAG20111206T110405 recid=1 stamp=769172705 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05 Finished backup at 06-DEC-11 RMAN> copy datafile '+DGARCH/racrafa/datafile/undotbs1.322.768771993' to '+DGDADOS/racrafa/datafile/undotbs101.dbf'; Starting backup at 06-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile fno=00002 name=+DGARCH/racrafa/datafile/undotbs1.322.768771993 output filename=+DGDADOS/racrafa/datafile/undotbs101.dbf tag=TAG20111206T110527 recid=2 stamp=769172789 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05 Finished backup at 06-DEC-11 RMAN>copy datafile '+DGARCH/racrafa/datafile/sysaux.323.768772011' to '+DGDADOS/racrafa/datafile/sysaux01.dbf'; Starting backup at 06-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile fno=00003 name=+DGARCH/racrafa/datafile/sysaux.323.768772011 output filename=+DGDADOS/racrafa/datafile/sysaux01.dbf tag=TAG20111206T110633 recid=3 stamp=769172828 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35 Finished backup at 06-DEC-11 RMAN>copy datafile '+DGARCH/racrafa/datafile/undotbs2.327.768772027' to '+DGDADOS/racrafa/datafile/undotbs201.dbf'; Starting backup at 06-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile fno=00004 name=+DGARCH/racrafa/datafile/undotbs2.327.768772027 output filename=+DGDADOS/racrafa/datafile/undotbs201.dbf tag=TAG20111206T110709 recid=4 stamp=769172859 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35 Finished backup at 06-DEC-11 RMAN>copy datafile '+DGARCH/racrafa/datafile/users.314.768772045' to '+DGDADOS/racrafa/datafile/users01.dbf'; Starting backup at 06-DEC-11 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile fno=00005 name=+DGARCH/racrafa/datafile/users.314.768772045 output filename=+DGDADOS/racrafa/datafile/users01.dbf tag=TAG20111206T110746 recid=5 stamp=769172867 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 06-DEC-11
see url Deve ser percebido que aproveitei e renomeei os arquivos de users.314.768772045 para users01.dbf
Buy Ambien Online Overnight Feito isso, aproveito o banco em modo mounted e devo renomear os datafiles no dicionario de dados.
Buy Lyrica Without Prescription sqlplus / as sysdba SQL> alter database rename file '+DGARCH/racrafa/datafile/system.295.768771961' to '+DGDADOS/racrafa/datafile/system01.dbf'; Database altered. SQL> alter database rename file '+DGARCH/racrafa/datafile/undotbs1.322.768771993' to '+DGDADOS/racrafa/datafile/undotbs101.dbf'; Database altered. SQL> alter database rename file '+DGARCH/racrafa/datafile/sysaux.323.768772011' to '+DGDADOS/racrafa/datafile/sysaux01.dbf'; Database altered. SQL> alter database rename file '+DGARCH/racrafa/datafile/undotbs2.327.768772027' to '+DGDADOS/racrafa/datafile/undotbs201.dbf'; Database altered. SQL> alter database rename file '+DGARCH/racrafa/datafile/users.314.768772045' to '+DGDADOS/racrafa/datafile/users01.dbf'; Database altered.
Assim com tudo ok agora podemos abrir o banco sem problemas:
SQL> SHUTDOWN IMMEDIATE SQL> STARTUP
Em ambiente RAC que é o meu caso, irei parar o database immediatamente e em seguida iniciar em modo mount.
$ srvctl stop database -d racrafa -o immediate $ srvctl start database -d racrafa
E agora posso conferir os datafiles
SQL> select name from v$datafile; NAME ------------------------------------------- +DGDADOS/racrafa/datafile/system01.dbf +DGDADOS/racrafa/datafile/undotbs101.dbf +DGDADOS/racrafa/datafile/sysaux01.dbf +DGDADOS/racrafa/datafile/undotbs201.dbf +DGDADOS/racrafa/datafile/users01.dbf
Autor: Rafael Stoever
https://spareveil.com/privacy-policy/ Bacharel em Sistema de Informação pela Uniasselvi, atualmente cursando Gerenciamento de Projetos em TI pela Pós Graduação Uniasselvi. Atuo como Analista de suporte https://detoxofcolorado.com/verify-insurance/ a banco de dados – DBA pela Lumina Serviços em TI residente de Blumenau/ SC, source link OPN Certified Specialist, Certificado OCP 10g/11g/12c, OCE RAC10g e Linux 10g. Conhecimentos em Microsoft SqlSever, Mysql e programação web (php,asp).
