Solved

Oracle Rman backup status report

Posted on 2010-09-24
14
1,260 Views
Last Modified: 2012-05-10
Currently we receive oracle RMAN backup status report through seperate email for each database. I want to recieve just one email of RMAN backup status report of all the databases on the same server and different servers.
0
Comment
Question by:hussainkhan22
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
14 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33753530
Do all the RMAN backups use the same repository?  If so, you should be able to generate a single script from the central repository.

If there are separate repositories or they are using the control files then I can't think of a way unless you write your own code to poll each server/repository then email you.

Before you ask: No I don't have any examples/samples/links that I can post for that method.
0
 

Author Comment

by:hussainkhan22
ID: 33754934
I have both same respository and different repository for another account. Can you please tell me the steps in details. I really appreciate your help. Thanks for your time and suggestion in advance.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33755123
If you would like a single email for each repository you can probably do this.  If you still only want a single email, you will need to write custom code/scripts.

>>Can you please tell me the steps in details

I already covered this with the comment above:  "Before you ask: No I don't have any examples/samples/links that I can post for that method".
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:hussainkhan22
ID: 33755380
I need a sample script for that as I dont have knowledge about scripts but if you could send me than I can edit the script account to my environment
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33755448
There is a lot of SQL scripts out there to query the RMAN catalog for backup status' if you Google around a little.  Using the terms "oracle rman status" the following link is third in the list:

http://gavinsoorma.com/2009/06/query-the-rman-catalog-to-check-backup-status/

If you are wanting the example for the custom program to create a single email across the entire enterprise, again, I don't have anything for this.  You will need to see what development tools are available for you in your work environment and write the custom code.

0
 

Author Comment

by:hussainkhan22
ID: 33755557
I was asking the script for email. Anyway thanks for your help. I will wait and see if anyone else have the script for one email of all the RMAN databases backup status.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33755580
From the database itself, I use UTL_MAIL to email me the database status.  RMAN backups are part of that status.
0
 

Author Comment

by:hussainkhan22
ID: 33756850
I am getting confused. Can you please tell me what steps I need to do and where I need to do as I don't wanna make a mistake
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33757279
Here's what I have but I don't think it's what you want:

I created a stored procedure in my database that checks things I consider important.  One of these things uses SQL similar to SQL in the link above to check the status of the RMAN backups.

All of this information is saved in a varchar2 variable.  At the very end of the stored procedure I make a call to UTL_MAIL to email the contents of the varchar2 variable to myself.

There are TONS of links out there that can explain any one of these steps.

Now back to your question:
You have several RMAN repositories.  You can create a procedure like I described for each repository but that will be one email for each one.  This isn't what you asked for.

If you still want a single email, you will need to write code that can connect to each repository, execute the SQL in the link above for each one then combine all that information and email you.

This is the code I do not have.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33757284
Before you ask:
No I cannot post the procedure I have.  It's considered proprietary.
0
 

Author Comment

by:hussainkhan22
ID: 33757303
I mean I have same repository for all RMAN database backups and need to setup just one email for all the RMAN backup status for different servers.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 33762701
I was confused by your comment above: "I  have both same respository and different repository for another account"

I thought you had several repositories.

With only one, where are you still having issues?  The sql in the link I posted shouyld give you the status of the backups and UTL_MAIL scripts are all over the place on the internet.

Except for: I need the complete code, please explain what part you need help with.
0
 

Author Closing Comment

by:hussainkhan22
ID: 33843583
got it
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question