Oracle Database Administration Fundamentals II
Author:Angie Rawling/NMG
Language:english
Category:Business Applications,Databases,
Lessons:0 | 0 hrs
Buy Now or get more information about Oracle Database Administration Fundamentals II
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.
Oracle Database Administration Fundamentals IIOracle Database Administration Fundamentals II: 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 belowListed below are all of the chapter and lesson contents for the Oracle Database Administration Fundamentals II Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for Oracle Database Administration Fundamentals II freely available. Click on any of the linked lesson listings below to preview Free! Oracle Database Administration Fundamentals II
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Oracle Database Administration Fundamentals II

Welcome

Welcome
Prerequisites for this Course
About this Course
Oracle Net Services on Technet
Oracle Backup and Recovery on Technet
Other Applicable Technet Options

Introducing Oracle Net Services

What is Oracle Net Services?
Three Basic Configurations
Managing Oracle Database Networks
Local Versus Centralized Naming
Simple Server Configuration
Oracle Shared Servers or MTS pt. 1
Oracle Shared Servers or MTS pt. 2
Simple Client Configuration
Connection Profiles
Introducing Naming Options pt. 1
Introducing Naming Options pt. 2
Oracle Connection Manager
Net Configuration Assistant
Net Manager
Using Oracle Enterprise Manager

Introducing Backup/Recovery Options/Utilities

Different Backup and Recovery Options
Import and Export
Cold Backups (Offline)
Hot Tablespace Backups (Online)
RMAN or Recovery Manager
Recovery
Standby Databases
Physical Standby Databases
Logical Standby Databases
Replication
Replication by Other Means
What are Transportable Tablespaces?
What is SQL*Loader?

Oracle Net Services Architecture

Oracle 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 Connection

The 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 Listener

What 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 Methods

Connection Strings
Naming Methods
Local Naming Using TNS
Host Naming
External Naming
Directory Naming pt. 1
Directory Naming pt. 2
Oracle Names Server

Oracle Shared Servers

Multithreaded Server
Introducing Dispatchers
Dispatchers and Connection Pooling
Other Shared Server Parameters
Overriding Shared Servers

Connection Manager

What is Connection Manager?
Connection Concentration
Multiple Protocol Support
Configuring Connection Manager

Other Oracle Net Services Utilities

Other Oracle Net Services Utilities

Oracle Net Services Advanced Features

What is TAF?
TAF Parameters
Configuring TAF
Non-Oracle Database Connections

Oracle Net Services Metadata

Performance Views

Backup and Recovery

What 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 Works

Processes/Memory Structures/Checkpoints
All the Files
SCNs
Restore and Recovery

Archive Configuration

Basic 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 Exports

Full Exports and Imports
Schemas
Multiple Schemas
Importing to a Different Schema
Tables
The Parameter File
Export and Import Options

Physical Backup/Restore/Recovery

Cold 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 Recovery

Configuring Oracle Enterprise Manager
Communications
Win2K Log on as Batch Job
Export
Import
Backup and Recovery

Backup and Recovery Metadata

Performance Views

Transportable Tablespaces

What are Transportable Tablespaces?
Uses of Transportable Tablespaces
Limitations
Tablespace Sets
Tablespace Set Verification
Transporting a Tablespace Set
Plug In

SQL*Loader

What 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

01 Welcome
0101 Welcome
0102 Prerequisites for this Course
0103 About this Course
0104 Oracle Net Services on Technet
0105 Oracle Backup and Recovery on Technet
0106 Other Applicable Technet Options

02 Introducing Oracle Net Services
0201 What is Oracle Net Services?
0202 Three Basic Configurations
0203 Managing Oracle Database Networks
0204 Local Versus Centralized Naming
0205 Simple Server Configuration
0206 Oracle Shared Servers or MTS pt. 1
0207 Oracle Shared Servers or MTS pt. 2
0208 Simple Client Configuration
0209 Connection Profiles
0210 Introducing Naming Options pt. 1
0211 Introducing Naming Options pt. 2
0212 Oracle Connection Manager
0213 Net Configuration Assistant
0214 Net Manager
0215 Using Oracle Enterprise Manager

03 Introducing Backup/Recovery Options/Utilities
0301 Different Backup and Recovery Options
0302 Import and Export
0303 Cold Backups (Offline)
0304 Hot Tablespace Backups (Online)
0305 RMAN or Recovery Manager
0306 Recovery
0307 Standby Databases
0308 Physical Standby Databases
0309 Logical Standby Databases
0310 Replication
0311 Replication by Other Means
0312 What are Transportable Tablespaces?
0313 What is SQL*Loader?

04 Oracle Net Services Architecture
0401 Oracle Net Services Architecture
0402 The Open Systems Interconnection (OSI) Model
0403 Oracle OSI Model
0404 Protocols
0405 Net Services Communication
0406 Dedicated and Shared Connections
0407 Shared Server Processes and Dispatchers

05 Configuring a Simple Connection
0501 The Listener Configuration File
0502 The TNS Names Configuration File
0503 The Profile Parameters File
0504 Basic Database Configuration Parameters pt. 1
0505 Basic Database Configuration Parameters pt. 2
0506 Using the Net Configuration Assistant pt. 1
0507 Using the Net Configuration Assistant pt. 2

