Re: Datafile recovery

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