Online Tramadol Prescription A Oracle na versão 11gR2 disponibiliza como New Feature a forma de fazer o duplicate sem precisar estar conectado na base de origem. Facilitando muitas vezes o transporte de uma base inteira, como irei mostrar neste teste case de um duplicate RAC 11gR2 para um Single 11gR2.

https://www.brigantesenglishwalks.com/z7vwf0t Meu ambiente que estarei demonstrando será tudo em linux, RAC+ASM para Single Non-ASM.

https://www.mbtn.net/?p=kwv7988v0 Primeiramente temos que fazer um backup full do database RAC, no meu caso chamado database: TKRAC11G.

Shop Tramadol Online [oracle@rac11g1 backup]$ rman target / Recovery Manager: Release 11.2.0.2.0 - Production on Tue Feb 14 15:07:24 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TKRAC11G (DBID=2569840887) RMAN> run { 2> allocate channel d1 type disk FORMAT '/ora01/backup/df_%d_%s_%p_%t.dbf' maxpiecesize 3000M; 3> backup tag 'BackupDatabaseFullDiario' database; 4> sql 'alter system archive log current'; 5> backup tag 'BackupArchivelogDiario' archivelog all delete input; 6> backup tag 'BackupCurrentControlfile' current controlfile; 7> delete noprompt obsolete ; 8> CROSSCHECK BACKUPSET; 9> CROSSCHECK COPY; 10> crosscheck archivelog all ; 11> DELETE NOPROMPT EXPIRED BACKUP; 12> DELETE NOPROMPT EXPIRED COPY; 13> release channel d1;} using target database control file instead of recovery catalog allocated channel: d1 channel d1: SID=145 instance=tkrac11g1 device type=DISK Starting backup at 14-FEB-12 channel d1: starting full datafile backup set channel d1: specifying datafile(s) in backup set input datafile file number=00007 name=+DGDADOS/tkrac11g/datafile/tasy_data02.dbf input datafile file number=00006 name=+DGDADOS/tkrac11g/datafile/tasy_data01.dbf input datafile file number=00001 name=+DGDICT/tkrac11g/datafile/system.259.758649415 input datafile file number=00003 name=+DGDICT/tkrac11g/datafile/undotbs1.261.758649537 input datafile file number=00004 name=+DGDICT/tkrac11g/datafile/undotbs2.263.758649565 input datafile file number=00002 name=+DGDICT/tkrac11g/datafile/sysaux.260.758649481 input datafile file number=00008 name=+DGINDEX/tkrac11g/datafile/tasy_index01.dbf input datafile file number=00009 name=+DGINDEX/tkrac11g/datafile/tasy_index02.dbf input datafile file number=00010 name=+DGDICT/tkrac11g/datafile/teikoadm01.dbf input datafile file number=00005 name=+DGDICT/tkrac11g/datafile/users.264.758649583 channel d1: starting piece 1 at 14-FEB-12 channel d1: finished piece 1 at 14-FEB-12 piece handle=/ora01/backup/df_TKRAC11G_9_1_775235269.dbf tag=BACKUPDATABASEFULLDIARIO comment=NONE channel d1: starting piece 2 at 14-FEB-12 channel d1: finished piece 2 at 14-FEB-12 piece handle=/ora01/backup/df_TKRAC11G_9_2_775235269.dbf tag=BACKUPDATABASEFULLDIARIO comment=NONE channel d1: starting piece 3 at 14-FEB-12 channel d1: finished piece 3 at 14-FEB-12 piece handle=/ora01/backup/df_TKRAC11G_9_3_775235269.dbf tag=BACKUPDATABASEFULLDIARIO comment=NONE channel d1: backup set complete, elapsed time: 00:15:28 channel d1: starting full datafile backup set channel d1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel d1: starting piece 1 at 14-FEB-12 channel d1: finished piece 1 at 14-FEB-12 piece handle=/ora01/backup/df_TKRAC11G_10_1_775236200.dbf tag=BACKUPDATABASEFULLDIARIO comment=NONE channel d1: backup set complete, elapsed time: 00:00:03 Finished backup at 14-FEB-12 sql statement: alter system archive log current Starting backup at 14-FEB-12 current log archived channel d1: starting archived log backup set channel d1: specifying archived log(s) in backup set input archived log thread=1 sequence=395 RECID=489 STAMP=775236217 input archived log thread=2 sequence=218 RECID=490 STAMP=775236219 input archived log thread=2 sequence=219 RECID=492 STAMP=775236223 input archived log thread=1 sequence=396 RECID=491 STAMP=775236220 channel d1: starting piece 1 at 14-FEB-12 channel d1: finished piece 1 at 14-FEB-12 piece handle=/ora01/backup/df_TKRAC11G_11_1_775236224.dbf tag=BACKUPARCHIVELOGDIARIO comment=NONE channel d1: backup set complete, elapsed time: 00:00:03 channel d1: deleting archived log(s) archived log file name=+DGINDEX/tkrac11g/archivelog/2012_02_14/thread_1_seq_395.271.775236215 RECID=489 STAMP=775236217 archived log file name=+DGINDEX/tkrac11g/archivelog/2012_02_14/thread_2_seq_218.270.775236219 RECID=490 STAMP=775236219 archived log file name=+DGINDEX/tkrac11g/archivelog/2012_02_14/thread_2_seq_219.269.775236223 RECID=492 STAMP=775236223 archived log file name=+DGINDEX/tkrac11g/archivelog/2012_02_14/thread_1_seq_396.268.775236221 RECID=491 STAMP=775236220 Finished backup at 14-FEB-12 Starting backup at 14-FEB-12 channel d1: starting full datafile backup set channel d1: specifying datafile(s) in backup set including current control file in backup set channel d1: starting piece 1 at 14-FEB-12 channel d1: finished piece 1 at 14-FEB-12 piece handle=/ora01/backup/df_TKRAC11G_12_1_775236229.dbf tag=BACKUPCURRENTCONTROLFILE comment=NONE channel d1: backup set complete, elapsed time: 00:00:01 Finished backup at 14-FEB-12 RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 no obsolete backups found crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/ora01/backup/df_TKRAC11G_9_1_775235269.dbf RECID=15 STAMP=775235274 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/ora01/backup/df_TKRAC11G_9_2_775235269.dbf RECID=16 STAMP=775235810 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/ora01/backup/df_TKRAC11G_9_3_775235269.dbf RECID=17 STAMP=775236155 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/ora01/backup/df_TKRAC11G_10_1_775236200.dbf RECID=18 STAMP=775236204 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/ora01/backup/df_TKRAC11G_11_1_775236224.dbf RECID=19 STAMP=775236224 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/ora01/backup/df_TKRAC11G_12_1_775236229.dbf RECID=20 STAMP=775236232 Crosschecked 6 objects specification does not match any datafile copy in the repository specification does not match any control file copy in the repository specification does not match any archived log in the repository specification does not match any archived log in the repository specification does not match any backup in the repository specification does not match any datafile copy in the repository specification does not match any control file copy in the repository specification does not match any archived log in the repository released channel: d1 RMAN>

