Re: How to recover datafiles without archive logs?

The only other two options you have is restore the last cold backup and issue an alter database open resetlogs
(and anything that happened after that cold backup is 'lost' forever) or import the data from an export, but I have a feeling you're not making exports also.

Sorry,

--
Sybrand Bakker, Oracle DBA
Tyson Bigler <bigler_at_shellus.com> wrote in message news:EjP04.71824$5W2.1994534_at_news6.giganews.com...
> 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 - 12:58:46 CST