Monitoring Protected Database Backups Using Cloud Control

Cloud Control provides reporting capabilities and also enables you to monitor and change the status of protected database backup and recovery jobs.

Viewing Backup Reports for Protected Databases

Cloud Control provides a Backup Report that displays the details of all backup and recovery jobs that were run for a particular protected database. You can filter the data displayed in this report depending on the time period for which you want to see the reports.

To display the Backup Report for a protected database:

1. Access the home page for the protected database as described in "Accessing the Protected Database Home Page Using Cloud Control".
2. From the Availability menu, select Backup & Recovery and then select Backup Reports.
   This displays the DB login page.
3. Enter the appropriate login credentials.

   The View Backup Report page is displayed.

   Figure 5-2 Protected Database Backup Reports

   
   Description of "Figure 5-2 Protected Database Backup Reports"
4. (Optional) Filter the list of backups in the report using the fields above each column. You can filter by Backup Name, Status, Command, Type, Target, Start Time, and Time Taken.
5. (Optional) The View Range control can help you select an appropriate time period for the reports.
6. (Optional) The Recovery Window control displays the settings for the recovery window as well as how many days it has protection.
7. To view the details of any backup listed in the report, click on its row.

   The bottom of the page displays a new area with three tabs of information about the selected backup.

   • End-to-End Summary
   • Outputs
   • Inputs

End-to-End Summary Backup Report

Description of the illustration end2endsummary-png.png

To display the Backup Report End-to-End Summary for a protected database:

1. Go to the View Backup Report page.
2. From the list of backup reports, select a report to review.
   The lower section has three tabs for Inputs, Outputs, and End-to-End Summary.
3. Click on the End-to-End Summary tab.

   For that particular backup report, the End-to-End Summary table contains the backup operations, its source, its destination, the data transfer rate, and an embedded table with the resulting backup.

   The Resulting Backup table contains the storage, input type, output type, the backup level, restoration size, and the completion time.

Viewing Backup Reports for Outputs

Description of the illustration 9_output-png.png

To display the Backup Report Output for a protected database:

1. Go to the View Backup Report page.
2. From the list of backup reports, select a report to review.
   The lower section has three tabs for Inputs, Outputs, and End-to-End Summary.
3. Click on the Outputs tab.

   For that particular backup report, the Outputs tab is divided into sections that provide information about the backup sets and the backup pieces.

Inputs

Description of the illustration 8_inputs-png.png

To display the Backup Report Input for a protected database:

1. Go to the View Backup Report page.
2. From the list of backup reports, select a report to review.
   The lower section has three tabs for Inputs, Outputs, and End-to-End Summary.
3. Click on the Inputs tab.

   For that particular backup report, the Inputs tab is divided into sections that provide information about the datafile, the archive log, the control file, and information about the container and tablespaces.

Viewing the Status of Protected Database Backup Jobs

The Job Activity report displays details about the active, completed, and failed jobs for the protected database.

This report enables you to perform the following tasks:

• view additional details for each job

• suspend, resume, or stop currently active jobs

• modify the status of scheduled jobs

To view that status of protected database jobs:

1. Access the home page for the protected database as described in "Accessing the Protected Database Home Page Using Cloud Control".
2. From the Oracle Database menu, select Job Activity.

   The Job Activity page is displayed.

3. Use the Advanced Search section to provide criteria that filter the jobs displayed in the report.

   The following fields specify criteria that filter the jobs displayed in the report:

   • Owner: Select the owner of the job.

   • Start: Select the start time. Backup jobs scheduled to start during or after the selected time period are displayed. For example, select Last 7 Days to display jobs scheduled to start in the last 7 days.

   • Job Type: Select the type of job. For example, to display backup jobs select Database Backup.

   • Status: Select the status of the job. For example, to display the currently running jobs select Running.

4. Click Go to generate the report according to the specified criteria. Figure 5-3 shows the Job Activity Report for database backup jobs.

   Figure 5-3 Job Activity Report for Protected Database Backup Jobs

   
   Description of "Figure 5-3 Job Activity Report for Protected Database Backup Jobs"
5. To view the details of a particular job execution, select the job and click View Results.

   To stop the execution of a particular job, select the job and click Stop. Similarly, you can use options to suspend, resume, or delete a job.