miércoles, 25 de septiembre de 2013

Estimate Time To Complete RMAN Execution (backup, recover, restore)

To estimate how many time any rman operation will take, you can check it with this script:

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
       ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
  AND OPNAME NOT LIKE '%aggregate%'
  AND TOTALWORK != 0
  AND SOFAR <> TOTALWORK;

For example if we are doing a full backup of database we can predict how many time we will take (approximately) :













Same will happen with restore/recover.