Re: Database Downtime Report in Spreadsheet
Date: Tue, 15 Sep 2015 20:25:59 +0530
Message-ID: <CAG6s0C1nhmsBzetWCYtzeb_m0DCNR3cwfkW8wDKhJvTGdHzaVw_at_mail.gmail.com>
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_at_adm.com> wrote:
> No need for separate external table:
>
>
>
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ruel, Chris
> *Sent:* Monday, September 14, 2015 12:06 PM
> *To:* nagaraj.chk_at_gmail.com; oracle-l <oracle-l_at_freelists.org>
> *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_at_lfg.com * Desk:317.759.2172 * Cell 317.523.8482
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *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 E-mail
> 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.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 15 2015 - 16:55:59 CEST