RE: question

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...
> ________________________________________________________________________
Received on Wed Jul 19 2000 - 19:09:25 CDT