Re: question about sgadef<SID>.dbf (Oracle 8)

Thanks for the ideas. However, I am curious as to why I cannot find the sga<SID>.dbf file with my Oracle 8i database. The documentation states that it is necessary to be there, even though it will be phased out in future releases. I cannot find it anywhere on my system (aix 4.3).

In article <7ug6os$2pk$1_at_news.efn.org>,   "Jim Lloyd" <infosys_at_medfab.com> wrote:
> There are several ways to accomplish this. First you could check for
the
> existence of one of the background processes (smon,pmon, etc.) the
> assumption being if the background process is there the database is
probably
> running. Or . . .
>
> We use a script to query the running database for the tables that
need to be
> backed up and their location. Checking for what happened during this
query
> will also tell you if the database is running, or not. We then let
the
> script shut down the database, do the backup, and restart the
database.
>
> Hope this helps.
>
> <kshave_at_health.gov.mb.ca> wrote in message
> news:7u7t3o$vtl$1_at_nnrp1.deja.com...
> > My oracle 7.3.3 database has a 'sgadef<SID>.dbf' file that holds
> > information regarding the location of the SGA in memory. Is there an
> > equivalent file in Oracle 8.1.5?
> >
> > The reason that I'm asking is that I have a cold backup script
running
> > that checks for the existence of this file to determine if the
database
> > is running or not. If Oracle 8.1.5 does not have this file I'm
> > wondering what other file I could use in it's place that would
provide
> > my script with the same information (db is up or down). Does anybody
> > have a clean way of backing up the Oracle 8.1.5 database.
> >
> > Note: I don't want to use the rman program at this time.
> >
> > -Keith
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--

-Keith

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 20 1999 - 07:44:47 CDT