Re: Question about the sgadef<db_name>.dbf file

In article <DLzxt2.5v2_at_mecati.mecasoft.ch>, Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch> writes
>I'm looking for references about the sgadef<db_name>.dbf file,
>and what will happens if this file is lost, and how to procede.
>I cannot find references for this file in any manual's index,
>and I don't dispose of Oracle Book, so thank you for any info.
>
>Stefano
>
>--- OUR INSTALLATION AT A GLANCE (HP 9000 Model 715/33 running HP-UX 9.07) ---
>
> ORACLE7 Server (RDBMS) 7.1.6.2.0 CORE Version 2.3.7.1.0
> Oracle Server Manager 2.1.3.0.0 Oracle Network Manager 2.1.6.0.0
> SQL*Net V2 2.1.6.1.0 TCP/IP Protocol Adapter (V2) 2.1.6.1.0
> PL/SQL V2 2.1.6.2.0 SQLLIB 1.6.7.0.0
> SQL*Plus 3.1.3.7.1 Pro*C 2.0.6.0.0
>------------------------------------------------------------------------------
> Stefano Unternaehrer Mecasoft SA
> Oracle DBA 6600 Muralto
> PL/SQL, Pro*C, C, XWindow & Motif Switzerland Europe
> Software Developer fax: +41 91 743 5507
> email: dba,unter_at_mecasoft.ch voice: +41 91 743 7444
>

The sgadef<ORACLE_SID>.dbf file is a temporary file created at instance startup. As I understand it, it is used by Oracle to map out the Shared memory structures used by Oracle. The file is usually removed when you perform a normal or immediate shutdown.

I would'nt worry too much about the file, if the file is accidentally deleted I very much doubt that it would affect Oracle, at worst Oracle would probably perform an instance recovery.

Clive Bostock

Senior Consulant
KPMG (Health Systems) Received on Sat Feb 03 1996 - 00:00:00 CET