How to Know RMAN Backup Job Progress

20 Jan

Performing database backup is part of daily Database Administrator task. But often this backup process takes a long time. While in a limited hardware resource environment, this backup process often disturb the database performance. A DBA often being pushed to answer how long is the remaining time of this backup process. According to my experience, this script is helpful and accurate enough to predict the remaining time of a backup process. This script is a bit modified from the one that I get from my colleagues.  Hope that this also can help others :)

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

Melakukan backup database merupakan bagian dari tugas penting seorang Database Administrator. Namun seringkali proses backup ini memakan waktu yang cukup lama. Sedangkan jika dalam environment hardware yang terbatas, proses backup ini sering mengganggu performance database. Seorang DBA sering didesak untuk menjawab pertanyaan berapa lama lagi waktu yang diperlukan sampai backup selesai. Dan dari pengalaman saya, script berikut cukup menolong dan cukup akurat. Script ini saya modifikasi dari script yang didapat dari rekan saya. Semoga script ini juga dapat menolong rekan-rekan lainnya :)

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>