Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

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.

Subscriber Reviews

Average Rating: 2.3333333333333335 out of 5 rating Based on 3 Ratings

"Oracle Database Administration Fundamentals II" - by MRoth on 11-APR-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This video looks to be only preview clips for the course, which kind of makes it worthless.

Also Audio quality is poor and othen hangs for several seconds.

I couldn't give it zero stars but that's what it deserves.

Report as Inappropriate

Table of Contents

Chapter/Selection

Time

Welcome

Welcome

Preview

00:01:28

Prerequisites for this Course

Preview

00:02:41

About this Course

Preview

00:03:41

Oracle Net Services on Technet

Preview

00:01:15

Oracle Backup and Recovery on Technet

Preview

00:02:04

Other Applicable Technet Options

Preview

00:01:39

Introducing Oracle Net Services

What is Oracle Net Services?

Preview

00:01:40

Three Basic Configurations

Preview

00:02:42

Managing Oracle Database Networks

Preview

00:03:15

Local Versus Centralized Naming

Preview

00:02:57

Simple Server Configuration

Preview

00:03:13

Oracle Shared Servers or MTS pt. 1

Preview

00:00:51

Oracle Shared Servers or MTS pt. 2

Preview

00:00:43

Simple Client Configuration

Preview

00:03:31

Connection Profiles

Preview

00:03:17

Introducing Naming Options pt. 1

Preview

00:01:23

Introducing Naming Options pt. 2

Preview

00:03:42

Oracle Connection Manager

Preview

00:01:20

Net Configuration Assistant

Preview

00:02:01

Net Manager

Preview

00:01:16

Using Oracle Enterprise Manager

Preview

00:00:55

Introducing Backup/Recovery Options/Utilities

Different Backup and Recovery Options

Preview

00:04:46

Import and Export

Preview

00:01:45

Cold Backups (Offline)

Preview

00:02:36

Hot Tablespace Backups (Online)

Preview

00:02:26

RMAN or Recovery Manager

Preview

00:03:41

Recovery

Preview

00:02:48

Standby Databases

Preview

00:03:40

Physical Standby Databases

Preview

00:00:44

Logical Standby Databases

Preview

00:01:34

Replication

Preview

00:01:50

Replication by Other Means

Preview

00:01:24

What are Transportable Tablespaces?

Preview

00:01:21

What is SQL*Loader?

Preview

00:02:11

Oracle Net Services Architecture

Oracle Net Services Architecture

Preview

00:01:01

Open Systems Interconnection (OSI) Model

Preview

00:05:35

Oracle OSI Model

Preview

00:04:16

Protocols

Preview

00:04:39

Net Services Communication

Preview

00:02:23

Dedicated and Shared Connections

Preview

00:03:08

Shared Server Processes and Dispatchers

Preview

00:02:50

Configuring a Simple Connection

The TNS Names Configuration File

Preview

00:02:16

The Profile Parameters File

Preview

00:01:03

Database Configuration Parameters pt. 1

Preview

00:03:51

Database Configuration Parameters pt. 2

Preview

00:02:38

Using the Net Configuration Assistant pt. 1

Preview

00:02:40

Using the Net Configuration Assistant pt. 2

Preview

00:01:01

The Listener

What is the Listener? pt. 1

Preview

00:01:21

What is the Listener? pt. 2

Preview

00:00:55

Basic Listener Configuration

Preview

00:03:32

The Listener Control Utility

Preview

00:03:27

Service Registration

Preview

00:01:36

Listener Queue Size

Preview

00:01:40

Switching Off Listener Logging and Tracing

Preview

00:03:03

Timeouts

Preview

00:00:50

Multiple Listeners pt. 1

Preview

00:02:45

Multiple Listeners pt. 2

Preview

00:02:03

Connection Load Balancing and Failover

Preview

00:03:11

The Session Data Unit Buffer (SDU)

Preview

00:02:40

Connection Profile Configuration

Preview

00:01:46

Connection Strings and Naming Methods

Connection Strings

Preview

00:01:56

Naming Methods

Preview

00:01:57

Local Naming Using TNS

Preview

00:01:09

Host Naming

Preview

00:01:46

External Naming

Preview

00:00:52

Directory Naming pt. 1

Preview

00:01:06

Directory Naming pt. 2

Preview

00:02:37

Oracle Names Server

Preview

00:05:26

Oracle Shared Servers

Multithreaded Server

Preview

00:04:32

Introducing Dispatchers

Preview

00:01:32

Dispatchers and Connection Pooling

Preview

00:02:54

Other Shared Server Parameters

Preview

00:01:10

Overriding Shared Servers

Preview

00:01:02

Connection Manager

What is Connection Manager?

Preview

00:01:40

Connection Concentration

Preview

00:01:10

Multiple Protocol Support

Preview

00:01:19

Configuring Connection Manager

Preview

00:01:47

Other Oracle Net Services Utilities

Other Oracle Net Services Utilities

Preview

00:03:19

Oracle Net Services Advanced Features

What is TAF?

Preview

00:01:17

TAF Parameters

Preview

00:01:47

Configuring TAF

Preview

00:01:27

Non-Oracle Database Connections

Preview

00:01:50

