Message-Id: <10563.112486@fatcity.com> From: Siva_Chintalapati Date: Thu, 20 Jul 2000 07:16:34 +0530 Subject: RE: question This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFF1EC.6C8C7570 Content-Type: text/plain Hi, After bringing datafile how to recreate control file.Can U please give the syntax and a small example. Regards Siva > ---------- > From: Roy Ferguson[SMTP:rferguso@level1.com] > Reply To: ORACLE-L@fatcity.com > Sent: Thursday, July 20, 2000 7:15 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: question > > > 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@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@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@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). > > > > -- > Author: Roy Ferguson > INET: rferguso@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@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). > ------_=_NextPart_001_01BFF1EC.6C8C7570 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: question

Hi,
After bringing = datafile how to recreate control file.Can U please give the syntax and = a small example.

Regards
Siva