Schulung/Seminar: Oracle Database 10g: Implement Streams |
 |
| Seminar-ID: | D17333 |  Beschreibung |
|
| Preis: | EUR 3688,- zzgl. Mwst. | Angebot |
|
| Dauer: | 5 Tage | Buchung |
|
Lerninhalte
Teilnehmerkreis
Vorkenntnisse
Kursziel
Sachgebiete
Aktuelle Termine
Zurück zur Seminarauswahl
Lerninhalte
Configure an Oracle Streams environmentMonitor the capture, propagation, and apply of events
Alter the Streams environment to add new sites or objects
Configure conflict handling for data replication
Transform the data being replicated between two sites
Enqueue and dequeue messages using Oracle Streams
Perform basic troubleshooting of a Streams environment
Top
Teilnehmerkreis
DatenbankadministratorenTechnische Berater
Top
Vorkenntnisse
Oracle9i Datenbankadministration I & IIEmpfohlene Vorkenntnisse:
Oracle9i Database: Distributed Systems
Oracle Database 10g: NF für Administratoren
Oracle Database 10g: Administration Workshop I
Top
Kursziel
If you're using a variety of technologies to share and propagate data, events, and messages, it's time to simplify with the help of the powerful and flexible information-sharing feature called Oracle Streams. This course introduces you to Oracle Streams, which allows you to share data, messages, and events between schemas, applications, and databases. The lessons are designed to give you practical experience in configuring and managing a Streams environment. The course includes lessons on the fundamental components of Oracle Streams and how to administer each of these components. Also included are best practice guidelines and troubleshooting practices.This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification.
Top
Sachgebiete
Introduction and OverviewOracle Streams: Basic Elements
Capture and Event Staging
Staging Area Propagation
Rules Engine
Oracle Streams with Single-Source and Multiple-Source Database
Oracle Streams Usage: Scenarios
Using Oracle Streams for Upgrades and Migrations
Interfaces to Oracle Streams
Database Configuration
Configuring Database Parameters
Configuring Archive Logging
Supplemental Logging
Database Configuration with Enterprise Manager
Configuring Communication Between Databases
Configuring Multiple Streams Sites
Additional Preparation for File Propagation
Basic Objects of Oracle Streams
Object Types
Streams Events
Logical Change Records (LCRs)
Creating and Managing a Streams Administrator User
Staging Area Architecture
SYS.AnyData Queues
Creating a Staging Queue
View Interface to Queue Buffers
System-Created Rules
Using Rules in Oracle Streams
Generating System-Created Rules
Using Subset Rules with Oracle Streams
Row Subsetting
Customizing System-Created Rules
Negative Rule Sets
Rule Evaluation with Negative Rule Sets
Monitoring Rules
Enterprise Manager Interface to Oracle Streams
Oracle Streams Manageability Features
Configuring Oracle Streams
Streams Setup Page
Streams Tablespace Replication Wizard
Capture Management
Apply Management
Propagation Management
Managing Message Transformations
Simplified Streams Configuration
Simplified Configuration Procedures
Replicating a Single Tablespace (MAINTAIN_SIMPLE_TTS) and a Set of Tablespaces (MAINTAIN_TTS)
Instantiating Database Objects
Replicating Tables, Schemas, and Entire Database
Improved Diagnostics for Streams
Removing a Streams Queue
Removing All Streams Components
Capture Process Concepts
Capture
Implicit Event Capture
Capture Process Components
Identifying Changes to Capture
Logical Change Records (LCRs)
Data Types, DDL and DML Types Captured
Commands and DDLs Not Captured
Streams Tags and Downstream Capture
Configuring a Capture Process
Creating the Capture Process
Downstream Capture
Capture Process Parameters
Starting and Managing the Capture Process
Monitoring Log File Availability
Capture Process Statistics
Troubleshooting Capture
Instantiation
Performing Instantiation
Preparing for Instantiation
Setting the Instantiation SCN
Import Instantiation and Creation
Instantiation Using Data Pump
Setting the Instantiation SCN Manually
Instantiating a Database Using RMAN
Verifying Instantiations at an Apply Site
Propagation Concepts and Configuration
Directed Networks
Queue and Forwarding
Apply Forwarding
Queue-to-Queue Propagation
Propagation Job, Rules, and Scheduling
Creating, Managing, and Monitoring Propagation
Troubleshooting Propogation Configuration
Apply Concepts and Configuration
Processing Streams Events
Applying DDL Events
Error Queue
Required Apply User Privileges
Apply Process Components and Rules
Enqueue Destination and Execution Directives During Apply
Virtual Dependency Definition
Apply Process and Parameters
Transformations
Rule-Based Transformations
Declarative LCR Transformations
Customized Rule-Based Transformations
Modifying an LCR
Using LCR Extra Attributes
Creating a Rule-Based Transformation
One-to-many Transformations
Viewing and Managing Rule-Based Transformations
Apply Handlers
Creating an Apply Handler Procedure
Implementing a DML Handler
Creating an Error Handler
Implementing a DDL and a Precommit Handler
Restrictions for Apply Handler Procedures
Managing Apply Handlers
Customizing Apply Handler Actions
Viewing Apply Handler Information
Administering a Streams Environment
Managing the Capture Process
Managing Propagations
Managing Apply Processes
Starting and Stopping Streams Processes
Managing Streams Process Rule Sets
Troubleshooting Apply Failures
Reconfiguring
Top
Termine
Aktuelle Termine auf Anfrage training@cns-gruppe.comTop
Info-Hotline von 9.00 - 18.00 Uhr:
Kostenlos aus dem Deutschen Festnetz,
oder +49.2302.914210 aus dem Ausland bzw. vom Handy