RE: Database Downtime Report in Spreadsheet
Date: Tue, 15 Sep 2015 14:34:05 +0000
Message-ID: <a800731a0ce44827b280623582cf9852_at_JRCEX13MB1.research.na.admworld.com>
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<mailto: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> [mailto: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-l
Received on Tue Sep 15 2015 - 16:34:05 CEST