Summary:
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.
Prerequisites:
- Introduction to Oracle (SQL and PL/SQL) or
- Essentials I for Oracle Database Administration
- Understanding of basic operating system commands
Who Should Attend:
Database administrators, Application designers/developers, MIS Managers, Technical Support Professionals, System Administrators, and Network Administrators.
Benefits of Attendance:
Students will learn:
- Name and explain the network architectural layers
- Configure a simple client and server, and establish a connection between them
- Configure and startup a Shared Server
- Use the Net Manager and the Network Configuration Assistant
- Determine when backups should be performed and what should be backed up
- Identify the types of failures that can occur
- Develop backup and recovery plans
- Execute physical and logical backups of a database
- Perform database and datafile backups with and without Recovery Manager (RMAN)
- Recover a database in ARCHIVELOG and NOARCHIVELOG modes
- Use Export and Import as backup and recovery tools
Course Outline:
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
Tuition:
Tuition is $2500 per person at one of our scheduled public courses. Onsite pricing is available. Please call us at 410-956-8805 or send an email to ati@ATIcourses.com.
Register Now Without Obligation
