I didn't catch the fact that I missed one of the datafiles until a week after
the database was being used by developers...I know...shame on me...looks like
I'll be rebuilding the indexes...
thanks for the assistance...Roy
>
> Have you tried to bring over the missing datafile and recreate the control
> file again? This may work only if 1) you have the original of the missing
> datafile from the same time period as the other datafiles that you
> successfully copied over (i.e., if you copied the files over from a backup;
> and 2) you haven't done any work in the new database.
>
> Alternatively, since it is an index tablespace, you could try dropping the
> tablespace altogether, then recreating the tablespace and rebuilding all the
> indexes in it.
>
> HTH,
> Sara Wasserman
>
> > -----Original Message-----
> > From: Roy Ferguson [SMTP:r__ferguson_at_hotmail.com]
> > Sent: Wednesday, July 19, 2000 5:01 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: question
> >
> >
> > >ok here is my situation..
> > >
> > >I created a development database from a production database by moving
> > >datafiles
> > >and recreating the control file on the development box...Sun
> > >environment...Oracle 8.0.5
> > >
> > >I brought up the development database and all looked good until I noticed
> > >that I
> > >failed to move over a datafile...this is datafile #2 of a two datafile
> > >index
> > >tablespace...
> > >
> > >error when trying to create an index:
> > >
> > >ERROR at line 2:
> > >ORA-00376: file 81 cannot be read at this time
> > >ORA-01111: name for data file 81 is unknown - rename to correct file
> > >ORA-01110: data file 81: '/u21/oracle/product/8.0.5/dbs/MISSING00081'
> > >
> > >I'm looking for ideas on recovery methods...
> > >
> > >thanks in advance...
> > ________________________________________________________________________
> >
> --
> Author: Wasserman, Sara
> INET: sjwasserman_at_pscnet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 19 2000 - 19:41:33 CDT
