About this course
Private/In-House Training

  • We can deliver this course at either your organisation's venue, or at one of our many high-quality training venues.

    For IT training courses, you can take advantage of our computer hire service - we deliver and setup the computers for you. After the course, we will come and collect them

    Freephone 0800 781 0626

Course Reviews

10g DBA Fundamentals 2

Course Code : 10DF2

Backup and Recovery Overview


Understanding the structures and processes for backup and recovery.
Introduce the different methods for backup and recovery
Diagnose and troubleshoot database problems.
Understand Oracle Recovery Manager

Backup and Recovery


Recovery structures and processes
Backup and recovery configuration
Types of failure and troubleshooting
Complete recovery
Incomplete media recovery
Export and import utilities
Test Recovery
ALTER DATABASE END BACKUP

Oracle Recovery Manager


RMAN command line prompt
Recovery Manager architecture
Setting up Recovery Manager
Database space requirements and privileges
Creating and running backup and recovery scripts from RMAN
Using LIST and REPORT options from Recovery Manager
Crash Recovery workshop,
Recovery Manager: Tips and tricks
Persistent Parameters
Block Level recovery

Enterprise Manager Utilities


Catalog Maintenance Using Enterprise Manager
Creating an EM Backup Configuration
LogMiner
Recovery Manager
Configurable Parameters

Standby Databases and Guards


Data Guard Features
Creating the Standby Database
Maintaining the Standby Database
Altering the Physical Structure
Failover without Data Guard
Failover Using Data Guard
Role Transitions Using Data Guard
Data Guard Protection Modes
Logical Standby Databases
Creating a Logical Standby Database
Logical Standby Failover and Switchover
Data Guard Manager Line Mode
Data Guard Manager Using EM

Flashback


Flashback Features
Enabling Flashback
Flashback Query
Additional Query Functions
Flashback Version Query
Flashback Transaction Query
Flashback Table
Flashback Drop (Recycle Bin)
Flashback Database

Network Architecture


Basic configuration
Oracle Net Manager
Listener administration
Using and configuring Oracle Names
Networking Wizard

Oracle Intelligent Agent


Installation
Configuration
Mixed SQL*Net and 9i Networking
Troubleshooting

Connection Manager


Concentrators
Multiplexing
Connection pooling

Shared Server


Using shared server
Configuration
Restrictions

Shared Memory Management


Manual Memory Allocation
Setting up ASMM
Non-dynamic SGA Buffers

Scheduler


Programs
Schedules
Jobs
Job Classes
Windows

Automated Storage Management


Features
ASM instances and database instances
ASM Disk groups
ASM Files

Desktop Applications Professional Development Project Management Technical IT new! - Datrix Training Books