| CS 3540 |
Week 11 Lab
Complete in class |
This assignment is designed to help you to setup an environment to facilitate performance testing.
Prior to beginning this lab, create a text or wp document to record your results. Name the file CS3540L11Observations.
At specified steps, record your observations and/or answer the question. This document will be uploaded at the end of the lab.
- Perform a cold back up of your full database. Record your observations.
What files did you backup? What would be your plan to use this backup for data recovery?
- Perform a datapump export of your database. Record your observations.
- Corrupt your database.
One method of corrupting the database is to replace one of the datafiles with another non-Oracle file.
Record what you did and what you observed when you tried to open Oracle with the corrupted file(s).
- Recover your database from your cold backup. Record the process and observations.
Did you use the recovery plan from step 1? Did the recovery work successfully?
- Insure that your database has been completely recovered. Describe the process and observations.
Use Assignment Uploader to
submit your observation document.