Difference between revisions of "Script: RMAN Backup Status"
Jump to navigation
Jump to search
(Created page with "<pre> set lines 120 col RMAN_Status FORMAT A20 heading "Status" col INPUT_TYPE FORMAT A15 heading "Backup Type" col Hrs FORMAT 999.99 heading "Backup Time" col Start_Tim...") |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
SELECT SESSION_KEY "Backup Session ID", INPUT_TYPE, | SELECT SESSION_KEY "Backup Session ID", INPUT_TYPE, | ||
| − | STATUS | + | STATUS RMAN_Status, |
TO_CHAR(START_TIME,'DY mm/dd hh24:mi') Start_Time, | TO_CHAR(START_TIME,'DY mm/dd hh24:mi') Start_Time, | ||
TO_CHAR(END_TIME,'DY mm/dd hh24:mi') Start_Time, | TO_CHAR(END_TIME,'DY mm/dd hh24:mi') Start_Time, | ||
| Line 18: | Line 18: | ||
----------------- --------------- -------------------- -------------------- -------------------- ----------- | ----------------- --------------- -------------------- -------------------- -------------------- ----------- | ||
3422 ARCHIVELOG COMPLETED THU 11/03 20:41 THU 11/03 22:18 .62 | 3422 ARCHIVELOG COMPLETED THU 11/03 20:41 THU 11/03 22:18 .62 | ||
| − | 3420 DB INCR | + | 3420 DB INCR COMPLETED THU 11/03 19:02 FRI 11/04 20:48 7.77 |
3418 ARCHIVELOG COMPLETED THU 11/03 18:41 THU 11/03 19:47 .60 | 3418 ARCHIVELOG COMPLETED THU 11/03 18:41 THU 11/03 19:47 .60 | ||
3416 ARCHIVELOG COMPLETED THU 11/03 16:41 THU 11/03 17:28 .78 | 3416 ARCHIVELOG COMPLETED THU 11/03 16:41 THU 11/03 17:28 .78 | ||
| Line 28: | Line 28: | ||
3403 ARCHIVELOG COMPLETED THU 11/03 04:41 THU 11/03 05:00 .33 | 3403 ARCHIVELOG COMPLETED THU 11/03 04:41 THU 11/03 05:00 .33 | ||
3400 ARCHIVELOG COMPLETED THU 11/03 02:41 THU 11/03 03:28 .78 | 3400 ARCHIVELOG COMPLETED THU 11/03 02:41 THU 11/03 03:28 .78 | ||
| + | </pre> | ||
| + | * During the RMAN run, check the long-running sessions | ||
| + | <pre> | ||
| + | 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 | ||
| + | ; | ||
</pre> | </pre> | ||
| + | |||
| + | [[Category: RMAN]] | ||
| + | [[Category: Database Features]] | ||
| + | [[Category: Oracle Scripts]] | ||
Latest revision as of 09:16, 11 November 2012
set lines 120
col RMAN_Status FORMAT A20 heading "Status"
col INPUT_TYPE FORMAT A15 heading "Backup Type"
col Hrs FORMAT 999.99 heading "Backup Time"
col Start_Time FORMAT A20 heading "Backup Start Time"
col Start_Time FORMAT A20 heading "Backup End Time"
SELECT SESSION_KEY "Backup Session ID", INPUT_TYPE,
STATUS RMAN_Status,
TO_CHAR(START_TIME,'DY mm/dd hh24:mi') Start_Time,
TO_CHAR(END_TIME,'DY mm/dd hh24:mi') Start_Time,
ELAPSED_SECONDS/3600 Hrs
FROM V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY desc;
Backup Session ID Backup Type Status Backup Start Time Backup End Time Backup Time
----------------- --------------- -------------------- -------------------- -------------------- -----------
3422 ARCHIVELOG COMPLETED THU 11/03 20:41 THU 11/03 22:18 .62
3420 DB INCR COMPLETED THU 11/03 19:02 FRI 11/04 20:48 7.77
3418 ARCHIVELOG COMPLETED THU 11/03 18:41 THU 11/03 19:47 .60
3416 ARCHIVELOG COMPLETED THU 11/03 16:41 THU 11/03 17:28 .78
3414 ARCHIVELOG COMPLETED THU 11/03 14:41 THU 11/03 14:56 .25
3412 ARCHIVELOG COMPLETED THU 11/03 12:41 THU 11/03 13:04 .39
3410 ARCHIVELOG COMPLETED THU 11/03 10:41 THU 11/03 11:19 .63
3408 ARCHIVELOG COMPLETED THU 11/03 08:41 THU 11/03 09:10 .50
3406 ARCHIVELOG COMPLETED THU 11/03 06:41 THU 11/03 07:20 .65
3403 ARCHIVELOG COMPLETED THU 11/03 04:41 THU 11/03 05:00 .33
3400 ARCHIVELOG COMPLETED THU 11/03 02:41 THU 11/03 03:28 .78
- During the RMAN run, check the long-running sessions
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 ;