go here Feito o backup full conforme mostrado a cima agora vamos copiar remotamente para o servidor de destino, no meu caso servidor tkora11g.

https://www.elevators.com/lzu76tmtnv5 [oracle@rac11g1 backup]$ ls -ltr /ora01/backup/ total 6488684 drwxr-xr-x 2 oracle oinstall 4096 Aug 6 2011 log -rw-r----- 1 oracle oinstall 3145728000 Feb 14 15:16 df_TKRAC11G_9_1_775235269.dbf -rw-r----- 1 oracle oinstall 3145728000 Feb 14 15:22 df_TKRAC11G_9_2_775235269.dbf -rw-r----- 1 oracle oinstall 301367296 Feb 14 15:23 df_TKRAC11G_9_3_775235269.dbf -rw-r----- 1 oracle oinstall 19169280 Feb 14 15:23 df_TKRAC11G_10_1_775236200.dbf -rw-r----- 1 oracle oinstall 6764032 Feb 14 15:23 df_TKRAC11G_11_1_775236224.dbf -rw-r----- 1 oracle oinstall 19136512 Feb 14 15:23 df_TKRAC11G_12_1_775236229.dbf [oracle@rac11g1 backup]$ scp df_TKRAC11G_* 192.168.10.105:/ora02/backup oracle@192.168.10.105's password: df_TKRAC11G_10_1_775236200.dbf 100% 18MB 18.3MB/s 00:01 df_TKRAC11G_11_1_775236224.dbf 100% 6606KB 6.5MB/s 00:00 df_TKRAC11G_12_1_775236229.dbf 100% 18MB 18.3MB/s 00:01 df_TKRAC11G_9_1_775235269.dbf 100% 3000MB 13.5MB/s 03:42 df_TKRAC11G_9_2_775235269.dbf 100% 3000MB 14.1MB/s 03:33 df_TKRAC11G_9_3_775235269.dbf 100% 287MB 14.4MB/s 00:20

