Solved

Oracle RMAN jobs

Posted on 2010-08-31
5
585 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

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

624 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