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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temporarily Renaming the sgadefSID.dbf File

RE: Temporarily Renaming the sgadefSID.dbf File

From: Morrow, Steve <SMorrow_at_admin.usf.edu>
Date: Tue, 17 Apr 2001 07:00:11 -0700
Message-ID: <F001.002EAA99.20010417054610@fatcity.com>

Good Morning!

Just wanted to thank everybody for their responses and excellent feedback. Renaming the file worked like a charm. This allowed me to create the controlfile of the new database and bring it up w/o any problems.

Now I know :-)

Steve

> -----Original Message-----
> From: Morrow, Steve
> Sent: Tuesday, April 10, 2001 3:36 PM
> To: 'ORACLE-L_at_fatcity.com'
> Subject: Temporarily Renaming the sgadefSID.dbf File
>
> Hi All,
>
> Trying to clone our PROD to a test database on the same machine for
> testing our 734-->8i upgrade, and of course we're encountering the
> "can't-start-the-new-without-shutting-down-the-old" database problem (ie,
> ORA-9782 on the CREATE CONTROLFILE command). We've worked around this in
> the past by scheduling a time to bring down PROD.
>
> I know that this is the safest, most reliable way (besides NOT doing this
> on a production box...but I have no choice), but believe it or not, I
> actually saw a reference on a Metalink forum to rename the sgadefSID.dbf
> file, start up the new database, then rename the file to its original
> name. Obviously sgadef gets created at instance startup as a memory map,
> but it doesn't look like it's used for anything after that (it's certainly
> doesn't seem to be written to). I do know that you can get an octal dump
> of the file to determine the shared memory ID for whatever reason.
>
> Everything else I've heard/seen about this file has pretty much said DON'T
> TOUCH IT!!! But if the instance only uses it at instance startup, is
> there any harm in renaming it temporarily to get the other database up?
> If so...why?
>
> And have any of you tried renaming or deleting the file in your cloning
> (or other) efforts? Did it blow up, or work?
>
> TIA,
> Steve
> _____________________________
> Steve Morrow
> IT/Tech Support
> University of South Florida
> phone: 813-974-5519
> smorrow_at_admin.usf.edu
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Morrow, Steve
  INET: SMorrow_at_admin.usf.edu

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).
Received on Tue Apr 17 2001 - 09:00:11 CDT

Original text of this message

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