{"id":30525,"date":"2024-01-29T15:57:31","date_gmt":"2024-01-29T14:57:31","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=30525"},"modified":"2024-02-13T09:42:15","modified_gmt":"2024-02-13T08:42:15","slug":"how-to-create-a-backup-report-in-em-cloud-control-13c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/","title":{"rendered":"How to create a Backup Report in EM Cloud Control 13c"},"content":{"rendered":"\n<p>Wanted to make sure your Oracle databases were secured and be informed in case of backup problems?<br>This blog describes how to quickly get a report sent out on a daily-basis and make it work in Enterprise Manager 13cR5.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1st-activate-gathering-of-additional-metrics\">1st Activate gathering of additional metrics<\/h2>\n\n\n\n<p>We first need to activate the automatic gathering of additional metrics.<\/p>\n\n\n\n<p>From Targets -&gt; Databases -&gt; Click on the target database<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"240\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-1024x240.jpg\" alt=\"\" class=\"wp-image-30545\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-1024x240.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-300x70.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-768x180.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-1536x359.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-2048x479.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>On the database home page \u201cCluster Database\u201d drop down menu, navigate to Monitoring &gt; Metrics and Collection Settings:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"567\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-14-51b-1-1024x567.jpg\" alt=\"\" class=\"wp-image-30547\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-14-51b-1-1024x567.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-14-51b-1-300x166.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-14-51b-1-768x425.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-14-51b-1-1536x851.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-14-51b-1-2048x1134.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Click on the &#8216;Other Collected Items&#8217; tab:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"326\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-21-30c-1024x326.jpg\" alt=\"\" class=\"wp-image-30548\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-21-30c-1024x326.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-21-30c-300x96.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-21-30c-768x245.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-21-30c-1536x489.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-21-30c-2048x652.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Scroll down and search for &#8216;<strong>High Availability Backup History<\/strong>&#8216; -&gt; click on Disabled<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"404\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-23-47d-1024x404.jpg\" alt=\"\" class=\"wp-image-30549\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-23-47d-1024x404.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-23-47d-300x118.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-23-47d-768x303.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-23-47d-1536x605.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-23-47d-2048x807.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Enable this metric and Set Frequency Type to \u201cBy Minutes\u201d and Repeat Every to \u201c30\u201d Minutes -&gt; Continue -&gt; OK.<\/p>\n\n\n\n<p>Before EM 13cR5, it might be worth to look at MyOracleSupport (Doc ID 2631059.1) EM 13c: Repository View Sysman.mgmt$db_backup_history Is Empty<\/p>\n\n\n\n<p>To make sure this metric is gathered on a very regular basis, another mean is to create a monitoring template and have apply it by default on your databases.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-ensure-the-metric-is-gathered-for-each-targets\">2. Ensure the metric is gathered for each targets<\/h2>\n\n\n\n<p>Before creating any backup report, we first ensure the \u201cHigh Availability Backup History\u201d metric is gathered for each targets and accessible in the EM Cloud Control 13c Database Repository:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SQL&gt; select count(*) from sysman.mgmt$db_backup_history;\n\n  COUNT(*)\n----------\n      1385\n\n1 row selected.\n<\/code><\/code><\/pre>\n\n\n\n<p>Backup types on the query and in the report are based on the columns INPUT_TYPE and INCREMENTAL_LEVEL of SYSMAN.MGMT$DB_BACKUP_HISTORY view.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Set lines 300\nset pages 200\nCol host_name for a35\nCol target_name for a30\ncol full for a20\ncol incr for a20\ncol lev0 for a20\ncol lev1 for a20\n\nSELECT \n\tROWNUM n\n\t,host_name\n\t,target_name\n--\t,full_h\n    ,CASE\n      WHEN (NVL(full_h,1000)=1000) THEN ' '\n      WHEN (NVL(full_h,1000)&lt;24)   THEN NVL(full_h,1000)||' hour(s)'\n\t  WHEN (NVL(full_h,1000)&gt;=24)  THEN TRUNC(NVL(full_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(full_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END full\n--\t,incr_h\n    ,CASE\n      WHEN (NVL(incr_h,1000)=1000) THEN ' '\n      WHEN (NVL(incr_h,1000)&lt;24)   THEN NVL(incr_h,1000)||' hour(s)'\n\t  WHEN (NVL(incr_h,1000)&gt;=24)  THEN TRUNC(NVL(incr_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(incr_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END incr\n--\t,lev0_h\n    ,CASE\n      WHEN (NVL(lev0_h,1000)=1000) THEN ' '\n      WHEN (NVL(lev0_h,1000)&lt;24)   THEN NVL(lev0_h,1000)||' hour(s)'\n\t  WHEN (NVL(lev0_h,1000)&gt;=24)  THEN TRUNC(NVL(lev0_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(lev0_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END lev0\n--\t,lev1_h\n    ,CASE\n      WHEN (NVL(lev1_h,1000)=1000) THEN ' '\n      WHEN (NVL(lev1_h,1000)&lt;24)   THEN NVL(lev1_h,1000)||' hour(s)'\n\t  WHEN (NVL(lev1_h,1000)&gt;=24)  THEN TRUNC(NVL(lev1_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(lev1_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END lev1\n--\t,arch_h\n    ,CASE\n      WHEN (NVL(arch_h,1000)=1000) THEN ' '\n      WHEN (NVL(arch_h,1000)&lt;24)   THEN NVL(arch_h,1000)||' hour(s)'\n\t  WHEN (NVL(arch_h,1000)&gt;=24)  THEN TRUNC(NVL(arch_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(arch_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END arch\n\t,CASE\n\t  WHEN ( NOT (NVL(full_h,1000)&lt;7*24 OR NVL(lev0_h,1000)&lt;7*24 or NVL(incr_h,1000)&lt;7*24 ) )\n       THEN 'WARNING: No full or level0 on last 7 days'\n\t  WHEN ( NOT (NVL(full_h,1000)&lt;24 or NVL(lev0_h,1000)&lt;24 or NVL(lev1_h,1000)&lt;24 or NVL(incr_h,1000)&lt;24) )\n       THEN 'WARNING: No full, incr, level0 or level1 on last 24 hours'\n\t  WHEN ( NOT NVL(arch_h,1000)&lt;6 )\n       THEN 'WARNING: No backup archive on last 6 hours'\n\tEND info\nFROM\n(\n\tSELECT \n\t host_name\n\t ,target_name\n\t ,target_guid\n\t ,MAX(DECODE(typelevel, 'DB FULL', hours, NULL)    ) full_h\n\t ,MAX(DECODE(typelevel, 'DB INCR', hours, NULL)    ) incr_h\n\t ,MAX(DECODE(typelevel, 'DB INCR0', hours, NULL)   ) lev0_h\n\t ,MAX(DECODE(typelevel, 'DB INCR1', hours, NULL)   ) lev1_h\n\t ,MAX(DECODE(typelevel, 'ARCHIVELOG', hours, NULL) ) arch_h\n\tFROM\n\t(\n\t\tSELECT \n\t\t  T.host_name\n\t\t  ,T.TARGET_GUID\n\t\t  ,UPPER(T.TARGET_NAME) target_name\n\t\t  ,B.INPUT_TYPE || B.INCREMENTAL_LEVEL typelevel\n\t\t  ,CEIL((sysdate -  max(END_TIME))*24) hours\n\t\tFROM SYSMAN.MGMT$TARGET T\n\t\t ,(select * from SYSMAN.MGMT$DB_BACKUP_HISTORY where status like 'COMPLETED%' )  B\n\t\t-- WHERE B.TARGET_GUID (+) = T.TARGET_GUID\n\t\tWHERE B.TARGET_GUID = T.TARGET_GUID\n\t\t  AND t.target_type in ('rac_database','oracle_database')\n\t\tGROUP BY \n\t\t  T.host_name\n\t\t  ,T.TARGET_GUID\n\t\t  ,T.target_name\n\t\t  ,B.INPUT_TYPE || B.INCREMENTAL_LEVEL\n\t)\n\tGROUP BY HOST_NAME, TARGET_GUID,TARGET_NAME\nORDER BY HOST_NAME, TARGET_NAME\n);\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-create-the-backup-report\">3. Create the Backup Report<\/h2>\n\n\n\n<p>We are now ready to create the Backup Report:<\/p>\n\n\n\n<p>Go to \u201cEnterprise\u201d menu -&gt; Reports -&gt; Information Publisher Reports<br>And click on CREATE<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-1-on-the-first-general-tab\">3.1 On the (first) \u201cGeneral\u201d tab<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>a. Enter Title= DBI-Backup Report<\/li>\n\n\n\n<li>b. Select the Category \u201cA_DBI_Heartbeat\u201d<br>In case it does not exist, click on \u201cAdd Category\u201d and create a new one named \u201cA_DBI_Heartbeat\u201d. Obviously, no need to create new categories\/subcategories. This only makes it easier to find.<\/li>\n\n\n\n<li>c. Select the subcategory \u201cA_DBI_Heartbeat\u201d<\/li>\n\n\n\n<li>d. In case it does not exist, click on \u201cAdd Subcategory\u201d and create a new one \u201cA_DBI_Heartbeat\u201d<\/li>\n\n\n\n<li>e. Use the specified target<br>Target= MYINFRACDB_MYEM3CPDB (actually our OEM database)<\/li>\n\n\n\n<li>f. Check &#8220;Run report using target privileges of the report owner (SYSMAN)&#8221;<\/li>\n\n\n\n<li>g. Uncheck the \u201cThis report has a time period\u201d box<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"462\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-49-06e-1024x462.jpg\" alt=\"\" class=\"wp-image-30553\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-49-06e-1024x462.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-49-06e-300x135.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-49-06e-768x347.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-49-06e-1536x693.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_14-49-06e-2048x924.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-on-the-elements-tab\">On the \u201cElements\u201d tab<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>a. Click on \u201cAdd\u201d and select \u201cStyled Text\u201d, click on Continue.<\/li>\n\n\n\n<li>b. Edit the \u201cStyled Text\u201d element and add in the filed \u201cMessage Text\u201d : \u201cThis report lists the RMAN completed backups.\u201d<\/li>\n\n\n\n<li>c. Click on \u201cAdd\u201d and select \u201cSeparator\u201d, click on Continue.<\/li>\n\n\n\n<li>d. Click on \u201cAdd\u201d and select \u201cTable from SQL\u201d, click on Continue.<\/li>\n\n\n\n<li>e. Edit the \u201cTable from SQL\u201d element and add in the field \u201cHeader\u201d : \u201cElapsed time since last completed backups\u201d. Enter the following \u201cStatement\u201d:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n\tROWNUM n\n\t,host_name\n\t,target_name\n--\t,full_h\n    ,CASE\n      WHEN (NVL(full_h,1000)=1000) THEN ' '\n      WHEN (NVL(full_h,1000)&lt;24)   THEN NVL(full_h,1000)||' hour(s)'\n\t  WHEN (NVL(full_h,1000)&gt;=24)  THEN TRUNC(NVL(full_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(full_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END full\n--\t,incr_h\n    ,CASE\n      WHEN (NVL(incr_h,1000)=1000) THEN ' '\n      WHEN (NVL(incr_h,1000)&lt;24)   THEN NVL(incr_h,1000)||' hour(s)'\n\t  WHEN (NVL(incr_h,1000)&gt;=24)  THEN TRUNC(NVL(incr_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(incr_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END incr\n--\t,lev0_h\n    ,CASE\n      WHEN (NVL(lev0_h,1000)=1000) THEN ' '\n      WHEN (NVL(lev0_h,1000)&lt;24)   THEN NVL(lev0_h,1000)||' hour(s)'\n\t  WHEN (NVL(lev0_h,1000)&gt;=24)  THEN TRUNC(NVL(lev0_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(lev0_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END lev0\n--\t,lev1_h\n    ,CASE\n      WHEN (NVL(lev1_h,1000)=1000) THEN ' '\n      WHEN (NVL(lev1_h,1000)&lt;24)   THEN NVL(lev1_h,1000)||' hour(s)'\n\t  WHEN (NVL(lev1_h,1000)&gt;=24)  THEN TRUNC(NVL(lev1_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(lev1_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END lev1\n--\t,arch_h\n    ,CASE\n      WHEN (NVL(arch_h,1000)=1000) THEN ' '\n      WHEN (NVL(arch_h,1000)&lt;24)   THEN NVL(arch_h,1000)||' hour(s)'\n\t  WHEN (NVL(arch_h,1000)&gt;=24)  THEN TRUNC(NVL(arch_h,1000)\/24)|| ' day(s) ' || SUBSTR((NUMTODSINTERVAL(NVL(arch_h,1000), 'HOUR')), 12,2) || ' hour(s)'\n     END arch\n\t,CASE\n\t  WHEN ( NOT (NVL(full_h,1000)&lt;7*24 OR NVL(lev0_h,1000)&lt;7*24 or NVL(incr_h,1000)&lt;7*24 ) )\n       THEN 'WARNING: No full or level0 on last 7 days'\n\t  WHEN ( NOT (NVL(full_h,1000)&lt;24 or NVL(lev0_h,1000)&lt;24 or NVL(lev1_h,1000)&lt;24 or NVL(incr_h,1000)&lt;24) )\n       THEN 'WARNING: No full, incr, level0 or level1 on last 24 hours'\n\t  WHEN ( NOT NVL(arch_h,1000)&lt;6 )\n       THEN 'WARNING: No backup archive on last 6 hours'\n\tEND info\nFROM\n(\n\tSELECT \n\t host_name\n\t ,target_name\n\t ,target_guid\n\t ,MAX(DECODE(typelevel, 'DB FULL', hours, NULL)    ) full_h\n\t ,MAX(DECODE(typelevel, 'DB INCR', hours, NULL)    ) incr_h\n\t ,MAX(DECODE(typelevel, 'DB INCR0', hours, NULL)   ) lev0_h\n\t ,MAX(DECODE(typelevel, 'DB INCR1', hours, NULL)   ) lev1_h\n\t ,MAX(DECODE(typelevel, 'ARCHIVELOG', hours, NULL) ) arch_h\n\tFROM\n\t(\n\t\tSELECT \n\t\t  T.host_name\n\t\t  ,T.TARGET_GUID\n\t\t  ,UPPER(T.TARGET_NAME) target_name\n\t\t  ,B.INPUT_TYPE || B.INCREMENTAL_LEVEL typelevel\n\t\t  ,CEIL((sysdate -  max(END_TIME))*24) hours\n\t\tFROM SYSMAN.MGMT$TARGET T\n\t\t ,(select * from SYSMAN.MGMT$DB_BACKUP_HISTORY where status like 'COMPLETED%' )  B\n\t\t-- WHERE B.TARGET_GUID (+) = T.TARGET_GUID\n\t\tWHERE B.TARGET_GUID = T.TARGET_GUID\n\t\t  AND t.target_type in ('rac_database','oracle_database')\n\t\tGROUP BY \n\t\t  T.host_name\n\t\t  ,T.TARGET_GUID\n\t\t  ,T.target_name\n\t\t  ,B.INPUT_TYPE || B.INCREMENTAL_LEVEL\n\t)\n\tGROUP BY HOST_NAME, TARGET_GUID,TARGET_NAME\nORDER BY HOST_NAME, TARGET_NAME\n)\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>f. Click on \u201cContinue\u201d<\/li>\n\n\n\n<li>g. Click on \u201cContinue\u201d<\/li>\n\n\n\n<li>h. You should have the following elements:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"272\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-27-15f-1024x272.jpg\" alt=\"\" class=\"wp-image-30556\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-27-15f-1024x272.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-27-15f-300x80.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-27-15f-768x204.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-27-15f-1536x408.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-27-15f-2048x545.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-3-on-the-schedule-tab\">3.3 On the \u201cSchedule\u201d tab<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>a. Check the \u201cSchedule Report\u201d box.<\/li>\n\n\n\n<li>b. Select the \u201cRepeating\u201d schedule<\/li>\n\n\n\n<li>c. Select \u201cBy Days\u201d and enter 1 in the \u201cRepeat Every 1 Days\u201d field to get the report every days<\/li>\n\n\n\n<li>d. Set the report date (i.e. Monday morning at 07:00AM)<\/li>\n\n\n\n<li>e. In the \u201cE-mail Report\u201d part, check the \u201cE-mail report each time the scheduled report completes\u201d box<\/li>\n\n\n\n<li>f. Enter the sender email address and addressee in the \u201cTo\u201d field<\/li>\n\n\n\n<li>g. Enter the subject eg. \u201cDaily Prod. Databases Backups Report\u201d<\/li>\n\n\n\n<li>h. Click on OK to validate your report.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"686\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-35-01g-1024x686.jpg\" alt=\"\" class=\"wp-image-30557\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-35-01g-1024x686.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-35-01g-300x201.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-35-01g-768x515.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-35-01g-1536x1030.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-35-01g-2048x1373.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>That&#8217;s it. Here is the kind of mail you should get:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"398\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-40-09h-1-1024x398.jpg\" alt=\"\" class=\"wp-image-30561\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-40-09h-1-1024x398.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-40-09h-1-300x117.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-40-09h-1-768x299.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-40-09h-1-1536x598.jpg 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_15-40-09h-1-2048x797.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This blog describes how to create a backup report in Enterprise Manager 13c.<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[202,706,3237,3198],"type_dbi":[2728],"class_list":["post-30525","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-backup","tag-cloud-control","tag-enterprise-manager-13c","tag-report","type-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to create a Backup Report in EM Cloud Control 13c - dbi Blog<\/title>\n<meta name=\"description\" content=\"oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create a Backup Report in EM Cloud Control 13c\" \/>\n<meta property=\"og:description\" content=\"oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-29T14:57:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-13T08:42:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-1024x240.jpg\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"How to create a Backup Report in EM Cloud Control 13c\",\"datePublished\":\"2024-01-29T14:57:31+00:00\",\"dateModified\":\"2024-02-13T08:42:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/\"},\"wordCount\":592,\"commentCount\":5,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/2024-01-29_13-49-53-1024x240.jpg\",\"keywords\":[\"Backup\",\"Cloud Control\",\"Enterprise Manager 13c\",\"Report\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/\",\"name\":\"How to create a Backup Report in EM Cloud Control 13c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/2024-01-29_13-49-53-1024x240.jpg\",\"datePublished\":\"2024-01-29T14:57:31+00:00\",\"dateModified\":\"2024-02-13T08:42:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"oracle\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/2024-01-29_13-49-53-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/2024-01-29_13-49-53-scaled.jpg\",\"width\":2560,\"height\":599},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/how-to-create-a-backup-report-in-em-cloud-control-13c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create a Backup Report in EM Cloud Control 13c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to create a Backup Report in EM Cloud Control 13c - dbi Blog","description":"oracle","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/","og_locale":"en_US","og_type":"article","og_title":"How to create a Backup Report in EM Cloud Control 13c","og_description":"oracle","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/","og_site_name":"dbi Blog","article_published_time":"2024-01-29T14:57:31+00:00","article_modified_time":"2024-02-13T08:42:15+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-1024x240.jpg","type":"","width":"","height":""}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"How to create a Backup Report in EM Cloud Control 13c","datePublished":"2024-01-29T14:57:31+00:00","dateModified":"2024-02-13T08:42:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/"},"wordCount":592,"commentCount":5,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-1024x240.jpg","keywords":["Backup","Cloud Control","Enterprise Manager 13c","Report"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/","name":"How to create a Backup Report in EM Cloud Control 13c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-1024x240.jpg","datePublished":"2024-01-29T14:57:31+00:00","dateModified":"2024-02-13T08:42:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"oracle","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/01\/2024-01-29_13-49-53-scaled.jpg","width":2560,"height":599},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-create-a-backup-report-in-em-cloud-control-13c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to create a Backup Report in EM Cloud Control 13c"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/30525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=30525"}],"version-history":[{"count":10,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/30525\/revisions"}],"predecessor-version":[{"id":30562,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/30525\/revisions\/30562"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=30525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=30525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=30525"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=30525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}