Oracle Monitoring RMAN Backup
RMAN-Full-Backup
col operation format a10
col status format a10
col object_type format a10
col start_time format a20
col end_time format a20
select
operation,
status,
object_type,
to_char(start_time,'mm/dd/yyyy HH24:MI:SS') as start_time,
to_char(end_time,'mm/dd/yyyy HH24:MI:SS') as end_time
from
v$rman_status
where
start_time > SYSDATE -1
and
operation = 'BACKUP'
and
object_type = 'DB FULL'
order by
start_time desc;
OPERATION STATUS OBJECT_TYP START_TIME END_TIME
---------- ---------- ---------- -------------------- --------------------
BACKUP COMPLETED DB FULL 07/03/2014 09:51:36 07/03/2014 09:51:38
BACKUP COMPLETED DB FULL 07/02/2014 14:01:30 07/02/2014 14:01:32
Archivelog-Backup
col operation format a10
col status format a10
col object_type format a10
col start_time format a20
col end_time format a20
select
operation,
status,
object_type,
to_char(start_time,'mm/dd/yyyy HH24:MI:SS') as start_time,
to_char(end_time,'mm/dd/yyyy HH24:MI:SS') as end_time
from
v$rman_status
where
start_time > SYSDATE -1
and
operation = 'BACKUP'
and
object_type = 'ARCHIVELOG'
order by
start_time desc;
OPERATION STATUS OBJECT_TYP START_TIME END_TIME
---------- ---------- ---------- -------------------- --------------------
BACKUP COMPLETED ARCHIVELOG 07/03/2014 09:51:38 07/03/2014 09:51:40
BACKUP COMPLETED ARCHIVELOG 07/03/2014 09:51:33 07/03/2014 09:51:36
Controlfile und Spfile-Backup:
col operation format a40
col status format a10
col object_type format a10
col start_time format a20
col end_time format a20
select
operation,
status,
to_char(end_time,'mm/dd/yyyy HH24:MI:SS') as end_time
from
v$rman_status
where
start_time > SYSDATE -1
and
operation = 'CONTROL FILE AND SPFILE AUTOBACK'
order by
start_time desc;
OPERATION STATUS END_TIME
---------------------------------------- ---------- --------------------
CONTROL FILE AND SPFILE AUTOBACK COMPLETED 07/03/2014 09:51:41
CONTROL FILE AND SPFILE AUTOBACK COMPLETED 07/02/2014 14:01:35
IO Backup Werte
column filename format a80
select filename, type,status, bytes, total_bytes, round(bytes/total_bytes*100,2) erledigt from v$backup_async_io where type <> 'AGGREGATE';
FILENAME TYPE STATUS BYTES TOTAL_BYTES ERLEDIGT
-------------------------------------------------------------------------------- --------- ---------- ---------- ----------- ----------
+JUG12TESTDB/system01.dbf INPUT FINISHED 274726912 734003200 37.43
+JUG12TESTDB/undotbs1.dbf INPUT FINISHED 15728640 209715200 7.5
/BACKUP/rman_backup/JUG12DB1/ONLINE_JUG12DB_851939496_45_1 OUTPUT FINISHED 196837376
/BACKUP/rman_backup/JUG12DB1/snapcf_orcl.f INPUT FINISHED 7536640 7536640 100
/BACKUP/rman_backup/JUG12DB1/ONLINE_JUG12DB_851939496_46_1 OUTPUT FINISHED 7585792
+JUG12TESTDB/jug12db/archivelog/2014_07_03/thread_1_seq_25.309.851939499 INPUT FINISHED 512 512 100
/BACKUP/rman_backup/JUG12DB1/ARCH_JUG12DB_851939499_47_1 OUTPUT FINISHED 2048
/BACKUP/rman_backup/JUG12DB1/snapcf_orcl.f INPUT FINISHED 7536640 7536640 100
/BACKUP/rman_backup/JUG12DB1/CONTROLFILE_c-2751575724-20140703-00 OUTPUT FINISHED 7618560
select device_type "Device" , type , filename , to_char(open_time, 'mm/dd/yyyy hh24:mi:ss') open , to_char(close_time,'mm/dd/yyyy hh24:mi:ss') close , elapsed_time ET , effective_bytes_per_second EPS from v$backup_async_io where close_time > sysdate - 1 and type <> 'AGGREGATE' order by close_time desc;
Device TYPE FILENAME OPEN CLOSE ET EPS
----------------- --------- -------------------------------------------------------------------------------- ------------------- ------------------- ---------- ----------
DISK OUTPUT /BACKUP/rman_backup/JUG12DB1/CONTROLFILE_c-2751575724-20140703-00 07/03/2014 09:51:40 07/03/2014 09:51:40 0
DISK INPUT /BACKUP/rman_backup/JUG12DB1/snapcf_orcl.f 07/03/2014 09:51:40 07/03/2014 09:51:40 0
DISK INPUT +JUG12TESTDB/jug12db/archivelog/2014_07_03/thread_1_seq_25.309.851939499 07/03/2014 09:51:39 07/03/2014 09:51:39 0
DISK OUTPUT /BACKUP/rman_backup/JUG12DB1/ARCH_JUG12DB_851939499_47_1 07/03/2014 09:51:39 07/03/2014 09:51:39 0
DISK INPUT +JUG12TESTDB/sysaux01.dbf 07/03/2014 09:51:36 07/03/2014 09:51:38 200 127664128
DISK OUTPUT /BACKUP/rman_backup/JUG12DB1/ONLINE_JUG12DB_851939496_44_1 07/03/2014 09:51:36 07/03/2014 09:51:38 200 113606656
DISK OUTPUT /BACKUP/rman_backup/JUG12DB1/ONLINE_JUG12DB_851939496_45_1 07/03/2014 09:51:36 07/03/2014 09:51:38 200 98418688
DISK INPUT +JUG12TESTDB/system01.dbf 07/03/2014 09:51:36 07/03/2014 09:51:38 200 137363456
DISK INPUT /BACKUP/rman_backup/JUG12DB1/snapcf_orcl.f 07/03/2014 09:51:37 07/03/2014 09:51:37 0
DISK OUTPUT /BACKUP/rman_backup/JUG12DB1/ONLINE_JUG12DB_851939496_46_1 07/03/2014 09:51:37 07/03/2014 09:51:37 0
DISK INPUT +JUG12TESTDB/undotbs1.dbf 07/03/2014 09:51:36 07/03/2014 09:51:37 100 15728640
DISK INPUT +JUG12TESTDB/users01.dbf 07/03/2014 09:51:36 07/03/2014 09:51:36 0
ELAPSED_TIME NUMBER Time, in hundredths of a second, that the file was open
EFFECTIVE_BYTES_PER_SECOND NUMBER I/O rate that was achieved with this device during this backup
Artikelaktionen