Olá Ederson, tudo jóia?
Já tentei alguns passos parecidos com os que me instruiu, da uma olhada abaixo, onde mostro os arquivos que tenho assim como a execução dos passos ao final do arquivo. Muito obrigado pela força. Att ______________________ Daniel Mello [oracle@netbh tibh]$ ll -h total 220G -rwxr-xr-x 1 oracle oinstall 24M Aug 17 14:34 c-460209076-20120303-00 lrwxrwxrwx 1 oracle oinstall 60 Apr 2 09:41 data__bkp_datas__10_1_0an4upii_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__10_1_0an4upii_1_1.bak -rwxrwxrwx 1 oracle oinstall 58M Mar 3 11:51 data__bkp_datas__1_1_01n4ullj_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 2 19:43 data__bkp_datas__11_1_0bn4uq64_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__11_1_0bn4uq64_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 2 19:44 data__bkp_datas__12_1_0cn4uqq1_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__12_1_0cn4uqq1_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 4 14:08 data__bkp_datas__13_1_0dn4uqv6_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__13_1_0dn4uqv6_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 4 14:08 data__bkp_datas__14_1_0en4urnf_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__14_1_0en4urnf_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 4 14:08 data__bkp_datas__15_1_0fn4urnm_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__15_1_0fn4urnm_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 8 03:48 data__bkp_datas__16_1_0gn4usi2_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__16_1_0gn4usi2_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 8 03:48 data__bkp_datas__17_1_0hn4usk4_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__17_1_0hn4usk4_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 8 03:48 data__bkp_datas__18_1_0in4uti1_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__18_1_0in4uti1_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 9 11:29 data__bkp_datas__19_1_0jn4utig_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__19_1_0jn4utig_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 9 11:29 data__bkp_datas__20_1_0kn4uuff_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__20_1_0kn4uuff_1_1.bak -rwxrwxrwx 1 oracle oinstall 966K Mar 3 11:51 data__bkp_datas__2_1_02n4ullj_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 9 11:29 data__bkp_datas__21_1_0ln4uug8_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__21_1_0ln4uug8_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:01 data__bkp_datas__22_1_0mn4uv8r_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__22_1_0mn4uv8r_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:02 data__bkp_datas__23_1_0nn4uvbg_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__23_1_0nn4uvbg_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:02 data__bkp_datas__24_1_0on4uvto_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__24_1_0on4uvto_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:02 data__bkp_datas__25_1_0pn4uvvp_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__25_1_0pn4uvvp_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:02 data__bkp_datas__26_1_0qn4v0pl_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__26_1_0qn4v0pl_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:02 data__bkp_datas__27_1_0rn4v0qe_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__27_1_0rn4v0qe_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:03 data__bkp_datas__28_1_0sn4v1dn_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__28_1_0sn4v1dn_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:03 data__bkp_datas__29_1_0tn4v1f4_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__29_1_0tn4v1f4_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:03 data__bkp_datas__30_1_0un4v20q_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__30_1_0un4v20q_1_1.bak -rwxrwxrwx 1 oracle oinstall 54G Mar 3 12:20 data__bkp_datas__3_1_03n4ullp_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:03 data__bkp_datas__31_1_0vn4v25c_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__31_1_0vn4v25c_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:03 data__bkp_datas__32_1_10n4v2e0_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__32_1_10n4v2e0_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:03 data__bkp_datas__33_1_11n4v2ko_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__33_1_11n4v2ko_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:04 data__bkp_datas__34_1_12n4v2qv_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__34_1_12n4v2qv_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:04 data__bkp_datas__35_1_13n4v30p_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__35_1_13n4v30p_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:04 data__bkp_datas__36_1_14n4v37r_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__36_1_14n4v37r_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:05 data__bkp_datas__37_1_15n4v3e9_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__37_1_15n4v3e9_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:05 data__bkp_datas__38_1_16n4v3nr_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__38_1_16n4v3nr_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:05 data__bkp_datas__39_1_17n4v3ve_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__39_1_17n4v3ve_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:05 data__bkp_datas__40_1_18n4v45s_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__40_1_18n4v45s_1_1.bak -rwxrwxrwx 1 oracle oinstall 64G Mar 3 12:20 data__bkp_datas__4_1_04n4ullp_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:05 data__bkp_datas__41_1_19n4v4dj_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__41_1_19n4v4dj_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:06 data__bkp_datas__42_1_1an4v4h7_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__42_1_1an4v4h7_1_1.bak lrwxrwxrwx 1 oracle oinstall 60 Apr 19 18:06 data__bkp_datas__43_1_1bn4v4ps_1_1.bak -> /u04/golden-copy/tibh/data__bkp_datas__43_1_1bn4v4ps_1_1.bak -rwxrwxrwx 1 oracle oinstall 28G Mar 3 12:38 data__bkp_datas__5_1_05n4unbt_1_1.bak -rwxrwxrwx 1 oracle oinstall 38G Mar 3 12:39 data__bkp_datas__6_1_06n4uncr_1_1.bak -rwxrwxrwx 1 oracle oinstall 38G Mar 3 12:57 data__bkp_datas__7_1_07n4uoeb_1_1.bak lrwxrwxrwx 1 oracle oinstall 59 Apr 2 02:00 data__bkp_datas__8_1_08n4uoh2_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__8_1_08n4uoh2_1_1.bak lrwxrwxrwx 1 oracle oinstall 59 Apr 2 02:01 data__bkp_datas__9_1_09n4upf8_1_1.bak -> /u03/golden-copy/tibh/data__bkp_datas__9_1_09n4upf8_1_1.bak -rwxrwxrwx 1 oracle oinstall 0 Mar 3 16:22 nohup.out -rwxrwxrwx 1 oracle oinstall 46M Feb 3 2012 snapcf_hhdb09.f -rwxrwxrwx 1 oracle oinstall 24M Mar 3 16:09 snapcf_tibhmed1.f -rw-r--r-- 1 oracle oinstall 38K Apr 19 18:22 tibhmed1_ora_22244.trc -rwxrwxrwx 1 oracle oinstall 0 Mar 3 16:22 zip.log [oracle@netbh tibh]$ [oracle@netbh tibh]$ pwd /u02/golden-copy/tibh ---------------------------------------------------- RMAN> shutdown Oracle instance shut down RMAN> set dbid=460209076; executing command: SET DBID RMAN> startup nomount connected to target database (not started) startup failed: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0.3/db_1/dbs/initTIBHMED1.ora' starting Oracle instance without parameter file for retrieval of spfile Oracle instance started Total System Global Area 158662656 bytes Fixed Size 2226456 bytes Variable Size 104859368 bytes Database Buffers 46137344 bytes Redo Buffers 5439488 bytes RMAN> set controlfile autobackup format for device type disk to '/u02/golden-copy/tibh/%F'; executing command: SET CONTROLFILE AUTOBACKUP FORMAT RMAN> RESTORE CONTROLFILE TO '?/u05/oracle/oradata/TIBHMED1/controlf1.ora' FROM AUTOBACKUP db_name='TIBHMED1'; Starting restore at 17-AUG-12 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=162 device type=DISK channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120817 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120816 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120815 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120814 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120813 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120812 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120811 channel ORA_DISK_1: no AUTOBACKUP in 7 days found RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 08/17/2012 15:35:39 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece RMAN> RESTORE spfile TO '?/u05/oracle/oradata/TIBHMED1/spfilenmcpd.ora' FROM AUTOBACKUP db_name='TIBHMED1'; Starting restore at 17-AUG-12 using channel ORA_DISK_1 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120817 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120816 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120815 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120814 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120813 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120812 channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120811 channel ORA_DISK_1: no AUTOBACKUP in 7 days found RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 08/17/2012 15:36:39 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece RMAN> De: ederson2001br <ederson200...@yahoo.com.br> Para: oracle_br@yahoogrupos.com.br Enviadas: Sexta-feira, 17 de Agosto de 2012 15:16 Assunto: [oracle_br] Re: RMAN - Autobackup Daniel, Verifique um detalhe: Veja se /u04/golden-copy/tibh/ tem o arquivo que você está esperando para restaurar. O Controlfile Autobackup tem o formato de nome de arquivo, começando com uma letra "c" seguida do numero DBID, depois a data do arquivo. Ex: c-1234567890-20120816-21 Se um arquivo com esta máscara de nome não estiver no diretório, mesmo que vc cataloge o diretório, não vai da certo. No seu bloco RUN, tem um comentário do CHANNEL c1, setando uma fita. Afinal, vc está restaurando de uma fita ou de uma área em disco? Detalhe DOIS: para montar a base em outro server, tem uma sequencia: set dbid 123456789 startup nomount; set controlfile autobackup format for device type disk to '/u04/golden-copy/tibh/%F'; RESTORE CONTROLFILE TO '?/u05/oracle/oradata/TIBHMED1/controlf1.ora' FROM AUTOBACKUP db_name='TIBHMED1'; restore spfile TO '/opt/oracle10gR2/product/10.2/db_1/dbs/spfilenmcpd.ora' from autobackup db_name='TIBHMED1'; --crie o pfile usando o spfile restaurado e starte o banco com ele --note que neste pfile, precisa apontar para o --controlfile '?/u05/oracle/oradata/TIBHMED1/controlf1.ora' startup pfile='/opt/oracle10gR2/product/10.2/db_1/dbs/pfilenTIBHMED1.ora' mount force; catalog start with '/u04/golden-copy/tibh/'; --só então vc pode fazer restore --se restaurou tudo, fazer o recover --se ok, abrir: alter database open resetlogs; Ederson Elias DBA Oracle http://br.linkedin.com/pub/ederson-elias/24/8b/8b0 --- Em oracle_br@yahoogrupos.com.br, Daniel Mello <djnmello@...> escreveu > > Entendi Chiappa. Estou seguindo o guia, entretanto o RMAN continua > apresentando a mensagem abaixo. > Sei que tenho que recatalogar o backup, mas não estou conseguindo nem > restaurar spfile e controlfile. > > Obrigado. > > RMAN> RUN > { > 2> 3> # ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS > 'ENV=(NSR_DATA_VOLUME_POOL=oracle_tapes)'; > 4> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO > '/u04/golden-copy/tibh/%F'; > 5> RESTORE SPFILE > 6> TO PFILE '?/u05/oracle/oradata/TIBHMED1/initTIBHMED1.ora' > 7> FROM AUTOBACKUP; > 8> SHUTDOWN ABORT; > 9> } > > executing command: SET CONTROLFILE AUTOBACKUP FORMAT > > Starting restore at 17-AUG-12 > using channel ORA_DISK_1 > > channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120817 > channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120816 > channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120815 > channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120814 > channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120813 > channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120812 > channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120811 > channel ORA_DISK_1: no AUTOBACKUP in 7 days found > RMAN-00571: =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: ========================================================== > RMAN-03002: failure of restore command at 08/17/2012 14:21:20 > RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or > piece > > > ______________________ > Daniel Mello ------------------------------------ -------------------------------------------------------------------------------------------------------------------------- >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 [As partes desta mensagem que não continham texto foram removidas]
