Re: File needs media recovery after recovery :(

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message 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.

If you are doing a 'set until', you are doing an INcomplete recovery. And in incomplete recoveries, you must restore database; and recover database;, not individual data files.

What are the things which cause us to need to do incomplete recovery?

1. User error (delete from important_table;...commit;)
2. Loss of all members of the current redo log
3. A complete recovery can't be completed because of the loss of some required archive logs

You fall squarely into category c.

Regards
HJR Received on Thu May 27 2004 - 14:15:16 CDT