Backup Recovery   «Prev  Next»

Oracle Backup Strategy - Exercise

Objective: Given a scenario, create a backup strategy and explain why you chose this as the best strategy.

Exercise Scoring

This exercise is worth a total of 15 points. You will receive up to 10 points for choosing the correct option. You will receive up to 5 points for explaining the reason for choosing the option.

Background | Overview

In this exercise, we describe a scenario of a company and you have to create a backup plan for them.

Instructions

House-O-Pets has been in the market for the past 3 years selling pet products online through their website. The information regarding the inventory and sales of pets, and its products is maintained within an Oracle8.1.5 database.
Because the company sells its products online, the database must be available 24X7 to its customers.
  1. What should be the backup plan?
  2. Which one of the following options is best suited for House-O-Pets?
  3. Provide a brief paragraph explaining the reason for choosing the option you have selected.

Three Options for Backup

  1. Perform a nightly export of the database and maintain the database within a no archivelog mode.
  2. Perform a nightly hot backup and export of the database and maintain a standby database at a different location with respect to the primary database.
  3. Perform a cold database backup on a nightly basis and maintain the database within a no archivelog mode.

Hints

Choose a backup plan based on the workings of the company.

Submitting your Exercise

After you have defined the backup plan and added your explanation for the option that you used and why, place them within the text area below and click the Submit button to submit.