RE: question

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Wed, 19 Jul 2000 19:51:03 -0700
Message-Id: <10563.112489@fatcity.com>

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_01BFF1F5.57DE2100
Content-Type: text/plain;

charset="iso-8859-1"

Hi siva,

SQL> alter database backup controlfile to trace; --> generate new create control file syntax into a trace file

SQL> show parameter user_dump_dest --> this is where the trace is generated .. for e.g. /oradump/udump

$ ls -lrt /oradump/udump -->

the last file is the one which contains ur control file definition .. for e.g. scores_ora_27046.trc. edit that file .. clean up that file of all junk and execute it from svrmgrl

u r all set.. please ask for more help from the list in case u still get stuck. best of luck

deepAk

-----Original Message-----
From: Siva_Chintalapati [mailto:Siva_Chintalapati_at_satyam.com] Sent: Wednesday, July 19, 2000 8:04 PM
To: Multiple recipients of list ORACLE-L Subject: RE: question

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_01BFF1F5.57DE2100
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: question</TITLE>

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>

<BODY>

<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=750314102-20072000>Hi 
siva,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN

class=750314102-20072000> </DIV> <DIV>SQL> alter database backup controlfile to trace; --> generate new create control file syntax into a trace file </DIV>
<DIV> </DIV> <DIV>SQL> show parameter user_dump_dest --> this is where the trace is generated .. for e.g. /oradump/udump</DIV> <DIV> </DIV>
<DIV>$ ls -lrt /oradump/udump --></DIV> <DIV>   the last file is the one which contains ur control file definition .. for e.g. scores_ora_27046.trc. edit that file .. clean up that file of all junk and execute it from svrmgrl </DIV>

<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=750314102-20072000>&nbsp; 
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=750314102-20072000>u r

all set.. please ask for more help from the list in case u still get stuck. best of luck</DIV>
<DIV> </DIV>
<DIV>deepAk</DIV> <DIV> </DIV> <BLOCKQUOTE>
 <DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Siva_Chintalapati [mailto:Siva_Chintalapati_at_satyam.com] Sent: Wednesday, July 19, 2000 8:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: question </DIV>
 Hi, After bringing datafile how to recreate control file.Can U please give the syntax and a small example. Regards Siva <UL>
 ---------- From:   Roy Ferguson[SMTP:rferguso_at_level1.com] Reply To:       ORACLE-L_at_fatcity.com Sent:   Thursday, July 20, 2000 7:15 AM <FONT face="MS Sans Serif"

    size=1>To:</FONT></B> &nbsp;&nbsp;&nbsp; <FONT face="MS Sans Serif" 
    size=1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT 
    face="MS Sans Serif" size=1>Subject:</FONT></B>

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

    </FONT><BR><FONT face=Arial size=2>I'll be rebuilding the indexes...</FONT> 
    <BR><FONT face=Arial size=2>thanks for the assistance...Roy</FONT> </P>
    <P><FONT face=Arial size=2>&gt; </FONT><BR><FONT face=Arial size=2>&gt; 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 <FONT face=Arial

    size=2>&gt; indexes in it.</FONT> <BR><FONT face=Arial size=2>&gt; 
    </FONT><BR><FONT face=Arial size=2>&gt; HTH,</FONT> <BR><FONT face=Arial 
    size=2>&gt; Sara Wasserman</FONT> <BR><FONT face=Arial size=2>&gt; 
    </FONT><BR><FONT face=Arial size=2>&gt; &gt; -----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... > >

    ________________________________________________________________________</FONT>

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

    --------------------------------------------------------------------</FONT>

> 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 <FONT face=Arial

    size=2>--------------------------------------------------------------------</FONT>

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 Received on Wed Jul 19 2000 - 21:51:03 CDT