Solved

Oracle RMAN jobs

Posted on 2010-08-31
5
576 Views
Last Modified: 2012-05-10
Hey guys how can I monitor RMAN jobs. What are the scripts to monitor RMAN jobs. In those scripts what do we need to look in it and how to resolve that.
0
Comment
Question by:hussainkhan22
  • 2
  • 2
5 Comments
 
LVL 6

Expert Comment

by:tangchunfeng
ID: 33566620
http://www.dba-oracle.com/t_monitor_rman_script.htm
Script to monitor RMAN progress
0
 
LVL 6

Accepted Solution

by:
tangchunfeng earned 250 total points
ID: 33566632
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33567448
Please define what you mean by monitor.  The links above show you how to monitor a running rman job but you could also take your question to mean how to show/report back that the backup is complete or if it had errors.

Please clarify.
0
 

Author Comment

by:hussainkhan22
ID: 33567487
I need a script to check whether my backup is running properly. Is there any method by which IO can estimate the amount of space the backup will occupy and how much time will it take to backup
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 33567572
From a quick Google search:
http://forums.oracle.com/forums/thread.jspa?threadID=601673

Which references:

From Metalink Note:105208.1:
There is no 'magic' formula to calculate the storage space of an RMAN backup
and there is no query that will give you a space estimate.
So, the best answer is: "Try it and see how much is used."

For status:
http://www.oracle-base.com/articles/10g/RMANEnhancements10g.php

V$RMAN_STATUS  - This view displays progress and status information for in-progress and complete RMAN jobs. The information for the in-progress jobs is memory only, while the complete job information comes from the controlfile.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
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 explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
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.

770 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