Re: determine start time for RAC database
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: DonGranaman@xxxxxxxxxxxxxxx
- Date: Thu, 07 Jan 2010 18:08:32 +0100
Quite right. And the place where I'd go for finding out that would be
DBA_HIST_DATABASE_INSTANCE that should contain the recent history of
instance startups. Finding when the database actually shut down may be a
little more tricky, but ASH should have some ideas about it ...
Don Granaman wrote:
>
> Does a **database** really even have a “start time”? I suggest that
> the very concept is not valid.
>
> Obviously what you are asking for is something akin to: “What the last
> time that **no** instance was running against this database?”
>
> I don’t know if this information is “trivially” available. [i.e.
> “trivially” = Without greping all pertinent alert logs, applying
> heuristics, etc.]
>
> Don Granaman [nee: OraSaurus]
>
> ------------------------------------------------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Scott Sibert
> *Sent:* Thursday, January 07, 2010 9:49 AM
> *To:* Oracle-L Freelists
> *Subject:* determine start time for RAC database
>
> 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
>
--
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
