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

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.
Received on Mon Oct 18 1999 - 16:24:43 CDT