SQL Query using Joins - RMAN Catalog reports
Dear Team,
I'm trying to get backup reports for a month from catalog using below query and below is the output which I'm expecting for " No Backup Found". But the same query when I ran with time interval of more than a day like trunc(sysdate)-4 and sysdate, I'm not getting the output for the date where there's no backup. Instead the query is giving output for which the backups are recorded in catalog.
But , what i'm looking is for each day, if there's no backup then it should report for that day as "No backup found" and for the other where there is an entry in catalog should report with staus as "COMPLETED/FAILED/RUNNING" etc.
I'm trying to get backup reports for a month from catalog using below query and below is the output which I'm expecting for " No Backup Found". But the same query when I ran with time interval of more than a day like trunc(sysdate)-4 and sysdate, I'm not getting the output for the date where there's no backup. Instead the query is giving output for which the backups are recorded in catalog.
But , what i'm looking is for each day, if there's no backup then it should report for that day as "No backup found" and for the other where there is an entry in catalog should report with staus as "COMPLETED/FAILED/RUNNING" etc.
Tagged:
0