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 Buffers 2973696 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 00001 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 Buffers 1191936 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>---- Hospede seu site no Onda Empresas
_________________________________________________________________
MSN Busca: fácil, rápido, direto ao ponto. http://search.msn.com.br
