Solved

Oracle RMAN jobs

Posted on 2010-08-31
5
579 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
[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
  • 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 77

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 77

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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

749 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