Daily Archives: April 14, 2015

SHUTDOWN: waiting for active calls to complete.

When I shutdown databse, I can see waiting for arctice calls to compleed in alert log. Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Stopping background process QMNC Tue Apr 14 15:52:00 2015 Stopping background process CJQ0 Stopping background process MMNL Stopping background process MMON License high water mark […]

How to check RMAN backup status and timings

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 […]