Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 593
  • 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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