06 The Listener
0601 What is the Listener? pt. 1
0602 What is the Listener? pt. 2
0603 Basic Listener Configuration
0604 The Listener Control Utility
0605 Service Registration
0606 Listener Queue Size
0607 Switching Off Listener Logging and Tracing
0608 Timeouts
0609 Multiple Listeners pt. 1
0610 Multiple Listeners pt. 2
0611 Connection Load Balancing and Failover
0612 The Session Data Unit Buffer (SDU)
0613 Connection Profile Configuration

07 Connection Strings and Naming Methods
0701 Connection Strings
0702 Naming Methods
0703 Local Naming Using TNS
0704 Host Naming
0705 External Naming
0706 Directory Naming pt. 1
0707 Directory Naming pt. 2
0708 Oracle Names Server

08 Oracle Shared Servers
0801 Multithreaded Server
0802 Introducing Dispatchers
0803 Dispatchers and Connection Pooling
0804 Other Shared Server Parameters
0805 Overriding Shared Servers

09 Connection Manager
0901 What is Connection Manager?
0902 Connection Concentration
0903 Multiple Protocol Support
0904 Configuring Connection Manager

10 Other Oracle Net Services Utilities
1001 Other Oracle Net Services Utilities

11 Oracle Net Services Advanced Features
1101 What is TAF?
1102 TAF Parameters
1103 Configuring TAF
1104 Non-Oracle Database Connections

12 Oracle Net Services Metadata
1201 Performance Views

13 Backup and Recovery
1301 What is Backup and Recovery?
1302 Why Backup and Recovery?
1303 Things to Remember
1304 Things to Consider with Datafiles
1305 Redo Logs
1306 Controlfiles
1307 Archive Logs
1308 More Things to Consider
1309 Yet More Things to Consider
1310 Importance of Backup and Recovery
1311 Points of Failure
1312 Backup Strategy

14 How Backup and Recovery Works
1401 Processes/Memory Structures/Checkpoints
1402 All the Files
1403 SCNs
1404 Restore and Recovery

15 Archive Configuration
1501 Basic Archive Configuration Parameters
1502 Archive Log Mode Configuration pt. 1
1503 Archive Log Mode Configuration pt. 2
1504 Multiple Archiving Processes
1505 Multiple Archive Destinations
1506 Standby Archiving pt. 1
1507 Standby Archiving pt. 2

16 Logical Backups Using Exports
1601 Full Exports and Imports
1602 Schemas
1603 Multiple Schemas
1604 Importing to a Different Schema
1605 Tables
1606 The Parameter File
1607 Export and Import Options

17 Physical Backup/Restore/Recovery
1701 Cold Backups
1702 Hot Backups
1703 Verify Backups Using DBVERIFY
1704 Recovering using Offline Physical Backups
1705 Recovering using Online Physical Backups
1706 Read Only Tablespaces
1707 Incomplete Recovery
1708 Scripting Hot Backups

18 RMAN (Recovery Manager)
1801 What is RMAN?
1802 Repository and Catalog
1803 The Recovery Catalog
1804 RMAN Architecture
1805 What is a Channel?
1806 Allocating and Releasing Channels
1807 Creating an RMAN Database
1808 Creating a Repository
1809 Connecting to RMAN
1810 Registering Databases with the Repository
1811 Viewing the Repository
1812 Backup Sets
1813 Types of Backups
1814 Controlfile Backups
1815 Datafile Backups
1816 Tablespace Backups
1817 Archive Log Backups
1818 Binary Parameter File Backups
1819 Database Backups
1820 Incremental Backups
1821 Restore and Recovery
1822 Restore and Recovery in Action
1823 Scripts and RMAN
1824 Deleting RMAN Backups

19 Oracle Enterprise Manager Backup and Recovery
1901 Configuring Oracle Enterprise Manager
1902 Communications
1903 Win2K Log on as Batch Job
1904 Export
1905 Import
1906 Backup and Recovery

20 Backup and Recovery Metadata
2001 Performance Views

21 Transportable Tablespaces
2101 What are Transportable Tablespaces?
2102 Uses of Transportable Tablespaces
2103 Limitations
2104 Tablespace Sets
2105 Tablespace Set Verification
2106 Transporting a Tablespace Set
2107 Plug In

22 SQL*Loader
2201 What is SQL*Loader?
2202 The Control File and Complexity
2203 Input Data File
2204 Input Data File Structures
2205 How Rows are Loaded
2206 Multiple Tables and Formats
2207 Column Delimiters
2208 NULL Values
2209 Load Filtering
2210 Filler Fields
2211 Data Types
2212 Conditional Replacement
2213 Using SQL
2214 Generating Data Not in Input Files
2215 Executing SQL*Loader
2216 Conventional Versus Direct
2217 The Parameter File
2218 A Simple Example Load pt. 1
2219 A Simple Example Load pt. 2
2220 Oracle Enterprise Manager

Sponsors