Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: File needs media recovery after recovery :(
"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:40b741cf$1_at_olaf.komtel.net...
> Thank you guys,
>
> not just HJR but everyone who took the time to respond. Learned a lot.
We
> will revise our backup policies and server configurations to avoid this
> situation in the future.
>
> In order to handle the current case I have decided to drop the
corrupted
> tablespace, re-create it from scratch and import data from a dump (logical
> backup created through "exp" 2 days ago.). This worked out fine and
allowed
> us to at least have all other data outside BUGEN.ora to remain up to date.
> BUGEN.ora lost 2 days but as I have learned from all your contributions
that
> was inevitable because the archived logs got lost with the physical
backup.
>
> André
> :)
I should have mentioned the possibility of doing something like that, so my apologies. By the time I thought of it, I saw that "s.kapitza" had done the deed anyway. Glad you got most of it back, anyway.
Regards
HJR
Received on Fri May 28 2004 - 13:40:37 CDT