Oracle Net Services Metadata

Performance Views

Preview

00:04:18

Backup and Recovery

What is Backup and Recovery?

Preview

00:01:51

Why Backup and Recovery?

Preview

00:00:51

Things to Remember

Preview

00:03:03

Things to Consider with Datafiles

Preview

00:00:45

Redo Logs

Preview

00:03:12

Controlfiles

Preview

00:02:42

Archive Logs

Preview

00:00:54

More Things to Consider

Preview

00:03:23

Yet More Things to Consider

Preview

00:02:37

Importance of Backup and Recovery

Preview

00:02:08

Points of Failure

Preview

00:06:19

Backup Strategy

Preview

00:06:36

How Backup and Recovery Works

Processes/Memory Structures/Checkpoints

Preview

00:02:43

All the Files

Preview

00:01:47

SCNs

Preview

00:01:50

Restore and Recovery

Preview

00:03:26

Archive Configuration

Basic Archive Configuration Parameters

Preview

00:03:44

Archive Log Mode Configuration pt. 1

Preview

00:03:14

Archive Log Mode Configuration pt. 2

Preview

00:03:32

Multiple Archiving Processes

Preview

00:03:31

Multiple Archive Destinations

Preview

00:01:55

Standby Archiving pt. 1

Preview

00:02:26

Standby Archiving pt. 2

Preview

00:03:46

Logical Backups Using Exports

Full Exports and Imports

Preview

00:04:57

Schemas

Preview

00:03:49

Multiple Schemas

Preview

00:00:45

Importing to a Different Schema

Preview

00:02:20

Tables

Preview

00:02:17

The Parameter File

Preview

00:01:25

Export and Import Options

Preview

00:02:07

Physical Backup/Restore/Recovery

Cold Backups

Preview

00:03:00

Hot Backups

Preview

00:04:25

Verify Backups Using DBVERIFY

Preview

00:04:09

Recovering Using Offline Physical Backups

Preview

00:01:06

Recovering Using Online Physical Backups

Preview

00:06:03

Read Only Tablespaces

Preview

00:01:06

Incomplete Recovery

Preview

00:00:41

Scripting Hot Backups

Preview

00:03:25

RMAN (Recovery Manager)

What is RMAN?

Preview

00:03:12

Repository and Catalog

Preview

00:02:24

The Recovery Catalog

Preview

00:01:41

RMAN Architecture

Preview

00:01:36

What is a Channel?

Preview

00:01:18

Allocating and Releasing Channels

Preview

00:01:04

Creating an RMAN Database

Preview

00:02:59

Creating a Repository

Preview

00:02:38

Connecting to RMAN

Preview

00:02:54

Registering Databases with the Repository

Preview

00:02:50

Viewing the Repository

Preview

00:03:00

Backup Sets

Preview

00:01:41

Types of Backups

Preview

00:00:55

Controlfile Backups

Preview

00:01:52

Datafile Backups

Preview

00:01:44

Tablespace Backups

Preview

00:01:11

Archive Log Backups

Preview

00:01:47

Binary Parameter File Backups

Preview

00:00:25

Database Backups

Preview

00:02:59

Incremental Backups

Preview

00:04:06

Restore and Recovery

Preview

00:01:19

Restore and Recovery in Action

Preview

00:04:23

Scripts and RMAN

Preview

00:02:11

Deleting RMAN Backups

Preview

00:04:23

Oracle Enterprise Manager Backup and Recovery

Configuring Oracle Enterprise Manager

Preview

00:03:51

Communications

Preview

00:03:10

Win2K Log on as Batch Job

Preview

00:02:14

Export

Preview

00:02:37

Import

Preview

00:02:11

Backup and Recovery

Preview

00:03:57

Backup and Recovery Metadata

Performance Views

Preview

00:04:43

Transportable Tablespaces

What are Transportable Tablespaces?

Preview

00:01:06

Uses of Transportable Tablespaces

Preview

00:02:16

Limitations

Preview

00:01:28

Tablespace Sets

Preview

00:03:55

Tablespace Set Verification

Preview

00:03:39

Transporting a Tablespace Set

Preview

00:04:22

Plug In

Preview

00:03:46

SQL*Loader

What is SQL*Loader?

Preview

00:01:31

The Control File and Complexity

Preview

00:01:51

Input Data File

Preview

00:00:35

Input Data File Structures

Preview

00:04:45

How Rows are Loaded

Preview

00:01:31

Multiple Tables and Formats

Preview

00:02:40

Column Delimiters

Preview

00:04:26

NULL Values

Preview

00:01:05

Load Filtering

Preview

00:01:36

Filler Fields

Preview

00:01:28

Data Types

Preview

00:04:26

Conditional Replacement

Preview

00:02:05

Using SQL

Preview

00:02:53

Generating Data Not in Input Files

Preview

00:00:55

Executing SQL*Loader

Preview

00:02:46

Conventional Versus Direct

Preview

00:01:19

The Parameter File

Preview

00:00:53

A Simple Example Load pt. 1

Preview

00:04:52

A Simple Example Load pt. 2

Preview

00:03:31

Oracle Enterprise Manager

Preview

00:02:10

Credits

About this Author

Preview

00:02:00