Two important functions of a DBA are (1) backup and recovery and (2) network administration. This course provides participants with an understanding of both functions. The course prepares participants to plan and implement a database backup and recovery strategy. The class addresses backup and recovery techniques and examines backup, failure, restore, and recovery scenarios. In hands-on exercises participants examine backup methodologies based on business requirements in a mission critical enterprise.
The Network Administration portion of this class allows students to learn about the Net Manager and Network Configuration Assistant for Oracle9i. In addition, users will learn how to create and manage listeners and create client net-service-names.
Chapter 1: Basic Oracle Net Architecture
- Explaining the key components of Oracle Net architecture
- Describing how client-server and web client connections are established
Chapter 2: Basic Oracle Net Services Configuration (Server-Side)
- Identifying How a Listener Works
- Configuring the Listener using Oracle Net Manager
- Controlling the Oracle Net Listener by Using the Listener Control Utility
Chapter 3: Basic Oracle Net Services Configuration for Client
- Describing the Difference Between Host Naming and Local Service Name Resolution
- Using Oracle Net Configuration Assistant to Configure Host Naming Method, Local Naming Method, and Net Service Names
Chapter 4: Usage and Configuration of the Oracle Shared Server
- Identifying the Components of the Oracle Shared Server
- Describing the Oracle Shared Server Architecture
- Configuring Shared Servers and Dispatchers Using Initialization Parameter
- Identifying Useful Data Dictionary Views
Chapter 5: User-Managed Backups
- Describing User-Managed Backup and Recovery Operations
- Performing Closed Database Backups
- Performing Open Database Backups
- Cleaning Up After a Failed Online Backup
- Backing Up the Control File
- Backups with Read-Only Tablespaces
- Using NOLOGGING Options
- Using DBVerify to Check for Block Corruption
Chapter 6: Using Recovery Manager for Backup
- Recovery Manager Architecture
- Oracle Recovery Catalog Maintenance
- Physical Backups using Recovery Manager
Chapter 7: User-Managed Complete Recovery
- Describing Media Recovery
- Performing Recovery in Noarchivelog and Archivelog Mode
- Read-only Tablespace Recovery
- Relocating and Recovering a Tablespace
Chapter 8: RMAN Complete Recovery
- Describing the Use of RMAN for Restoration and Recovery
- Performing Recovery in Noarchivelog or Archivelog Mode
- Restoring Data Files to a Different Location
- Relocating and Recovering a Tablespace
Chapter 9: User-Managed Incomplete Recovery
- Describing the Steps of Incomplete Recovery
- Identifying the Situations Which Require Incomplete Recovery
- Performing an Incomplete Recovery
- Recovering from the Loss of Current Online Redo Logs
Chapter 10: RMAN Incomplete Recovery
- Using UNTIL TIME
- Using UNTIL SEQUENCE
Chapter 11: RMAN Repository Maintenance
- Crosschecking Backups and Copies
- Updating Repository When Backups Have Been Deleted
- Changing the Availability Status of Backups and Copies
- Making a Backup or Copy Exempt from the Retention Policy
- Cataloging Backups Made with Operating System Commands
Chapter 12: RMAN Catalog Creation and Usage
- Describing the Contents of the Recovery Catalog
- Listing the RMAN Features Which Require the Recovery Catalog
- Creating the Recovery Catalog
- Maintaining the Recovery Catalog by Using RMAN Commands
- Using RMAN to Register, Resynchronize, and Reset a Database
- Querying the Recovery Catalog to Generate Reports and Lists
- Creating, Storing and Executing Scripts
- Describing Methods for Backing Up and Recovering the Recovery Catalog
Chapter 13: Other Advanced Data Recovery Topics
- Using EXPORT and IMPORT utilities for Backup and Recovery
