Re: determine start time for RAC database
- From: Thomas Roach <troach@xxxxxxxxx>
- To: yong321@xxxxxxxxx
- Date: Fri, 8 Jan 2010 15:11:02 -0500
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 <yong321@xxxxxxxxx> 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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Thomas Roach
813-404-6066
troach@xxxxxxxxx
Other related posts:
