Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> File needs media recovery after recovery :(

File needs media recovery after recovery :(

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Thu, 27 May 2004 18:15:15 +0200
Message-ID: <40b61413$1@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. Received on Thu May 27 2004 - 11:15:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US