Hi,
I received following alert for DB.
ORA-01034: ORACLE not available
My findings
I thought of using V$RMAN_BACKUP_JOB_DETAILS to check if RMAN backup ran during alert time but the view doesn't exist.
Could you please tell me how to find the cause of the DB down?
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; 2 3 4 5 6
from V$RMAN_BACKUP_JOB_DETAILS
*
ERROR at line 5:
ORA-00942: table or view does not exist
Oracle -- 8.1.7.3.0
OS -- OSF1
This is non prod env.
Regards,
Bala