|
|
|
|
|
|
|
|
|
|
|
|
| Re: Rman Backup job report for all databases [message #651491 is a reply to message #651488] |
Thu, 19 May 2016 01:46   |
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
royalyogi wrote on Thu, 19 May 2016 06:48I want, Auto trigger mail of backup job status report of all databases as below
Job Report Format:
Date, Job Name(or Database Name), Job status
Really u guys helping me a lot.
Thank u
What should this "trigger" be? When and why should the mail be sent?
As for the report itself, have you looked at the views in the recovery catalogue yet? THey are named RC_%.
(by the way, please do not use abbreviations such as "u" for "you". They are not appropriate in a professional forum).
|
|
|
|
|
|
|
|
| Re: Rman Backup job report for all databases [message #651517 is a reply to message #651496] |
Thu, 19 May 2016 07:06 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
We are trying to lead you to a point of more self-sufficiency, to help make you a better DBA. Instead you seem to want to be spoon-feed and thus remain forever as a Junior DBA. This is not good for your career.
In addition, you are blatantly ignoring requests to drop the "IM-speak" and write like a professional.
You have three separate and distinct issues to address.
First, You talk about 'triggering' this report.
Second, you need to write a query against your rman catalog to produce the report.
Third, you need to be able to email the report.
For the triggering event, What event do you envision as triggering it? Are you aware of Oracle job scheduling capabilities?
For the query, you've been directed to look at the recovery catalog views. They are documented in Chapter 5 of Database Backup and Recovery Reference. Now that you've been given that lead, the professional thing to do is to follow up and find the views that have the information you need to include in your report. Exercise for the student: Present a list of specific data needed in the report, and the RC_* views that contain that data.
For the emailing of the report, you've been told to use utl_mail. Now that you've been given that lead, the professional thing to do is to follow up and read the documentation on utl_mail. It is documented in PL/SQL Packages and Types Reference. Exercise for the student: List the specific pre-requisites to using utl_mail - packages that need to be installed, initialization parameters to be set, etc.
We will be glad to help you with specifics when you get stuck but we need to see a bit of initiative on your part. It's called "developing a professional attitude."
[Updated on: Thu, 19 May 2016 07:08] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
