Hi Team,
My 9i and 10g db are registred in 10g catalog.I m preparing consolidate report for all db's and getting below issues.
Able to get details for 10g db status using below query.
SELECT db_key,DB_NAME,status,start_time,end_time,time_taken_display,input_type,output_device_type,input_bytes_display, output_bytes_display
FROM rman.rc_RMAN_BACKUP_JOB_DETAILS----->>status columns show backup is either failed or successful
SQL> SELECT DB_NAME,status from rman.rc_RMAN_BACKUP_JOB_DETAILS@sul73003_PRMAN1 WHERE ( start_time > (SYSDATE - 1) ) and db_name='D42P' ;
DB_NAME STATUS
-------- -----------------------
D42P COMPLETED WITH WARNINGS
D42P COMPLETED WITH WARNINGS
D42P COMPLETED WITH WARNINGS
D42P COMPLETED WITH WARNINGS
D42P COMPLETED WITH WARNINGS------------------>>.10g db
Above query not returing any results for 9i db while 9i db regsitered in same catalog and backup happening successfully.
SQL> SELECT DB_NAME,status from rman.rc_RMAN_BACKUP_JOB_DETAILS@sul73003_PRMAN1 WHERE ( start_time > (SYSDATE - 1) ) and db_name='JNVPROD';--->>>>>>>>>9i db
no rows selected
SQL>
How to get status of backup for 9i db's from 10g catalog.