Re: determine start time for RAC database

From: Dan Norris <>
Date: Thu, 7 Jan 2010 10:41:01 -0600
Message-ID: <>

Hi Scott,

Technically speaking, a database can't start. A database is just the datafiles, control files and redo logs. An instance is the shared memory and background processes, so that's the part that gets started. (BTW, I've never been pleased with the "srvctl start database ..." syntax in this regard.)

The gv$instance view is the right place to look. However, if there are multiple start/stops for the instances (and users get "ping-ponged" between instances), you couldn't tell from there alone--you'd have to look at alert log information.

Hopefully, I've understood your question properly.


On Thu, Jan 7, 2010 at 9:48 AM, Scott Sibert <> wrote:

> I've looked around at a few things but we're pretty new running RAC and I'm
> not sure where to find this information.
> I'm trying to find the start time for the database, not the individual
> instances. For example, INST1 and INST2 start Monday. Tuesday INST1
> restarts, thus causing gv$instance for INST1 to show Tuesday as start time.
> Then, Wednesday, INST2 restarts, showing INST2 start time as Wednesday.
> So far, we have INST1 start time as Tuesday, INST2 start time as Wednesday,
> but the database itself has been up continuously since Monday. Where do I
> find that Monday start time since Monday is the true start time of the
> database?
> Thanks.
> Scott

Received on Thu Jan 07 2010 - 10:41:01 CST

Original text of this message