| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_level1.com]
> Reply To: ORACLE-L_at_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_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...
> > >
> ________________________________________________________________________
> > >
> > --
> > Author: Wasserman, Sara
> > INET: sjwasserman_at_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_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).
> >
>
> --
> 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).
>
------_=_NextPart_001_01BFF1EC.6C8C7570
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Dus-ascii">
<TITLE>RE: question</TITLE> </HEAD> <BODY>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Hi,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">After bringing =
datafile how to recreate control file.Can U please give the syntax and =
a small example.</FONT>
</P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards</FONT> <BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Siva</FONT> </P> <UL> <P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> = <FONT SIZE=3D1 FACE=3D"MS Sans Serif">Roy =Ferguson[SMTP:rferguso_at_level1.com]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Reply To:</FONT></B> = <FONT SIZE=3D1 FACE=3D"MS Sans = Serif">ORACLE-L_at_fatcity.com</FONT>
<P><FONT SIZE=3D2 FACE=3D"Arial">I didn't catch the fact that I missed =
one of the datafiles until a week after </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">the database was being used by =
developers...I know...shame on me...looks like </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I'll be rebuilding the =
indexes...</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">thanks for the =
assistance...Roy</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">> </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> Have you tried to bring over the =
missing datafile and recreate the control</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> file again? This may work =
only if 1) you have the original of the missing</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> datafile from the same time =
period as the other datafiles that you</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> successfully copied over (i.e., =
if you copied the files over from a backup;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> and 2) you haven't done any work =
in the new database.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> Alternatively, since it is an =
index tablespace, you could try dropping the</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> tablespace altogether, then =
recreating the tablespace and rebuilding all the</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> indexes in it.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> HTH,</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Sara Wasserman</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > -----Original =Message-----</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> > </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > >ok here is my =situation..</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> > >index</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > >tablespace...</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > ></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > >error when trying to =create an index:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> > ></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > >ERROR at line 2:</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > >ORA-00376: file 81 =cannot be read at this time</FONT>
________________________________________________________________________= </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> > </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> -- </FONT><BR><FONT SIZE=3D2 FACE=3D"Arial">> Author: Wasserman, Sara</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> INET: = sjwasserman_at_pscnet.com</FONT>
--------------------------------------------------------------------</FO=NT>
<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Roy Ferguson</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> INET: =rferguso_at_level1.com</FONT>
<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network =
Services -- (858) 538-5051 FAX: (858) =
538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------------------------=-----------</FONT>
 |
 |