Database Backup and Recovery (MOSC)

MOSC Banner

How to check if RMAN restoration is Hang or in progress?

edited May 7, 2009 9:37PM in Database Backup and Recovery (MOSC) 1 commentAnswered
Hi
I am performing RMAN restoration using following rman block, My catalog information is in the controlfile which I have restored before this. Presently restoration is taking a very long time hence not user whether it is HANG or in Progrees.


run {
  allocate channel tape1 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/home/oracle/tdpo/PROD.tdpo.opt)';
  allocate channel tape2 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/home/oracle/tdpo/PROD.tdpo.opt)';
  restore database until time "TO_DATE('06-MAY-2009 19:00:00','DD-MON-YYYY HH24:MI:SS')";
  recover database until time "TO_DATE('06-MAY-2009 19:00:00','DD-MON-YYYY HH24:MI:SS')";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center