Schulung/Seminar: Oracle Database 11g: Implement Streams |
 |
| Seminar-ID: | D50315 |  Beschreibung |
|
| Preis: | EUR 3685,- zzgl. Mwst. | Angebot |
|
| Dauer: | 5 Tage | Buchung |
|
Lerninhalte
Teilnehmerkreis
Vorkenntnisse
Kursziel
Sachgebiete
Aktuelle Termine
Zurück zur Seminarauswahl
Lerninhalte
• Quickly and easily configure an Oracle Streams environment• Monitor 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
• Datenbankadministratoren• Vertriebsberater
• Technischer Berater
Top
Vorkenntnisse
• Oracle Database 11g: Administration Workshop IEmpfohlene Vorkenntnisse:
• Oracle Database 11g: Administration Workshop II
Top
Kursziel
Oracle Streams allows students to share data, messages, and events between schemas, applications, and databases. This course includes lessons on the fundamental components of Oracle Streams and how to administer each of these components. The lessons are designed to give students practical experience in configuring and managing a Streams environment. The course covers enqueue and dequeue messages using Oracle Streams. Also included are best practice guidelines and troubleshooting practices.This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
Learn To:
• Administering a Streams Environment
• Manage Data Conflicts
• Troubleshoot the Streams Environment
• Configure Streams Environment
Top
Sachgebiete
Introduction and Overview• Oracle 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
Apply Handlers
Administering a Streams Environment
Reconfiguring the Streams Environment
Data Conflicts
Conflict resolution
Message Queuing Concepts
Enqueuing and Dequeing Events
Best Practices and Operational Considerations
Troubleshooting Oracle Streams
Top
Termine
| 08.11.2010 | Düsseldorf |
Info-Hotline von 9.00 - 18.00 Uhr:
Kostenlos aus dem Deutschen Festnetz,
oder +49.2302.914210 aus dem Ausland bzw. vom Handy