• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 596
  • Last Modified:

Oracle RMAN jobs

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
hussainkhan22
Asked:
hussainkhan22
  • 2
  • 2
2 Solutions
 
tangchunfengCommented:
http://www.dba-oracle.com/t_monitor_rman_script.htm
Script to monitor RMAN progress
0
 
tangchunfengCommented:
0
 
slightwv (䄆 Netminder) Commented:
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
 
hussainkhan22Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now