Re: File needs media recovery after recovery :(

"Volker Hetzer" <volker.hetzer_at_ieee.org> schrieb im Newsbeitrag news:c95av9$920$1_at_nntp.fujitsu-siemens.com...
>
> "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"?
> </>

I am sorry but what do you mean by that ????? close and re-opwen the database with resetlogs ? I cannot shutdown the dataabse. it needs 24/7 availability.

>
> Lots of Greetings!
> Volker
>
Received on Thu May 27 2004 - 15:33:43 CDT