Rman backup status

Rman backup status 

 

set linesize 999
set pagesize 500
col STATUS format a30
col START_TIME format a30
col END_TIME format a30
col hrs format 999.99
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;

 

Example out put 

 

To check which Exadata server complete details

To Check the exadata server complete details 

command : dmidecode -s system-product-name

Oracle Exadata Database Machine	Database Server Model	Exadata Storage Server Model
Oracle Exadata Database Machine X5-2	Oracle Server X5-2 Database Server ORACLE SERVER X5-2	Exadata Storage Server X5-2L Servers ORACLE SERVER X5-2L
Oracle Exadata Database Machine X5-8	Oracle Server X5-8 Server ORACLE SERVER X5-8	Exadata Storage Server X5-2L Servers ORACLE SERVER X5-2L
Oracle Exadata Database Machine X4-2	Sun Server X4-2 Oracle Database Server SUN SERVER X4-2	Exadata Storage Server X4-2L Servers SUN SERVER X4-2L
Oracle Exadata Database Machine X3-2	Sun Server X3-2 Oracle Database Server SUN FIRE X4170 M3	Exadata Storage Server X3-2 Servers SUN FIRE X4270 M3
Oracle Exadata Database Machine X2-2	Sun Fire X4170 M2 Oracle Database Server SUN FIRE X4170 M2 SERVER	Exadata Storage Server with Sun Fire X4270 M2 Servers SUN FIRE X4270 M2 SERVER
Oracle Exadata Database Machine X4-8 Full Rack	Sun Server X4-8 Oracle Database Server SUN SERVER X4-8	Exadata Storage Server X4-2L Servers SUN SERVER X4-2L
Oracle Exadata Database Machine X3-8 Full Rack	Sun Server X2-8 Oracle Database Server Sun Fire X4800 M2	Exadata Storage Server X3-2 Servers SUN FIRE X4270 M3
Oracle Exadata Database Machine X2-8 Full Rack	Sun Fire X4800 Oracle Database Server or Sun Server X2-8 Oracle Database Server Sun Fire X4800 or Sun Fire X4800 M2	Exadata Storage Server with Sun Fire X4270 M2 Servers SUN FIRE X4270 M2 SERVER
Oracle Exadata Database Machine	Sun Fire X4170 Oracle Database Server SUN FIRE X4170 SERVER	Exadata Storage Server with Sun Fire X4275 Servers SUN FIRE X4275 SERVER

Monitoring ambient temparatures of exadata cluster

dcli -g /opt/oracle.SupportTools/onecommand/all_group -l root 'ipmitool   \
sunoem cli "show /SYS/T_AMB" | grep value'

example : 

[root@fldadbadm01 bin]# ./dcli -g /opt/oracle.SupportTools/onecommand/all_group -l root 'ipmitool   \
> sunoem cli "show /SYS/T_AMB" | grep value': value = 21.250 degree C
fldadbadm02: value = 21.000 degree C
fldadbadm03: value = 20.750 degree C
fldadbadm04: value = 21.000 degree C
fldaceladm01: value = 21.000 degree C
fldaceladm02: value = 20.750 degree C
fldaceladm03: value = 21.000 degree C
fldaceladm04: value = 20.000 degree C
fldaceladm05: value = 21.000 degree C
fldaceladm06: value = 21.000 degree C
fldaceladm07: value = 21.250 degree C