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:

Click the View Table link above to see the contents of the tables in the House-O-Pets database.
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.