Re: determine start time for RAC database

From: Thomas Roach <>
Date: Fri, 8 Jan 2010 15:11:02 -0500
Message-ID: <>

Perhaps you can write a script to go against your alert logs for the database availability across all nose where the instance exists?

Search for something like this to know when it is up.

Sat Oct 17 01:58:41 2009
Starting ORACLE instance (normal)
If you don't see a clean shutdown, perhaps you can determine when the last time stamp before that as when it was last available?

Then overlap the start/stop times and see if you have a gap. Maybe use something like excel to show this?
It would be nice if there was a services view you could query to determine how long the service has been available across nodes, like a service_uptime column. If node 2 reboot, then it determines the service_uptime as that kept on other nodes, it only gets reset when that service is no longer up and available on any node.
On Fri, Jan 8, 2010 at 12:29 PM, Yong Huang <> wrote:

> Others have good input. I want to add that even though this may not be
> a proper technical question, it's a very legitimate question for
> business. If there's no good way to find the answer from a technical
> perspective, Oracle should enhance the product. Writing a shell script
> incorporating heuristics to provide the answer or the best guess at it
> is meaningful exercise.
> On the other hand, we may check service availability. That's what
> business cares about anyway. If they connect using service myapp, find
> a gap in the output of
> select distinct a.snap_id, a.begin_interval_time, a.end_interval_time
> from dba_hist_snapshot a, dba_hist_service_stat b
> where a.snap_id = b.snap_id and service_name = 'myapp'
> order by 1;
> If it's any or all services, replace myapp with SYS$USERS. The problem
> with this is that the gap has to be larger than an hour to be detected.
> And a license issue with querying these views.
> Having said all that, if you build your own script to periodically
> login the database, RAC start time, or rather, service availability
> starting time, becomes readily available!
> Yong Huang
> --

Thomas Roach

Received on Fri Jan 08 2010 - 14:11:02 CST

Original text of this message