https://onlineconferenceformusictherapy.com/2025/02/22/la0hcum3 Feito a copia dos arquivos do backup da base RAC vamos conectar no servidor tkora11g (single).

here Variaveis de ambiente do usuario oracle no servidor destino tkora11g (single):

https://guelph-real-estate.ca/97ccsikqh TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/ora02/app; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=dbdup; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM GGATE=$ORACLE_BASE/oracle/product/gg PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$GGATE; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

https://paradiseperformingartscenter.com/epdo7wb Carregado as variaveis de ambiente, temos que criar um pfile para essa base, a base se chamará DBDUP:

https://www.marineetstamp.com/w7csjdbk0rj [oracle@tkora11g dbs]$ cat $ORACLE_HOME/dbs/initdbdup.ora *.db_cache_size=113246208 *.java_pool_size=4194304 *.large_pool_size=4194304 *.oracle_base='/ora02/app'#ORACLE_BASE set from environment *.pga_aggregate_target=159383552 *.sga_target=264241152 *.shared_io_pool_size=0 *.shared_pool_size=134217728 *.streams_pool_size=0 *.audit_file_dest='/ora02/app/admin/dbdup/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/ora02/app/oradata/dbdup/control01.ctl','/ora02/app/oradata/dbdup/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='dbdup' *.diagnostic_dest='/ora02/app' *.dispatchers='(PROTOCOL=TCP) (SERVICE=dbdupXDB)' *.log_archive_dest_1='LOCATION=/ora02/archives/dbdup/' *.log_archive_format='dbdup_%t_%s_%r.arc' *.memory_target=422576128 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sec_case_sensitive_logon=FALSE *.undo_tablespace='UNDOTBS1' *.db_file_name_convert='+DGDICT/tkrac11g/datafile/','/ora02/oradata/dbdup/','+DGINDEX/tkrac11g/datafile/','/ora02/oradata/dbdup/','+DGDADOS/tkrac11g/datafile/','/ora02/oradata/dbdup/','+DGDICT/tkrac11g/tempfile/','/ora02/oradata/dbdup/' *.log_file_name_convert='+DGINDEX/tkrac11g/onlinelog/','/ora02/oradata/dbdup/','+DGDICT/tkrac11g/onlinelog/','/ora02/oradata/dbdup/'

https://dcinematools.com/wbj0xpu9v Pode notar que no final do arquivo há os parametros db_file_name_convert e log_file_name_convert que devem ser adicionados a base no caso que estou convertendo um RAC+ASM para um Single Non-ASM.

https://www.mreavoice.org/915bcoo6x Criado o pfile para iniciarmos a base, não podemos de esquecer de criar os diretorios informados no init principalmente.

source url Agora iniciando o banco em modo nomount:

SQL> startup nomount ORACLE instance started. Total System Global Area 422670336 bytes Fixed Size 1344616 bytes Variable Size 301992856 bytes Database Buffers 113246208 bytes Redo Buffers 6086656 bytes SQL> exit

Iniciado a base em modo nomount vamos para o processo mais complexo desse artigo, o duplicate.
Pode ser notado aqui, que o backup não precisa estar no mesmo local que foi gerado na origem, como era feito nas versões anteriores.

Segue a sequencia do meu case:

E Voilá ! A base está duplicada com o nome DBDUP, sem precisar conexão com catalog algum, sem conexão com a base de origem !
Muito simples, fácil e rápido dependendo é claro do tamanho da base !

Autor: Rafael Stoever

Buy Cheap Tramadol Overnight 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://www.yolascafe.com/vdrqvpx65lm a banco de dados – DBA pela Lumina Serviços em TI residente de Blumenau/ SC, Can I Get Tramadol Online OPN Certified Specialist, Certificado OCP 10g/11g/12c, OCE RAC10g e Linux 10g. Conhecimentos em Microsoft SqlSever, Mysql e programação web (php,asp).

• 
• 
• 
• 
•