DBA Arena

This script will report on all backups – full, incremental and archivelog backups.

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;

SESSION_KEY  INPUT_TYPE    STATUS              START_TIME           END_TIME              HRS
--------------------------------------------------------------------------------------------------------------------------------
378                   DB FULL          RUNNING            02/25/15 08:10      02/25/15 10:15     2.08416
378                   DB FULL          COMPLETED       02/25/15 08:10      02/25/15 10:31     2.35944
386                   BACKUPSET    RUNNING           02/25/15 10:31      02/25/15 11:03     0.53305
386                   BACKUPSET    COMPLETED       02/25/15 10:31      02/25/15 11:20     0.81388
========================================================================================

Monitor RMAN Progress

Read more...

Navigate to:
System Administrator > Concurrent > Program > Define > Query the program name
Copy the executable name

Navigate to:
System Administrator > Concurrent > Program > Executable
Query the copied executable name
Executable File Name is the name of the RDF

SELECT APPLICATION_NAME,'$'||BASEPATH||'/'||'reports/US' Reports_Path,EXECUTION_FILE_NAME FROM APPS.FND_EXECUTABLES_VL A, APPS.FND_APPLICATION_VL B WHERE EXECUTION_METHOD_CODE='P' AND A.APPLICATION_ID=B.APPLICATION_ID AND EXECUTION_FILE_NAME like '%&RDF_NAME%';

Enter value for rdf_name: GLXCAR

APPLICATION_NAME: General Ledger
REPORTS_PATH: $GL_TOP/reports/US
EXECUTION_FILE_NAME: GLXCAR