Re: File needs media recovery after recovery :(

"André Hartmann" <andrehartmann_at_hotmail.com> schrieb im Newsbeitrag news:40b61413$1_at_olaf.komtel.net...
> Hi there,
>
> yesterday I had a media failure on one of my data files (Win2000, Ora9i,
> Archivelog mode) and after recovery (with catalog) up to a certain archived
> log rman tells me the corresponding table space cant go back online because
> it needs media recovery
>
> run {
> allocate channel Kanal1 type disk format
> 'G:\OracleServer\oradata\webhost3\backup\WEBHOST3_78FMJTQ2_1_1.ORACLE.BACKUP
> ';
> set until sequence 8575 thread 1;
> recover datafile "E:\ORACLESERVER\ORADATA\WEBHOST3\BUGEN.ORA";
> sql 'alter tablespace "BUGEN" online';
> }
>
> gives me:
>
> RMAN> run {
> 2> allocate channel Kanal1 type disk format
> 'G:\OracleServer\oradata\webhost3\ba
> ckup\WEBHOST3_78FMJTQ2_1_1.ORACLE.BACKUP';
> 3> set until sequence 8575 thread 1;
> 4>recover datafile "E:\ORACLESERVER\ORADATA\WEBHOST3\BUGEN.ORA";
> 5> sql 'alter tablespace "BUGEN" online';
> 6> }
> 7>
> Zugewiesener Kanal: Kanal1
> Kanal Kanal1: SID=80 Gerõtetyp=DISK
>
> Befehl wird ausgef³hrt: SET until clause
>
> Starten recover um 27.05.04
>
> Starte Wiederherstellung des Datentrõgers
> Wiederherstellung des Datentrõgers beendet
>
> Beendet recover um 27.05.04
>
> SQL-Anweisung: alter tablespace "BUGEN" online
> Freigegebener Kanal: Kanal1
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03009: failure of sql command on default channel at 05/27/2004 18:11:33
> RMAN-11003: failure during parse/execution of SQL statement: alter
> tablespace "B
> UGEN" online
> ORA-01113: F³r Datei '12' ist Datentrõger-Recovery notwendig
> ORA-01110: Datendatei 12: 'E:\ORACLESERVER\ORADATA\WEBHOST3\BUGEN.ORA'
>
> Recovery Manager abgeschlossen.
>
> Any idea why ? I was expecting the tablespace to be online after the
> recovery.
>
> PS: I have to apply "set until" because later archived logs are lost because
> a backup got lost.

<*Don't try this offhand*>
Do you have to "open resetlogs"?
</>

Lots of Greetings!
Volker Received on Thu May 27 2004 - 13:10:49 CDT