Velpuri's book on backup and recovery has a number of case studies. You
didn't say whether you have the DEV db in archivelog mode but here's my best
shot. Get a backup file from a backup made before you copied the datafiles.
Restore that datafile and do a tablespace level recovery. You'll need the
archives from the production box. I assume you're in archive mode on the
production box at least. Go out and get the book now. It's indispensible.
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Roy
> Ferguson
> Sent: Wednesday, July 19, 2000 5:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: database recreate problem
>
>
>
> 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: Roy Ferguson
> INET: rferguso_at_level1.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 - 20:04:05 CDT
