Please help me.
I need to confure the some daily monitoring report those using 12c grid control.
Such as db size , archive log generated daily, data guard status .
How can collect v$views information from OMS server to target database? Is there any doc id for same? Such as V$log_history, dba_data_files,v$archived_log .
There is no table in the OMS repository that contains v$log_history or v$archivelog data for targets. There is a table that contains the datafiles for all the targets. Have a look at my blog post below where I use data in the OMS repository to get some storage reports and inventory reports.
How can I retrieve the information of rman backup details?
If you intend to get Backup détails with Oracle Enterprise Manager, the link bellow may help you:
Else, you can also do it in command line from the Server housing the Database:
rman connect target / list backup summary;
Hope this help,
I need to configure report from 12c grid control which give me details of backup of target database.
Does it possible to execute select statement from OMS to target database to fetch dictionary views?. If we given select grant on dictinary views to dbsnmp user at target database
Are you using Enterprise Manager to schedule your RMAN backups? If so then yes you can pull a report. If you are not using Enterprise Manager to schedule your RMAN backups but you are using an RMAN catalog you can create a DBLINK from the OMS repository to your catalog and pull a daily report.
I have designed but of these type of methods and will share once I know how you are doing the backups.