Re: [oracle_br] Corrompeu a system!!!
Obrigado Sérgio! Suas orientações foram muito uteis! Obrigado mesmo! >From: Sergio Leandro Ghellere <[EMAIL PROTECTED]> >Reply-To: oracle_br@yahoogrupos.com.br >To: oracle_br@yahoogrupos.com.br >Subject: Re: [oracle_br] Corrompeu a system!!! >Date: Tue, 08 May 2007 15:59:24 -0300 > >bom, primeiramente vc vai ter que estar com o banco em estado MOUNT. Então >não é >necessário o OFFLINE IMMEDIATE já que as tablespaces e arquivos de dados >somente >são verificadas do estado MOUNT para OPEN. >daí não sei como são os labels do seu backup, então vc faz o restore do >ultimo >backup da tablespace (exatamente como colocasse no script) e depois o >recover. > >simulei aqui somente uma perda da tablespace system... > >[EMAIL PROTECTED] ~]$ . oraenv >ORACLE_SID = [asmtest] ? +ASM >[EMAIL PROTECTED] ~]$ asmcmd >ASMCMD> cd DG1/ASMTEST >ASMCMD> rm system01.dbf >ASMCMD> exit >[EMAIL PROTECTED] ~]$ . oraenv >ORACLE_SID = [+ASM] ? asmtest >[EMAIL PROTECTED] ~]$ sqlplus / as sysdba > >SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 8 15:53:20 2007 > >Copyright (c) 1982, 2005, Oracle. All rights reserved. > >Connected to an idle instance. > >SQL> startup >ORACLE instance started. > >Total System Global Area 209715200 bytes >Fixed Size 1218556 bytes >Variable Size 79693828 bytes >Database Buffers 125829120 bytes >Redo Buffers2973696 bytes >Database mounted. >ORA-01157: cannot identify/lock data file 1 - see DBWR trace file >ORA-01110: data file 1: '+DG1/asmtest/system01.dbf' > > >SQL> Disconnected from Oracle Database 10g Enterprise Edition Release >10.2.0.1.0 > - Production >With the Partitioning, OLAP and Data Mining options >[EMAIL PROTECTED] ~]$ rman > >Recovery Manager: Release 10.2.0.1.0 - Production on Tue May 8 15:53:54 >2007 > >Copyright (c) 1982, 2005, Oracle. All rights reserved. > >RMAN> connect target / > >connected to target database: ASMTEST (DBID=2970958671, not open) > >RMAN> run { >2> restore tablespace system; >3> recover tablespace system; >4> } > >Starting restore at 08-MAY-07 >using target database control file instead of recovery catalog >allocated channel: ORA_DISK_1 >channel ORA_DISK_1: sid=152 devtype=DISK > >channel ORA_DISK_1: starting datafile backupset restore >channel ORA_DISK_1: specifying datafile(s) to restore from backup set >restoring datafile 1 to +DG1/asmtest/system01.dbf >channel ORA_DISK_1: reading from backup piece >+RECOVERYDEST/asmtest/backupset/20 >07_05_08/nnndf0_tag20070508t155008_0.413.622050611 >channel ORA_DISK_1: restored backup piece 1 >piece >handle=+RECOVERYDEST/asmtest/backupset/2007_05_08/nnndf0_tag20070508t15500 >8_0.413.622050611 tag=TAG20070508T155008 >channel ORA_DISK_1: restore complete, elapsed time: 00:01:05 >Finished restore at 08-MAY-07 > >Starting recover at 08-MAY-07 >using channel ORA_DISK_1 > >starting media recovery >media recovery complete, elapsed time: 00:00:03 > >Finished recover at 08-MAY-07 > >RMAN> sql 'alter database open' >2> ; > >sql statement: alter database open > >RMAN> exit > > > > >abraço > >Sergio Leandro Ghellere >DBA Oracle >+55 (41) 9906-4813 > >On Tue May 8 18:27 , 'Everton Dias' <[EMAIL PROTECTED]> sent: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >Com a system tb é possível fazer isto ? > > > > > > > >Faria de que forma? Assim? > > > > > > > >Run {sql alter tablespace system offline immediate; > > > > Restore tablespace system; > > > > Recover tablespace system; > > > >} > > > > > > > >>From: Sergio Leandro Ghellere <[EMAIL PROTECTED]> > > > >>Reply-To: oracle_br@yahoogrupos.com.br > > > >>To: oracle_br@yahoogrupos.com.br > > > >>Subject: Re: [oracle_br] Corrompeu a system!!! > > > >>Date: Tue, 08 May 2007 15:10:29 -0300 > > > >> > > > >>vc pode restaurar somente o datafile da system e depois aplicar archived > > > >>redo logs.. > > > >>pra recuperar a system é rápido, normalmente não passa de 1g a tbs... > > > >> > > > >> > > > >>Sergio Leandro Ghellere > > > >>DBA Oracle > > > >>+55 (41) 9906-4813 > > > >> > > > >>On Tue May 8 18:03 , 'Evert
Re: [oracle_br] Corrompeu a system!!!
bom, primeiramente vc vai ter que estar com o banco em estado MOUNT. Então não é necessário o OFFLINE IMMEDIATE já que as tablespaces e arquivos de dados somente são verificadas do estado MOUNT para OPEN. daí não sei como são os labels do seu backup, então vc faz o restore do ultimo backup da tablespace (exatamente como colocasse no script) e depois o recover. simulei aqui somente uma perda da tablespace system... [EMAIL PROTECTED] ~]$ . oraenv ORACLE_SID = [asmtest] ? +ASM [EMAIL PROTECTED] ~]$ asmcmd ASMCMD> cd DG1/ASMTEST ASMCMD> rm system01.dbf ASMCMD> exit [EMAIL PROTECTED] ~]$ . oraenv ORACLE_SID = [+ASM] ? asmtest [EMAIL PROTECTED] ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 8 15:53:20 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 209715200 bytes Fixed Size 1218556 bytes Variable Size 79693828 bytes Database Buffers 125829120 bytes Redo Buffers2973696 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '+DG1/asmtest/system01.dbf' SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options [EMAIL PROTECTED] ~]$ rman Recovery Manager: Release 10.2.0.1.0 - Production on Tue May 8 15:53:54 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. RMAN> connect target / connected to target database: ASMTEST (DBID=2970958671, not open) RMAN> run { 2> restore tablespace system; 3> recover tablespace system; 4> } Starting restore at 08-MAY-07 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=152 devtype=DISK channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 1 to +DG1/asmtest/system01.dbf channel ORA_DISK_1: reading from backup piece +RECOVERYDEST/asmtest/backupset/20 07_05_08/nnndf0_tag20070508t155008_0.413.622050611 channel ORA_DISK_1: restored backup piece 1 piece handle=+RECOVERYDEST/asmtest/backupset/2007_05_08/nnndf0_tag20070508t15500 8_0.413.622050611 tag=TAG20070508T155008 channel ORA_DISK_1: restore complete, elapsed time: 00:01:05 Finished restore at 08-MAY-07 Starting recover at 08-MAY-07 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:03 Finished recover at 08-MAY-07 RMAN> sql 'alter database open' 2> ; sql statement: alter database open RMAN> exit abraço Sergio Leandro Ghellere DBA Oracle +55 (41) 9906-4813 On Tue May 8 18:27 , 'Everton Dias' <[EMAIL PROTECTED]> sent: > > > > > > > > > > > > > > > > > >Com a system tb é possível fazer isto ? > > > >Faria de que forma? Assim? > > > >Run { sql alter tablespace system offline immediate; > > Restore tablespace system; > > Recover tablespace system; > > } > > > >>From: Sergio Leandro Ghellere <[EMAIL PROTECTED]> > >>Reply-To: oracle_br@yahoogrupos.com.br > >>To: oracle_br@yahoogrupos.com.br > >>Subject: Re: [oracle_br] Corrompeu a system!!! > >>Date: Tue, 08 May 2007 15:10:29 -0300 > >> > >>vc pode restaurar somente o datafile da system e depois aplicar archived > >>redo logs.. > >>pra recuperar a system é rápido, normalmente não passa de 1g a tbs... > >> > >> > >>Sergio Leandro Ghellere > >>DBA Oracle > >>+55 (41) 9906-4813 > >> > >>On Tue May 8 18:03 , 'Everton Dias' <[EMAIL PROTECTED]> sent: > >> > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > >> >SQL> show sga > >> > > >> > > >> > > >> >Total System Global Area 689510136 bytes > >> > > >> >Fixed Size 452344 bytes > >> > > >> >Variable Size 150994944 bytes > >> > > >> >Database Buffers 536870912 bytes > >> > > >> >Redo Buffers1191936 bytes > >> > > >> >SQL> alter database open; > >> > > >> >alter database open > >> > > >> >ERROR at li
Re: [oracle_br] Corrompeu a system!!!
Com a system tb é possível fazer isto ? Faria de que forma? Assim? Run { sql alter tablespace system offline immediate; Restore tablespace system; Recover tablespace system; } >From: Sergio Leandro Ghellere <[EMAIL PROTECTED]> >Reply-To: oracle_br@yahoogrupos.com.br >To: oracle_br@yahoogrupos.com.br >Subject: Re: [oracle_br] Corrompeu a system!!! >Date: Tue, 08 May 2007 15:10:29 -0300 > >vc pode restaurar somente o datafile da system e depois aplicar archived >redo logs.. >pra recuperar a system é rápido, normalmente não passa de 1g a tbs... > > >Sergio Leandro Ghellere >DBA Oracle >+55 (41) 9906-4813 > >On Tue May 8 18:03 , 'Everton Dias' <[EMAIL PROTECTED]> sent: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >SQL> show sga > > > > > > > >Total System Global Area 689510136 bytes > > > >Fixed Size 452344 bytes > > > >Variable Size 150994944 bytes > > > >Database Buffers 536870912 bytes > > > >Redo Buffers1191936 bytes > > > >SQL> alter database open; > > > >alter database open > > > >ERROR at line 1: > > > >ORA-12801: error signaled in parallel query server P000 > > > >ORA-01172: recovery of thread 1 stuck at block 3472 of file 2 > > > >ORA-01151: use media recovery to recover block, restore backup if needed > > > > > > > >Trata-se de um bloco da system, e agora só com restore de fita ? > > > > > > > >Alguma dica mais rápida ? > > > > > > > >__ > > > >MSN Busca: fácil, rápido, direto ao ponto. http://search.msn.com.br > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Hospede seu site no Onda Empresas _ MSN Busca: fácil, rápido, direto ao ponto. http://search.msn.com.br
Re: [oracle_br] Corrompeu a system!!!
vc pode restaurar somente o datafile da system e depois aplicar archived redo logs.. pra recuperar a system é rápido, normalmente não passa de 1g a tbs... Sergio Leandro Ghellere DBA Oracle +55 (41) 9906-4813 On Tue May 8 18:03 , 'Everton Dias' <[EMAIL PROTECTED]> sent: > > > > > > > > > > > > > > > > > > > >SQL> show sga > > > >Total System Global Area 689510136 bytes > >Fixed Size 452344 bytes > >Variable Size 150994944 bytes > >Database Buffers 536870912 bytes > >Redo Buffers1191936 bytes > >SQL> alter database open; > >alter database open > >ERROR at line 1: > >ORA-12801: error signaled in parallel query server P000 > >ORA-01172: recovery of thread 1 stuck at block 3472 of file 2 > >ORA-01151: use media recovery to recover block, restore backup if needed > > > >Trata-se de um bloco da system, e agora só com restore de fita ? > > > >Alguma dica mais rápida ? > > > >__ > >MSN Busca: fácil, rápido, direto ao ponto. http://search.msn.com.br > > > > > > > > > > > > > > > > > Hospede seu site no Onda Empresas
[oracle_br] Corrompeu a system!!!
SQL> show sga Total System Global Area 689510136 bytes Fixed Size 452344 bytes Variable Size 150994944 bytes Database Buffers 536870912 bytes Redo Buffers1191936 bytes SQL> alter database open; alter database open * ERROR at line 1: ORA-12801: error signaled in parallel query server P000 ORA-01172: recovery of thread 1 stuck at block 3472 of file 2 ORA-01151: use media recovery to recover block, restore backup if needed Trata-se de um bloco da system, e agora só com restore de fita ? Alguma dica mais rápida ? _ MSN Busca: fácil, rápido, direto ao ponto. http://search.msn.com.br