HI,
RMAN full backup plus archive logs seems to be hanging .Please help.Thanks
Command used
backup as COMPRESSED BACKUPSET tag 'BKP00' database format '/backup/bkpdp/full_%d_%u' plus archivelog section size 10G format '/backup/bkpdp/full_%d_%u';
LONGOPS
SELECT SID, SERIAL#, opname, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) COMPLETE
FROM gV$SESSION_LONGOPS
WHERE
TOTALWORK != 0
AND SOFAR != TOTALWORK
order by 1;
Session/Process Information
SID SERIAL# OPNAME SOFAR TOTALWORK COMPLETE
----- ------- ---------------------------------------------------------------- ---------- ---------- ----------
608 21335 RMAN: aggregate input 2466328 3741734 65.91
Session wait events
UNDEFINE SE.SID
select se.sid, se.event, se.total_waits, se.time_waited/100 time_waitedseconds,
se.average_wait/100 average_waitseconds,max_wait/100 max_waitsec
from v$session_event se, v$session ss
where time_waited > 0
and se.sid=ss.sid
and ss.username is not NULL
and ss.sid='&SID'
and ss.serial#='&serial'
order by 4;
Enter value for sid: 608
Enter value for serial: 21335
Session/Process Information
SID Activity Detail TOTAL_WAITS TIME_WAITEDSECONDS AVERAGE_WAITSECONDS MAX_WAITSEC
----- ------------------------------ ----------- ------------------ ------------------- -----------
608 switch logfile command 1 .01 .0085 .01
608 KSV master wait 26 .02 .0008 .01
608 log file sequential read 9 .02 .0024 .02
608 control file parallel write 24 .04 .0017 .01
608 cell single block physical rea 258 .12 .0005 .02
608 Disk file Mirror Read 750 .18 .0002 .01
608 control file sequential read 3023 .66 .0002 .02
608 SQL*Net message from client 694 38.45 .0554 22.75
I dont see any Errors in the Alert log as well