Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Lost controlfile

Re: Lost controlfile

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 4 Feb 2002 08:44:11 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7BB7703@lnewton.leeds.lfs.co.uk>


You could use another database and get a controlfile trace for that as detailed by a previous post, then edit it to change the filenames for your logfiles and datafiles and the database name etc as appropriate. At least that way you don't have to worry about making up the correct syntax. :o)

Then, when you get the three controlfiles rebuilt, move a couple of them to another vg (after shutting down !) and change the initSID.ora file to reflect their new location.

HTH Norman.



Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com

------------------------------------------------------------------------

-----Original Message-----

From: Amadou O. Wane [mailto:wane_at_strategisconsulting.com] Posted At: Saturday, February 02, 2002 3:22 PM Posted To: server
Conversation: Lost controlfile
Subject: Re: Lost controlfile

I lost all three when making changes to a volume group. Received on Mon Feb 04 2002 - 02:44:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US