Re: Datafile recovery

On Wed, 07 May 1997 23:51:05 -0600, anaik_at_bom2.vsnl.net.in wrote:

>We have Oracle 7.3.2.2 on HP-UX 10.x. We took a tar backup of the
>datafiles of a tablespace thinking that we could restore them whenver we
>required. However we found out that the datfiles cannot be recovered just
>by copying them(which is quite obvious, as ORACLE would need the log files
>of that time) after untaring and ORACLE keeps giving the error "datafile
>needs media recovery". When tried media recovery it gives some suggestion
>for archive log.
> Can anybody help in how to achieve this restoration?
>Thanks in advance.
>Amol.
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

Are you archiving? If not, then you will have to go back to your most recent full backup and restore. If you have a more recent export, you may be able to recover from that. Be careful to ensure that the data you are recovering this way is not dependent on other tablespaces. Otherwise you may end up with orphans.

-sheilah scheurich
scheuric_at_sprynet.com
dba Received on Thu May 08 1997 - 00:00:00 CDT