Pak DBA
Pages
Big Data / Data Science
Solaris
Database
Oracle
Exadata
EBSR12
RAC
RMAN
ArcSDE
Tuning
Access Control
Tuesday, September 18, 2012
Checking RMAN backup progress
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;
No comments:
Post a Comment
Newer Post
Older Post
Home
No comments:
Post a Comment