How to check if RMAN restoration is Hang or in progress?
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')";