Something else to consider, how do you define "downtime"?
Is this at the instance level between startup and shutdown?
What happens if your application users are locked?
What happens if the listener is down?
What happens if the OS/Network is refusing connections?
In my eyes, if the client can't get to it, the DB is in downtime. Regardless of
the root cause it's unavailable.
To that end; I would rely much more heavily on monitoring tools such as
OEM/Sensu/Nagios/Etc for external downtime reporting. By only looking at a
database instance in a vacuum, you're not getting the full picture.
On Sep 15, 2015, at 9:55 AM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote:
Thank You Chris Stephens and Chris Ruel. It is useful information to automate
my task, Thanks Again.
-Naga
On Tue, Sep 15, 2015 at 8:04 PM, Stephens, Chris <Chris.Stephens@xxxxxxx
<mailto:Chris.Stephens@xxxxxxx>> wrote:
No need for separate external table:
http://blog.tanelpoder.com/2009/03/21/oracle-11g-reading-alert-log-via-sql/
<http://blog.tanelpoder.com/2009/03/21/oracle-11g-reading-alert-log-via-sql/>
I would make sure you rotate the log on a somewhat regular basis though.
DBA_HIST_SNAPSHOT also has STARTUP_TIME if have diagnostics pack and aren’t
worried about multiple outages / snapshot.
Chris
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>]
On Behalf Of Ruel, Chris
Sent: Monday, September 14, 2015 12:06 PM
To: nagaraj.chk@xxxxxxxxx <mailto:nagaraj.chk@xxxxxxxxx>; oracle-l
<oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>>
Subject: RE: Database Downtime Report in Spreadsheet
Creating an external table on the alert log might allow you to mine it a
little easier. Create view on the external table with appropriate functions
and it would be easily reportable against. I have not done exactly what you
are asking myself but I have used external tables on many a
trace/alert/listener, and OS files to make those sorts of things “queryable”
within the database.
Chris..
_____________________________________________________________________
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group
cruel@xxxxxxx <mailto:cruel@xxxxxxx> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>]
On Behalf Of Nagaraj S
Sent: Monday, September 14, 2015 12:50 PM
To: oracle-l
Subject: Database Downtime Report in Spreadsheet
Hello Gurus,
I have a requirement to capture database downtime report in spreadsheet each
month on pivot table format. I use to manually check the alert log and
capture the instance down time and feed them in spreadsheet. Please advise If
you have any better idea to automate or any other easier way to do this ?
-Naga
Notice of Confidentiality: **This E-mail and any of its attachments may
contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation family
of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this E-mail,
you are
hereby notified that any dissemination, distribution, copying, or action
taken in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please notify
the
sender immediately and permanently delete the original and any copy of this
and any printout. Thank You.**
Confidentiality Notice:
This message may contain confidential or privileged information, or
information that is otherwise exempt from disclosure. If you are not the
intended recipient, you should promptly delete it and should not disclose,
copy or distribute it to others.
