Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more. Like the other courses in this series of Oracle Certification titles, this course teaches and demonstrates by example using thoroughly tested examples. In this course, instructor Gavin Powell covers Oracle Net Services, Backup and Recovery including RMAN, Oracle Enterprise Manager, Transportable Tablespaces and SQL*Loader. In addition, there are small sections introducing other Oracle optional features such as Standby databases (both Logical and Physical) plus Replication (both traditional and using Streams). Net Services covers architecture, connection configuration, listener configuration (from basics to connection profiling and load balancing), all the facts about connection strings and Oracle Net Services naming methods, even introducing some advanced features. To get started today, simply click one of the links below.
WelcomeWelcomePrerequisites for this CourseAbout this CourseOracle Net Services on TechnetOracle Backup and Recovery on TechnetOther Applicable Technet OptionsIntroducing Oracle Net ServicesWhat is Oracle Net Services?Three Basic ConfigurationsManaging Oracle Database NetworksLocal Versus Centralized NamingSimple Server ConfigurationOracle Shared Servers or MTS pt. 1Oracle Shared Servers or MTS pt. 2Simple Client ConfigurationConnection ProfilesIntroducing Naming Options pt. 1Introducing Naming Options pt. 2Oracle Connection ManagerNet Configuration AssistantNet ManagerUsing Oracle Enterprise ManagerIntroducing Backup/Recovery Options/UtilitiesDifferent Backup and Recovery OptionsImport and ExportCold Backups (Offline)Hot Tablespace Backups (Online)RMAN or Recovery ManagerRecoveryStandby DatabasesPhysical Standby DatabasesLogical Standby DatabasesReplicationReplication by Other MeansWhat are Transportable Tablespaces?What is SQL*Loader?Oracle Net Services ArchitectureOracle Net Services Architecture
The Open Systems Interconnection (OSI) Model
Oracle OSI Model
Protocols
Net Services Communication
Dedicated and Shared Connections
Shared Server Processes and Dispatchers
Configuring a Simple ConnectionThe Listener Configuration File
The TNS Names Configuration File
The Profile Parameters File
Basic Database Configuration Parameters pt. 1
Basic Database Configuration Parameters pt. 2
Using the Net Configuration Assistant pt. 1
Using the Net Configuration Assistant pt. 2
The ListenerWhat is the Listener? pt. 1
What is the Listener? pt. 2
Basic Listener Configuration
The Listener Control Utility
Service Registration
Listener Queue Size
Switching Off Listener Logging and Tracing
Timeouts
Multiple Listeners pt. 1
Multiple Listeners pt. 2
Connection Load Balancing and Failover
The Session Data Unit Buffer (SDU)
Connection Profile Configuration
Connection Strings and Naming MethodsConnection Strings
Naming Methods
Local Naming Using TNS
Host Naming
External Naming
Directory Naming pt. 1
Directory Naming pt. 2
Oracle Names Server
Oracle Shared ServersMultithreaded Server
Introducing Dispatchers
Dispatchers and Connection Pooling
Other Shared Server Parameters
Overriding Shared Servers
Connection ManagerWhat is Connection Manager?
Connection Concentration
Multiple Protocol Support
Configuring Connection Manager
Other Oracle Net Services UtilitiesOther Oracle Net Services Utilities
Oracle Net Services Advanced FeaturesWhat is TAF?
TAF Parameters
Configuring TAF
Non-Oracle Database Connections
Oracle Net Services MetadataPerformance Views
Backup and RecoveryWhat is Backup and Recovery?
Why Backup and Recovery?
Things to Remember
Things to Consider with Datafiles
Redo Logs
Controlfiles
Archive Logs
More Things to Consider
Yet More Things to Consider
Importance of Backup and Recovery
Points of Failure
Backup Strategy
How Backup and Recovery WorksProcesses/Memory Structures/Checkpoints
All the Files
SCNs
Restore and Recovery
Archive ConfigurationBasic Archive Configuration Parameters
Archive Log Mode Configuration pt. 1
Archive Log Mode Configuration pt. 2
Multiple Archiving Processes
Multiple Archive Destinations
Standby Archiving pt. 1
Standby Archiving pt. 2
Logical Backups Using ExportsFull Exports and Imports
Schemas
Multiple Schemas
Importing to a Different Schema
Tables
The Parameter File
Export and Import Options
Physical Backup/Restore/RecoveryCold Backups
Hot Backups
Verify Backups Using DBVERIFY
Recovering using Offline Physical Backups
Recovering using Online Physical Backups
Read Only Tablespaces
Incomplete Recovery
Scripting Hot Backups
RMAN (Recovery Manager)What is RMAN?
Repository and Catalog
The Recovery Catalog
RMAN Architecture
What is a Channel?
Allocating and Releasing Channels
Creating an RMAN Database
Creating a Repository
Connecting to RMAN
Registering Databases with the Repository
Viewing the Repository
Backup Sets
Types of Backups
Controlfile Backups
Datafile Backups
Tablespace Backups
Archive Log Backups
Binary Parameter File Backups
Database Backups
Incremental Backups
Restore and Recovery
Restore and Recovery in Action
Scripts and RMAN
Deleting RMAN Backups
Oracle Enterprise Manager Backup and RecoveryConfiguring Oracle Enterprise Manager
Communications
Win2K Log on as Batch Job
Export
Import
Backup and Recovery
Backup and Recovery MetadataPerformance Views
Transportable TablespacesWhat are Transportable Tablespaces?
Uses of Transportable Tablespaces
Limitations
Tablespace Sets
Tablespace Set Verification
Transporting a Tablespace Set
Plug In
SQL*LoaderWhat is SQL*Loader?
The Control File and Complexity
Input Data File
Input Data File Structures
How Rows are Loaded
Multiple Tables and Formats
Column Delimiters
NULL Values
Load Filtering
Filler Fields
Data Types
Conditional Replacement
Using SQL
Generating Data Not in Input Files
Executing SQL*Loader
Conventional Versus Direct
The Parameter File
A Simple Example Load pt. 1
A Simple Example Load pt. 2
Oracle Enterprise Manager
Click here to find out more about the Oracle Database Administration Fundamentals II Training CD 
