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

Monitor recover process with ORacle RMAN

Have a database with a lot data files.It will take a long time. How to montor/observe what is going on with RMAN or sql commands? How much has it already recover?
0
jl66
Asked:
jl66
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
slightwv (䄆 Netminder) Commented:
Never tried but found the following at:
http://appsonlinedba.blogspot.com/2007/09/script-to-check-status-of-rman-backup.html

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"FROM V$SESSION_LONGOPSWHERE OPNAME LIKE 'RMAN%'AND OPNAME NOT LIKE '%aggregate%'AND TOTALWORK != 0AND SOFAR <> TOTALWORK;
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
i used the exact above command many times to findout how much % of RMAN backup was completed.
0
 
slightwv (䄆 Netminder) Commented:
Does it also work on 'restore'?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Chakravarthi AyyalaDatabase AdministratorCommented:
Ver much remember using only for backup.
Let me recollect and see if i ever used for restore.
0
 
jl66Author Commented:
Sorry I did not update it. I did not show anything when i issued this command. Are there any other commands?
0
 
johnsoneSenior Oracle DBACommented:
I have not looked at it while using RMAN, but if you look at V$RECOVERY_PROGRESS that should give you information on the recovery.
0
 
jl66Author Commented:
Thanks alot. very close to what I need.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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