How to recover datafiles without archive logs?

I have two datafiles that I had to take offline due to a disk problem (I needed the rest of the db up). The same disk was brought back online and I tried to do bring the datafiles back online. However, we are running in No Archive Mode because the data is pretty static. So, to take the files offline I had to do a 'offline drop'. Now I'm unable to bring them back online because it thinks it needs to do media recovery. I've tried to 'recover datafile', but it prompts for a non-existent archive log (remember we're not running in archive mode). I've even tried 'recover database until', but it still wants a log!! Is there _any_ way that I can bring these two files back online (forcefully)?? While it's true that the data is static, it'll be painful if I have to reload that tablespace (about one week of CPU time)...

Any help is _greatly_ appreciated!

Thanks!

--
Tyson Bigler                Shell Technology Exploration & Production Co.
Infrastructure Support      Bellaire Technology Center
bigler_at_shellus.com          3737 Bellaire Blvd., Room 1051B
713-245-7476                Houston, TX 77025

Keith Boulton <boulke_at_globalnet.co.uk> wrote in message
news:383961df.753034_at_read.news.globalnet.co.uk...


> On Mon, 22 Nov 1999 16:00:13 +0530, Vidya


> <india1_at_bv3c4.austin.ibm.com> wrote:

>

> >Hi ,

> >

> >I had backed a Oracle dbf file using backup / restore commands of Unix

> >and restored from tape with unix command.

> >Then from the Oracle Server Manager  I put the file into the database

> >but

> >it resulted in Media failure.

>

> Oracle detects the fact that the recoved data file is older than

> expected from the control file and presumably gave you an error

> message like: ORA-01113: file 6 needs media recovery

>

> Issuing alter database recover datafile instructs the database to

> re-apply changes from the online/archived redo-logs as required to

> bring the datafile into line with the rest of the database. I imagine

> you were simply experimenting so no actual recovery was required, so

> the datafile header is simply synchronised with the control file as

> stated by your dba friend.

>

> >I did "alter database <database name>

> >             recover datafile <path where the datafile has been copied"

> >On doing this the database got connected.

> >Since I am not a DBA I have these set of doubts :

> >Now , my doubts are how has this "alter database ..." command helped in

> >correcting the restored dbf file.

> >But,  my DBA friend told me that "alter database ..." command has helped

> >the newer

> >restored file in getting seq with Ctrl and database file , is it right ?

> >

>

>