Re: Datafile recovery

Pierre wrote:
>
> In article <863021462.12470_at_dejanews.com>, anaik_at_bom2.vsnl.net.in says...
> >
> >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
>
> Unless you've been running your databasa in ARCHIVELOG MODE and have
> all the archive log files since the last backup of your datafiles
> there is nothing much you can do. There is a way however to start
> the database but it will be unusable and corrupted.
>
> Pierre Roussin
> Oracle DBA Consultant
> Warp Design, Montreal

Creating control file again with reuse option may solve the problem. But I am not sure about it.

Sudheer

--