This content has been marked as final. Show 5 replies
Vinay Mummadi wrote:I doubt if anyone is going to have such a query in their back pocket, but it should be a simple matter of coding. Instead of the v$ views, you should be looking at the [url http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcviews001.htm]rman catalog views. Of course, that presupposes you are using a catalog -- which you should be doing if you are trying to manage backups from multiple databases.
is there a way to create a RMAN report for all the backups that are being done in different databases and that report should be directly writing to a sample table.
the report should contain the colums like -
DBNAME BKPTYPE DATE STATUS STARTTIME ENDTIME .. and so on..
i've tried using some v$views like V$RMAN_BACKUP_JOB_DETAILS,V$RMAN_BACKUP_JOB_DETAILS,V$BACKUP_SET_DETAILS. etc... but i need a some sql or pl/sql that should give me the complete report.
Do you have Grid control then you can easly generate the backup report from single view
SQL> desc mgmt$ha_backup
Name Null? Type
----------------------------------------- -------- -----------------
DATABASE_NAME NOT NULL VARCHAR2(256)
TARGET_TYPE NOT NULL VARCHAR2(64)
TARGET_GUID NOT NULL RAW(16)
are you using recovery catalog then you can generate the backup report for all databases using the following query.
start_piece, max(p.completion_time) end_piece
on c.session_key = d.session_key
on c.session_key = a.session_key
on c.session_key = b.session_key
on c.session_key = p.session_key
on c.session_key = r.session_key
where name = 'alice1')
i tried your query mgmt$ha_backup, the result is closer but not exactly that I was looking for. It doesn't show up archivelogs status, just gives me input_type as DB INCR.
for the second query- i did not tried it, as we don't have a catalog database. Wanted to know what are the advantages and disadvantages of having a catalog database?
The only disadvantage I can think of you have 1 more database to maintain.
The advantages and disadvantages of having a catalog database
The advantages are described here :
Benefits of Using the Recovery Catalog as the RMAN Repository
Tool to Present a Consolidated View of the Status of RMAN Backups