RMAN BACKUP STATUS DETAILS SCRIPTS
-------------------------------------------------------------------
---------------------######## RMAN Backup logs details will show which are files completed ##############------------------------
cd logs/voyager/backups
voyager:/home/oracle/ $ cd logs/voyager/backups
voyager:logs/voyager/backups/ $ ls -lrth
total 3218
-rw-r----- 1 oracle dba 54K Feb 21 08:17 DB_Full_Backup_202202210158.log
-rw-r----- 1 oracle dba 54K Feb 21 08:18 DB_Full_Backup_202202210155.log
-rw-r----- 1 oracle dba 103K Feb 21 23:27 DB_Full_Backup_202202212300.log
-rw-r----- 1 oracle dba 155K Feb 23 01:09 DB_Full_Backup_202202222300.log
-rw-r----- 1 oracle dba 132K Feb 24 01:13 DB_Full_Backup_202202232300.log
-rw-r----- 1 oracle dba 29K Feb 25 00:25 DB_Full_Backup_202202242300.log
voyager:logs/voyager/backups/ $ more DB_Full_Backup_202202242300.log
---------------------------------------------------------------------
SQL> col STATUS format a9
SQL> col hrs format 999.99
SQL> select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;
SQL> /
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ------------- --------- -------------- -------------- -------
29 DB FULL RUNNING 01/07/14 10:28 01/07/14 10:28 .00
SQL> /
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ------------- --------- -------------- -------------- -------
29 DB FULL RUNNING 01/07/14 10:28 01/07/14 10:28 .01
SQL> /
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ------------- --------- -------------- -------------- -------
29 DB FULL COMPLETED 01/07/14 10:28 01/07/14 10:29 .03
======================================================================================
next script
---------------------------------------------------------------------------
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;
SID SERIAL# CONTEXT SOFAR TOTALWORK %COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
18 29 1 9115569 19258880 47.33
===========================================================================
next script
----------------------------------------------------------------------------------
You can also check historical backup status with the help of following script:
set linesize 500 pagesize 2000
col Hours format 9999.99
col STATUS format a10
select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Bkup_start_time,
to_char(END_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Bkup_end_time,
elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;
SESSION_KEY INPUT_TYPE STATUS RMAN_BKUP_START_TIM RMAN_BKUP_END_TIME HOURS
----------- ------------- ---------- ------------------- ------------------- --------
137764 DB FULL COMPLETED 06-06-2017 02:00:32 06-06-2017 04:12:13 2.19
137770 ARCHIVELOG COMPLETED 06-06-2017 04:00:29 06-06-2017 04:01:05 .01
137778 ARCHIVELOG COMPLETED 06-06-2017 06:00:27 06-06-2017 06:00:35 .00
137782 ARCHIVELOG COMPLETED 06-06-2017 08:00:32 06-06-2017 08:03:36 .05
137786 ARCHIVELOG COMPLETED 06-06-2017 10:00:30 06-06-2017 10:02:03 .03
137790 ARCHIVELOG COMPLETED 06-06-2017 12:00:30 06-06-2017 12:02:34 .03
137794 ARCHIVELOG COMPLETED 06-06-2017 14:00:30 06-06-2017 14:02:58 .04
=========================================================================================
next script
-----------------------------------------------------------
select OUTPUT from V$RMAN_OUTPUT;
============================================================================
To check backup status is running and how much minutes remaining...
SQL> select opname,round(time_remaining/60) time_remaining_mins from
gv$session_longops where opname like '%RMAN%' and time_remaining<>0;
opname time_remaining_mins
------------------------------------------------------------------
RMAN: aggregate input 4.4
RMAN: incremental datafile backup 9.05
SQL> select fname, round(bytes/power(1023,3)) SIZE_GB from v$backup_files
where file_type='PIECE';
FNAME SIZE_GB
------------------------------------------------------------------------
/path/to/backup_file.dbf 10.14
---------------
v$backup_files
---------------
BACKUP_TYPE='BACKUP SET/COPY/PROXY COPY'
FILE_TYPE = 'DATAFILE/CONTROLFILE/SPFILE/REDO LOG/ARCHIVED LOG/
COPY(for an image copy backup)/PIECE(for a backup piece)'
No comments:
Post a Comment