This blog explains the step by step process by which you can create and schedule your Daily RMAN Backup report through Oracle Enterprise Manager 13c Cloud Control. Please note the process will remain same even if you are on any previous release of Cloud Control or Grid Control.
Recently came requirement in my team, where I have to send daily report of scheduled RMAN backups. I have documented all the steps so that I can share with all users on my blog.
NOTE:- If your database is registered in Catalog, you can always use catalog database to get this information about daily RMAN backup. But if that’s not the case you can follow below steps to generate your own report.
Step 1: Login to OEM console and navigate to “Information Publisher Reports” page.
Step 2: Click on “Create” button as highlighted to start creating a new report.
Step 3: Building Report Definition
As shown in the above screenshot enter the details like Report Name, Category, Sub-Category etc. Since we will be using the OEM repository database to fetch all the details make sure you use “Use the specified target” and select the Repository database.
You can set the “Priviledges” and “Time Period” as per your need.
Next Step is to add the elements in your report, which is nothing but actual formating of your report. We will add just one Heading “Styled Text” and one “SQL Table” which will have all detailed information.
Click on “Add” button on the “Elements” page to add multiple elements as shown in the below screenshots.
You can set the “elements” parameters as per your requirement. Select the “Table from SQL” radio button as highlighted and click on “Continue” button.
Step 4: Use SQL to generate report.
select database_name as “Database Name”,
start_time as “Start Time”,
end_time as “End Time”,
status as “Completion Status”,
input_type as “Backup Type”,
output_device_type as “Device”,
output_bytes_display as ” Backup Size”
where –input_type like ‘%FULL’ AND
END_time > (TO_DATE(sysdate, ‘DD-MON-RR’) – 1)
order by End_TIME desc ;
I have commented the “input_type” in where clause, you can modify the query as per your requirement.
Click on “Set Parameters” icon to update elements for “Table from SQL”.
For more information about the mgmt$ha_backup view you can use the below specified link.
Step 5: Scheduling the Report.
As shown below in the screenshot, you can modify the settings for Scheduling the report as per your requirement. Once you are done with all settings, you can either click on “Preview” button to see your report or can click on “OK” button to save it.
Note:- Do not forget to check “Schedule Report” check box on the top of the page. I have by mistake forgot in this screenshot.
You will get the confirmation message once your report has been created successfully without any errors. Like the one in the below screenshot.
Just like this you can use the same process to generate as many custom reports as per your requirement.