Re: determine start time for RAC database

  • From: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • To: ssibert@xxxxxxxxx
  • Date: Thu, 7 Jan 2010 10:41:01 -0600

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 <ssibert@xxxxxxxxx> 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

Other related posts: