RE: database recreate problem

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Thu, 20 Jul 2000 10:10:41 -0300
Message-Id: <10564.112532@fatcity.com>

If you created your database in ARCHIVELOG or if you didn't have = activity
enough to loose all the information from the redo logs, you could issue = an
alter database create datafile 'MISSING00081' as '<real file name >';. = And
then you can recover the datafile with the stmt: recover datafile = '<real
file name>'.

Regards.

> -----Mensaje original-----
> De: Roy Ferguson [SMTP:rferguso_at_level1.com]
> Enviado el: Mi=E9rcoles 19 de Julio de 2000 21:08
> Para: Multiple recipients of list ORACLE-L
> Asunto: database recreate problem

>=20
>=20

> ok here is my situation..

>=20

> I created a development database from a production database by moving
> datafiles=20
> and recreating the control file on the development box...Sun=20
> environment...Oracle 8.0.5

>=20
> I brought up the development database and all looked good until I =
noticed
> that I=20
> failed to move over a datafile...this is datafile #2 of a two =
datafile
> index=20
> tablespace...

>=20

> error when trying to create an index:

>=20

> 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'

>=20

> I'm looking for ideas on recovery methods...

>=20

> thanks in advance...

>=20

> --=20
> Author: Roy Ferguson
> INET: rferguso_at_level1.com

>=20


> 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 Thu Jul 20 2000 - 08:10:41 CDT