Re: question

From: arun <arun_k_c_at_hotmail.com>
Date: Wed, 19 Jul 2000 23:32:40 -0400
Message-Id: <10563.112492@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0011_01BFF1D9.A1133110 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

RE: questiondo the following command alter database backup controlfile = to trace;
this will create a .trc file in the udump dir if you open this it will give you the exact creation of the database

Original Message -----=20 From: Siva_Chintalapati=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, July 19, 2000 11:04 PM Subject: RE: question

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

Regards=20
Siva=20

----------=20
From: Roy Ferguson[SMTP:rferguso_at_level1.com]=20 Reply To: ORACLE-L_at_fatcity.com=20 Sent: Thursday, July 20, 2000 7:15 AM=20

    To:     Multiple recipients of list ORACLE-L=20
    Subject:        RE: question=20

I didn't catch the fact that I missed one of the datafiles until a = week after=20

the database was being used by developers...I know...shame on = me...looks like=20

I'll be rebuilding the indexes...=20 thanks for the assistance...Roy=20

>=20
> Have you tried to bring over the missing datafile and recreate the =
control=20

> file again? This may work only if 1) you have the original of the =
missing=20

> 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;=20

> and 2) you haven't done any work in the new database.=20
>=20
> Alternatively, since it is an index tablespace, you could try =
dropping the=20

> tablespace altogether, then recreating the tablespace and =
rebuilding all the=20

> indexes in it.=20

    >=20

> HTH,=20
> Sara Wasserman=20

    >=20


    > > -----Original Message-----=20

    > > From:       Roy Ferguson [SMTP:r__ferguson_at_hotmail.com]=20

    > > Sent:       Wednesday, July 19, 2000 5:01 PM=20

    > > To: Multiple recipients of list ORACLE-L=20

    > > Subject:    question=20

    > >=20

    > >=20

    > > >ok here is my situation..=20

> > >=20
> > >I created a development database from a production database by =
moving=20

> > >datafiles=20
> > >and recreating the control file on the development box...Sun=20
> > >environment...Oracle 8.0.5=20
> > >=20
> > >I brought up the development database and all looked good until =
I noticed=20

> > >that I=20
> > >failed to move over a datafile...this is datafile #2 of a two =
datafile=20

> > >index=20
> > >tablespace...=20
> > >=20
> > >error when trying to create an index:=20
> > >=20
> > >ERROR at line 2:=20
> > >ORA-00376: file 81 cannot be read at this time=20
> > >ORA-01111: name for data file 81 is unknown - rename to correct =
file=20

> > >ORA-01110: data file 81: =

'/u21/oracle/product/8.0.5/dbs/MISSING00081'=20

> > >=20
> > >I'm looking for ideas on recovery methods...=20
> > >=20
> > >thanks in advance...=20
> > =

________________________________________________________________________ =

> >=20
> --=20
> Author: Wasserman, Sara=20
> INET: sjwasserman_at_pscnet.com=20

>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) =
538-5051=20

> San Diego, California -- Public Internet access / Mailing =
Lists=20

> =

--------------------------------------------------------------------=20

> To REMOVE yourself from this mailing list, send an E-Mail message=20
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and =
in=20

> the message BODY, include a line containing: UNSUB ORACLE-L=20
> (or the name of mailing list you want to be removed from). You =
may=20

> also send the HELP command for other information (like =
subscribing).=20

>=20

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

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing = Lists=20

To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing). =

------=_NextPart_000_0011_01BFF1D9.A1133110 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: question</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>do the following command alter database =

backup=20
controlfile to trace;</DIV>
<DIV>this will create a .trc file in the = udump=20
dir</DIV>
<DIV>if you open this it will give you the = exact=20
creation of the database</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A title=3DSiva_Chintalapati_at_satyam.com=20 href=3D"mailto:Siva_Chintalapati_at_satyam.com">Siva_Chintalapati</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">To: <A = title=3DORACLE-L_at_fatcity.com=20
 href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
 </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Wednesday, July 19, 2000 = 11:04=20
 PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: question</DIV>
  <DIV><BR></DIV>
  <P><FONT face=3DArial color=3D#0000ff size=3D2>Hi,</FONT> <BR><FONT =

face=3DArial=20
 color=3D#0000ff size=3D2>After bringing datafile how to recreate = control file.Can=20
 U please give the syntax and a small example. Regards = Siva <UL>
 ---------- = <FONT=20

