So far you have learned about the structure of the Oracle database from the standpoint of the data itself. By the end of week 3, you will know more about the tasks required of the Oracle administrator, including management of user accounts, Oracle processes, security, backup and recovery, and tuning. You also will have learned about the Oracle Network Computing Architecture (NCA) and the Oracle Web Publishing Assistant.

Oracle Security

Day 15 covers various topics relating to Oracle security matters, specifically auditing.

Backup and Recovery

Days 16-18 cover the most important responsibility of the Oracle DBA: the development and implementation of a backup and recovery plan. An effective plan can save your company millions of dollars in the event of a system failure. Also covered in this section are other methods of quick recovery, such as the Oracle standby database, the use of replication for quick recovery, and the use of backup images.

Advanced Topics

Days 19-21 cover more advanced topics such as the use of the Oracle parallel server. Also included is a lesson on Oracle optimization and performance tuning. The book concludes with a lesson covering the Oracle Web Publishing Assistant and the Oracle Network Computing Architecture (NCA).

---

© Copyright, Macmillan Computer Publishing. All rights reserved.