Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> File needs media recovery after recovery :(
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>
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
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