top header
top gradation HOME top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line menu gray
black line 2
menu gray tab More About ATI
menu blue ATI — Who We Are
white line
menu blue Contact ATI Courses
white line
menu blue List Of ATI Courses
white line
menu blue Attendees Testimonials
white line
menu blue The ATI FAQ Sheet
white line
menu blue Suggestions/Wait List
white line
menu blue New Courses
white line
menu blue Become an ATI Instructor
menu gray tab site resources
menu blue Acoustics & Sonar
white line
menu blue Rockets & Space
white line
menu blue GPS Technology
white line
menu blue ATI Blog
white line
menu blue ATI Space News
white line
menu blue ATI Site Map
white line
menu blue ATI Staff Tutorials
white line
menu blue ATI Sampler Page
white line
menu gray tab bar
menu gray tab courses
white line
menu blue Current Schedule
white line
menu blue Onsite Courses
white line
menu blue Register Online
white line
menu blue Request Brochure
white line
menu blue Free On-Site Price Quote
white line
menu blue Download Catalog
white line
menu blue Distance Learning
black line  

Information Technology

ATI's Oracle 9i DBA Fundamentals II course

Share |


    Technical Training Short On Site Course Quote

      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.


    • 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

      1. Explaining the key components of Oracle Net architecture
      2. Describing how client-server and web client connections are established

      Chapter 2: Basic Oracle Net Services Configuration (Server-Side)

      1. Identifying How a Listener Works
      2. Configuring the Listener using Oracle Net Manager
      3. Controlling the Oracle Net Listener by Using the Listener Control Utility

      Chapter 3: Basic Oracle Net Services Configuration for Client

      1. Describing the Difference Between Host Naming and Local Service Name Resolution
      2. 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

      1. Identifying the Components of the Oracle Shared Server
      2. Describing the Oracle Shared Server Architecture
      3. Configuring Shared Servers and Dispatchers Using Initialization Parameter
      4. Identifying Useful Data Dictionary Views

      Chapter 5: User-Managed Backups

      1. Describing User-Managed Backup and Recovery Operations
      2. Performing Closed Database Backups
      3. Performing Open Database Backups
      4. Cleaning Up After a Failed Online Backup
      5. Backing Up the Control File
      6. Backups with Read-Only Tablespaces
      7. Using NOLOGGING Options
      8. Using DBVerify to Check for Block Corruption

      Chapter 6: Using Recovery Manager for Backup

      1. Recovery Manager Architecture
      2. Oracle Recovery Catalog Maintenance
      3. Physical Backups using Recovery Manager

      Chapter 7: User-Managed Complete Recovery

      1. Describing Media Recovery
      2. Performing Recovery in Noarchivelog and Archivelog Mode
      3. Read-only Tablespace Recovery
      4. Relocating and Recovering a Tablespace

      Chapter 8: RMAN Complete Recovery

      1. Describing the Use of RMAN for Restoration and Recovery
      2. Performing Recovery in Noarchivelog or Archivelog Mode
      3. Restoring Data Files to a Different Location
      4. Relocating and Recovering a Tablespace

      Chapter 9: User-Managed Incomplete Recovery

      1. Describing the Steps of Incomplete Recovery
      2. Identifying the Situations Which Require Incomplete Recovery
      3. Performing an Incomplete Recovery
      4. Recovering from the Loss of Current Online Redo Logs

      Chapter 10: RMAN Incomplete Recovery

      1. Using UNTIL TIME
      2. Using UNTIL SEQUENCE

      Chapter 11: RMAN Repository Maintenance

      1. Crosschecking Backups and Copies
      2. Updating Repository When Backups Have Been Deleted
      3. Changing the Availability Status of Backups and Copies
      4. Making a Backup or Copy Exempt from the Retention Policy
      5. Cataloging Backups Made with Operating System Commands

      Chapter 12: RMAN Catalog Creation and Usage

      1. Describing the Contents of the Recovery Catalog
      2. Listing the RMAN Features Which Require the Recovery Catalog
      3. Creating the Recovery Catalog
      4. Maintaining the Recovery Catalog by Using RMAN Commands
      5. Using RMAN to Register, Resynchronize, and Reset a Database
      6. Querying the Recovery Catalog to Generate Reports and Lists
      7. Creating, Storing and Executing Scripts
      8. Describing Methods for Backing Up and Recovering the Recovery Catalog

      Chapter 13: Other Advanced Data Recovery Topics

      1. Using EXPORT and IMPORT utilities for Backup and Recovery


      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

    Register Now Without Obligation