Re: determine start time for RAC database

From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 8 Jan 2010 09:29:11 -0800 (PST)
Message-ID: <233733.30223.qm_at_web80607.mail.mud.yahoo.com>

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       

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 08 2010 - 11:29:11 CST