HP Data Protector User Manual

29
Appendix B. RMAN helpful Scripts
B.1 How to monitor RMAN job progress
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
/
SQL> @ RMAN_long_ops.sql
SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
2214 214 1 5065599 17297280 29.29
B.2 How to monitor RMAN waits
COL type FORMAT a7
COL filename FORMAT a55
COL elapsed_time FORMAT 9999999999
select
TYPE,STATUS,maxopenfiles,FILENAME,BUFFER_SIZE,BUFFER_COUNT,TOTAL_BYTES,ELAPSED_TIME,BYTES,EFFECTIVE_BYTES
_PER_SECOND,IO_COUNT,SHORT_WAITS,LONG_WAITS from v$backup_async_io where type <> 'AGGREGATE' order by
open_time, close_time
/
SQL> @ backup_async_io.sql
TYPE STATUS MAXOPENFILES FILENAME BUFFER_SIZE BUFFER_COUNT TOTAL_BYTES
ELAPSED_TIME BYTES EFFECTIVE_BYTES_PER_SECOND IO_COUNT SHORT_WAITS LONG_WAITS
------- ----------- ------------ ------------------------------------------------------- ----------- ----
-------- ----------- ------------ ---------- -------------------------- ---------- ----------- ----------
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_001.dbf 1048576
16 4293918720 8100 4293918720 53011342 4096 0 564
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_065.dbf 1048576
16 4293918720 7800 4293918720 55050240 4096 0 601
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_002.dbf 1048576
16 4293918720 7900 4293918720 54353402 4096 0 572
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_003.dbf 1048576
16 4293918720 8000 4293918720 53673984 4096 0 537
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_004.dbf 1048576
16 4293918720 8100 4293918720 53011342 4096 0 603
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_006.dbf 1048576
16 4293918720 8200 4293918720 52364862 4096 0 586
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_008.dbf 1048576
16 4293918720 8000 4293918720 53673984 4096 0 571
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_005.dbf 1048576
16 4293918720 8000 4293918720 53673984 4096 0 570
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_007.dbf 1048576
16 4293918720 8200 4293918720 52364862 4096 0 611
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_014.dbf 1048576
16 4293918720 8100 4293918720 53011342 4096 0 619
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_011.dbf 1048576
16 4293918720 8000 4293918720 53673984 4096 0 611
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_013.dbf 1048576
16 4293918720 8100 4293918720 53011342 4096 0 639
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_012.dbf 1048576
16 4293918720 8800 4293918720 48794531 4096 0 593
INPUT FINISHED +DG_DB/rac/datafile/tbs_pool_015.dbf 1048576
16 4293918720 8200 4293918720 52364862 4096 0 568
INPUT IN PROGRESS +DG_DB/rac/datafile/tbs_pool_009.dbf 1048576
16 4293918720 2314207232 2207 0 280

HP Data Protector Specifications

General

Brand	HP
Model	Data Protector
Category	Software
Language	English