database recreate problem

From: Roy Ferguson <rferguso_at_level1.com>
Date: Wed, 19 Jul 2000 16:02:23 -0700
Message-Id: <10563.112472@fatcity.com>

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 - 18:02:23 CDT