Re: recreating a create database file

I just logged on to sqlplus using the logon / as sysdba and did an 'alter controlfile backup controlfile to trace;'  This creates a file in your dump destination.  Then you can recreate the db using this file. 
 
HTH,
Ruth
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">laura pena To: <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">Multiple recipients of list ORACLE-L

  Sent: Tuesday, June 17, 2003 1:29
PM
  Subject: Re: recreating a create database   file   

   
  Ruth,
  Ummm how did you do this in 9i?
   
  Thanks,
  -LizzRuth Gramolini <<A
  href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]>   wrote:
  <BLOCKQUOTE
  style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">I     got the answer, thanks anyway. Ruth----- Original Message -----     To: "Multiple recipients of list ORACLE-L"     Sent: Tuesday, June 17, 2003 10:09
    AM> Good morning all,> > Somehow all of my     scripts to create the databases on my 9i sandbox have> disappeared.     Does anyone have a script or trick or something to recreate> these     files? I could recreate them manually but I am somewhat of a time>     crunch.> > Thanks in advance,> Ruth> >
> -- > Please see the official ORACLE-L FAQ:
    http://www.orafaq.net> -- > Author: Ruth Gramolini>     INET: [EMAIL PROTECTED]> > Fat City Network Services

• 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> ---------------------------------------------------------------------> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ruth GramoliniINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).

  Do you Yahoo!?<A
  href="http://pa.yahoo.com/*http://rd.yahoo.com/evt=1207/*http://promo.yahoo.com/sbc/">SBC   Yahoo! DSL - Now only $29.95 per month! Received on Thu Jun 19 2003 - 13:31:50 CDT