face=3D"MS Sans Serif" size=3D1>From:   <FONT=20 face=3D"MS Sans Serif" size=3D1>Roy = Ferguson[SMTP:rferguso_at_level1.com]=20

Reply To:=20       <A=20

href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A> =

Sent:   = <FONT=20

face=3D"MS Sans Serif" size=3D1>Thursday, July 20, 2000 7:15 = AM=20

To: =    =20

Multiple recipients of list=20 ORACLE-L Subject:=20

RE:=20

question 
I didn't catch the fact that I missed = one of the=20

datafiles until a week after the database=20

was being used by developers...I know...shame on me...looks like=20 I'll be rebuilding the = indexes...=20

thanks for the = assistance...Roy

> > Have=20

you tried to bring over the missing datafile and recreate the = control=20

> file again?  This may work = only if 1)=20

you have the original of the missing >=20

datafile from the same time period as the other datafiles that = you=20

> successfully copied over (i.e., = if you=20

copied the files over from a backup; >=20

and 2) you haven't done any work in the new database. = <FONT=20

face=3DArial size=3D2>> >=20

Alternatively, since it is an index tablespace, you could try = dropping=20

the > tablespace = altogether, then=20

recreating the tablespace and rebuilding all the <FONT = face=3DArial=20

size=3D2>> indexes in it. >=20

> HTH, <FONT = face=3DArial=20

size=3D2>> Sara Wasserman >=20

> > -----Original=20 Message----- > >=20 From:       Roy Ferguson=20 [SMTP:r__ferguson_at_hotmail.com] > >=20

Sent:       Wednesday, July 19, 2000 = 5:01=20

PM > > To: Multiple = recipients of=20

list ORACLE-L > >=20 Subject:    question >=20

> > > = <FONT=20

face=3DArial size=3D2>> > >ok here is my situation.. = <FONT=20

face=3DArial size=3D2>> > > >=20

> >I created a development database from a production database = by=20

moving > > = >datafiles=20

> > >and recreating the = control file on=20

the development box...Sun > >=20

>environment...Oracle 8.0.5 > >=20

> > > >I brought = up the=20

development database and all looked good until I noticed = <FONT=20

face=3DArial size=3D2>> > >that I <FONT = face=3DArial=20

size=3D2>> > >failed to move over a datafile...this is = datafile #2 of=20

a two datafile > > = >index=20

> > >tablespace... = <FONT=20

face=3DArial size=3D2>> > > >=20

> >error when trying to create an index: <FONT = face=3DArial=20

size=3D2>> > > > = > >ERROR=20

at line 2: > > = >ORA-00376: file=20

81 cannot be read at this time > >=20

>ORA-01111: name for data file 81 is unknown - rename to correct=20 file > > >ORA-01110: = data file=20

81: '/u21/oracle/product/8.0.5/dbs/MISSING00081' <FONT = face=3DArial=20

size=3D2>> > > > = > >I'm=20

looking for ideas on recovery methods... <FONT = face=3DArial=20

size=3D2>> > > > = >=20

>thanks in advance... > = >=20

________________________________________________________________________<=

/FONT>=20
 > > <FONT = face=3DArial=20

size=3D2>> -- > Author: = Wasserman,=20

Sara >   INET:=20 sjwasserman_at_pscnet.com >=20 > Fat City Network=20 Services    -- (858) 538-5051  FAX: (858)=20 538-5051 > San Diego,=20 California        -- Public = Internet=20

access / Mailing Lists >=20 =

--------------------------------------------------------------------</FON=

T>=20

> To REMOVE yourself from this = mailing list,=20

send an E-Mail message > = to:=20

ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in=20

> the message BODY, include a = line=20

containing: UNSUB ORACLE-L > (or the=20

name of mailing list you want to be removed from).  You = may=20

> also send the HELP command for = other=20

information (like subscribing). >=20

-- Author: Roy=20

Ferguson   INET:=20 rferguso_at_level1.com 
Fat City Network = Services    --=20

(858) 538-5051  FAX: (858) 538-5051 <FONT = face=3DArial=20

size=3D2>San Diego, =
California        --=20

Public Internet access / Mailing Lists <FONT face=3DArial =

size=3D2>----------------------------------------------------------------=

----=20

To REMOVE yourself from this mailing = list, send=20

an E-Mail message to:=20 ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in=20

the message BODY, include a line = containing:=20 Received on Wed Jul 19 2000 - 22:32:40 CDT