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
