Petstore Database Course Project

Today you received an email from the operations manager at House-O-Pets, a Web-based vendor of pet products in San Francisco. House-O-Pets uses Oracle as a back-end database to manage its e-commerce site and keep track of inventory, customers, and customer purchases. The company is looking for some ways to get better performance from its application systems.

For confidential information ranging from company history to the database system requirements, review the Fact File that Mr. Schwartz provided to you at the close of your meeting. The information in this folder is essential for solving problems throughout your tenure as DBA for House-O-Pets:

The Pet Store Database consists of a series of tables which are described below.

1. The PRODUCT_OBJ_TABLE can be viewed by clicking on the following link. Product Object Table
2. The CUSTOMER_OBJ_TABLE can be viewed by clicking on the following link. Customer Object Table
3. The SALE_HEADER can be viewed by clicking on the following link. Sale Header
4. The PET_CARE_LOG_OBJ_TABLE can be viewed by clicking on the following link.
   Pet Care Log Object
5. The MONTHLY_SALES can be viewed by clicking on the following link. Monthly Sales
6. The PRODUCT_PHOTO_OBJ_TABLE can be viewed by clicking on the following link. Product Photo Object
7. All Data Tables can be viewed by clicking on the following link. Data Tables

The course project will enable you to demonstrate your knowledge of how to repair or improve the database through a variety of exercises. You may be asked to analyze and report on existing code, submit pieces of code, or transfer what you have learned to a new situation. Some of the exercises will consist of evaluative simulations where you will be asked to problem solve within a simulated Oracle environment. Other exercises require an analysis of the information in the Fact File to solve the problem.
In the exercises, you will:

1. Demonstrate how to recover the database using line command Recovery Manager (RMAN)
2. Demonstrate how to recover the database using the RMAN GUI run from Oracle Enterprise Manager (OEM)
3. a standby database with automated recovery·
4. Implement parallel rollback with the fast-start feature

We will provide prompts for you to try exercises on your own if you do have access to Oracle.
In the next module, we will get started on your way toward an overview of new features for backup and recovery.