Print Outline in PDF format

   Course Description:

  This course prepares students to backup, recover and network an Oracle9i Server Database. The course covers the advanced options of the ORACLE 9i Server architecture related to backup and recovery and the methods available for Oracle Server networking.

  You can learn…

•   How to perform offline backups

•   How to configure the Oracle9i Server for ARCHIVELOG mode

•   How to perform online backups

•   How to perform complete and incomplete recovery

•   To configure networking using available methods

  Who Needs to Attend:

  Application Developers and Designers, Managers, Database Administrators, Systems Administrators, Network Managers and Technical Support Personnel

  Prerequisites:

  Oracle Foundation Classes, Oracle DBA I or equivalent experience is required.

  Course Labs:

1.   Configure Oracle Client

2.   Configure Oracle Listener and Server

3.   Shared Server Configuration

4.   Instance Recovery

5.   NOARCHIVELOG Physical Backups

6.   ARCHIVELOG Physical Backups

7.   Complete Recovery

8.   Incomplete recovery

9.   Logical Backup and Recovery

10.   Oracle Utilities

11.   Data Loading

12.   Backup Using RMAN

13.   Recovery Using RMAN

14.   Backup and Recovery Workshop

  Course Content:

  NETWORKING

•   Duties of the DBA for Networking

•   Overview of Oracle Network Architecture

•   Name Resolution

•   Oracle Net Client Configuration

•   Oracle Net Server Configuration

•   Tools

•   Configuring the Listener / LSNRCTL

•   Shared Server

•   Connection Manager

•   Oracle Net Failover and Load Balancing.

•   Oracle Net Troubleshooting

•   Advanced Security Option.

•   Oracle Networking and the Internet.

•   PL/SQL support and Packages for the DBA

•   A Day in the life of a Networking DBA

  BACKUP and RECOVERY

  Duties of the DBA

  Instance Recovery, Resumable and Online Operations

•   Instance Failure Recovery

•   Establishing a Recovery Time Target

•   Fast Start Time-based Recovery

•   Online and Resumable Operations

•   Flashback Query

•   Oracle Database Backups

•   Writing to the database

•   DBWR and LGWR

•   Automatic Recovery Architecture

•   NOARCHIVELOG and ARCHIVELOG Mode

•   Physical Backups

•   Closed Backups in NOARCHIVELOG Mode

Configuring ARCHIVELOG Mode

Physical ARCHIVELOG Mode Backups

•   Configuration of the database for archiving

•   Setting the ARCHIVELOG mode

•   Establishing multiple archiving destinations

•   Tuning the archive process

•   Closed backups in ARCHIVELOG mode

•   Open backups in ARCHIVELOG mode

•   Controlfile Backup

Complete and Incomplete Recovery

TSPITR & Standby Databases

Logical Backup and Recovery

Oracle Utilities and Packages

Data loading

Recovery Manager (RMAN) Overview