Pular para o conteúdo principal

Movendo datafiles entre ASM Diskgroups

Vamos considerar que você tenha os DiskGroups ASMDSK1 e ASMDSK2
e queira mover um datafile entre eles.

[oracle@denilson ~]$ rman target /

RMAN> REPORT SCHEMA;

Fazendo backup do arquivo para o DiskGroup novo:
RMAN> BACKUP AS COPY DATAFILE "+ASMDSK2/rdbms/datafile/tbs_5.256.565313879" FORMAT "+ASMDSK1";

Colocando datafile em modo OFFLINE (Note que exite 2 aspas simples no comando)
RMAN> SQL "ALTER DATABASE DATAFILE ' '+ASMDSK2/rdbms/datafile/tbs_5.256.565313879' ' OFFLINE";

Execute o switch para mudar para a cópia mais recente do datafile:
RMAN> SWITCH DATAFILE "+ASMDSK2/rdbms/datafile/tbs_5.256.565313879" TO COPY;

Recuperando o datafile renomeado:
RMAN> RECOVER DATAFILE "+ASMDSK1/rdbms/datafile/tbs_5.256.603733209";

Colocando o datafile online:
RMAN> SQL "ALTER DATABASE DATAFILE ' '+ASMDSK2/rdbms/datafile/tbs_5.256.565313879' ' ONLINE";

* Lembre-se de remover o arquivo no diskgroup antigo
DELETE DATAFILECOPY "+ASMDSK2/rdbms/datafile/tbs_5.256.603733209";

Comentários

  1. Unknown4 de agosto de 2018 às 20:06

    Muito bom! Consegui sem problemas executar as atividades acima no meu ambiente de produção e não recebi erros.

    ResponderExcluir

Postar um comentário

Postagens mais visitadas deste blog

Webcenter Content - Cache Configuration for JdbcFileStore configuration

The configuration values below, control the temporarily cached files keep in FileCache table. FsCacheThreshold Specifies the maximum cache size, in megabytes (default=100) Once the threshold is met, Content Server starts deleting files that are older than the minimum age, as specified by the FsMinimumFileCacheAge parameter FsMaximumFileCacheAge The age at which files are deleted, expressed in days. The default is 365 days FsMinimumFileCacheAge The minimum age at which cached files can be deleted This parameter is used in conjunction with the FsCacheThreshold parameter to determine when to delete cached files FsCleanUpCacheDuringIndexing This parameter activates vault cache cleaning, while FsCacheThreshold, FsMaximumFileCacheAge and FsMinimumFileCacheAge are controling its behaviour.  Expect, when this is enabled on a system that currently has a large number of files in the FileCache table, the first cycle will take a long time to complete. How to Confi...
Postar um comentário
Leia mais

Oracle Data Modeler and SQL Developer: change user interface (GUI) language

Oracle Data Modeler and Oracle SQL Developer does not allow to change the user interface language in “Options” or somewhere else in the GUI. This applies to the versions: Oracle SQL Developer Data Modeler - Version All and later (18.2.0 in my case) Oracle SQL Developer - Version 3.2 and later However, it’s possible switch to other language, changing datamodeler\ide\bin\ide.conf configuration file. The following lines should be added to the file for support English: AddVMOption -Duser.language=en AddVMOption -Duser.country=US Restart application! SQL Developer and Data Modeler supports the following languages: French(fr), German(de), Italian(it), Spanish(es), Brazilian Portuguese(pt BR), Japanese(ja), Korean(ko), Simplified Chinese(zh CN), Traditional Chinese(zh TW).
Postar um comentário
Leia mais

Recompile JSP EBS - R12.2

1. Backup $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/ $ mv _pages _pages_old 2. Stop services cd $ADMIN_SCCRIPTS_HOME ./adapcctl.sh stop ./admanagedsrvctl.sh stop oafm_server1 ./admanagedsrvctl.sh stop oacore_server1 3. Compile the jsps manually  cd $FND_TOP/patch/115/bin/ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p             4. Checking $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages $ ls -ltr  5. Start services cd $ADMIN_SCCRIPTS_HOME ./admanagedsrvctl.sh start oacore_server1 ./admanagedsrvctl.sh start oafm_server1 ./adapcctl.sh start 6. Clear your web browser cache
Postar um comentário
Leia mais