Chapter 3. Recovering From Non-Critical Losses
ORACLE DATABASE 10G: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Recovering from Non-critical Losses
Recover temporary tablespaces.
Recover a redo log group member.
Recover index tablespaces.
Recover read-only tablespaces.
Recreate the password file.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
This chapter provides a detailed explanation and examples of how to recover from non-critical losses. Non-critical losses are failure events that can be resolved without significantly impacting the operation of the database if performed properly. It is important to understand how to resolve these types of failures with minimal impact to the database operations. A DBA should be able to resolve non-critical losses quickly and leave the database in operational state throughout the recovery process.
In this chapter, you will walk through recovering a temporary tablespace, a redo log group member, an index tablespace, and a read-only tablespace. You will also re-create a password file to regain remote access to the database. You will see demonstrations and go through step-by-step examples performing each of these events and other related activities.