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