Jeden ze způsobů, jak monitorovat backup job, je s využitím tabulky v$session_longops, ve které jsou uchovány informace o dlouho trvajících ulohách.RMAN> backup device type sbt database;Starting backup at 2010-06-23:14:51:30released channel: ORA_DISK_1allocated channel: ORA_SBT_TAPE_1channel ORA_SBT_TAPE_1: SID=52 device type=SBT_TAPEchannel ORA_SBT_TAPE_1: WARNING: Oracle Test Disk APIchannel ORA_SBT_TAPE_1: starting full datafile backup setchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup setinput datafile file number=00001 name=+DATA/orcl/system01.dbfchannel ORA_SBT_TAPE_1: starting piece 1 at 2010-06-23:14:51:32channel ORA_SBT_TAPE_1: finished piece 1 at 2010-06-23:14:52:57piece handle=1mlgv7jj_1_1 tag=TAG20100623T145131 comment=API Version 2.0,MMS Version 8.1.3.0channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:25channel ORA_SBT_TAPE_1: starting full datafile backup setchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup setinput datafile file number=00002 name=+DATA/orcl/sysaux01.dbfchannel ORA_SBT_TAPE_1: starting piece 1 at 2010-06-23:14:52:57channel ORA_SBT_TAPE_1: finished piece 1 at 2010-06-23:14:54:12piece handle=1nlgv7m9_1_1 tag=TAG20100623T145131 comment=API Version 2.0,MMS Version 8.1.3.0
Následující dotaz vám podá informace o běžících úlohách.
SELECT ‘Detail Progress Information (per file)'”Detail Data” from dual;SELECT SID, START_TIME, ELAPSED_SECONDS, TIME_REMAININGFROM V$SESSION_LONGOPSWHERE OPNAME LIKE ‘RMAN%’AND OPNAME NOT LIKE ‘%aggregate%’AND TOTALWORK != 0AND SOFAR <> TOTALWORK;SELECT ‘Aggregate Progress Information’ “Aggregate Data” from dual;SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) “%_COMPLETE”FROM V$SESSION_LONGOPSWHERE OPNAME LIKE ‘RMAN%’AND OPNAME LIKE ‘%aggregate%’AND TOTALWORK != 0AND SOFAR <> TOTALWORK;
Výstup:
Detail Data————————————–Detail Progress Information (per file) SID START_TIME ELAPSED_SECONDS TIME_REMAINING———- ——————- ————— ————– 52 2010-06-23:14:52:57 23 35Aggregate Data——————————Aggregate Progress Information SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE———- ———- ———- ———- ———- ———- 51 35 56 87040 186240 46.74