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 ?
> >
>
>
Received on Tue Nov 30 1999 - 06:24:37 CST