How to check Oracle Database Backup??

RMAN Backup Status.


col STATUS format a9
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;

How to flush shared Pool and buffer Cache??

Below command has no Harm to production systems,Can be used in case of performance degradation as this can help in refreshing Shared Pool and Buffer Cache and Database will reload both of these with new stats.


alter system flush buffer_cache;


alter system flush shared_pool; 

ASM Disk Location on Linux

Below is the location of disks stored in Linux OS.

/dev/oracleasm/disks

There may be situations where after reboot(OS) ASM is not able to mount disk.
Please look in above location and check for desired permissions and ownership.