ORACLE Streams Commander

experience
ORACLE
for Oracle Streams Commander
stefan.menschel@oracle.com
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into any
contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decisions.
The development, release, and timing of any
features or functionality described for Oracle’s
products remains at the sole discretion of Oracle.
stefan.menschel@oracle.com
Oracle Streams Commander (OSC)
Stefan Menschel
BU Server Technology Germany
ORACLE Deutschland GmbH
stefan.menschel@oracle.com
SQL> SELECT … FROM dba_capture;
SQL> SELECT … FROM dba_apply;
SQL> EXEC DBMS_CAPTURE_ADM.START_CAPTURE(…
stefan.menschel@oracle.com
Oracle Streams
Konfigurieren
1. Benutzung von DBMS-Packages (Oracle Streams API)
DBMS_STREAMS_ADM
DBMS_xxx_ADM
und
(xxx = Capture, Propagation, Apply, Rule)
2. Benutzung des Oracle Enterprise Managers (Einschränkungen)
GUI
Two-sites, One-way
3. über Oracle Streams Commander (einfach & schnell)
00_define.sql
stefan.menschel@oracle.com
Æ
00_install.sql
Oracle Streams Commander
Basics I
 kostenfreies Werkzeug für Monitoring und Administration
 Download
http://www.oracle.com/global/de/community/platform/osc/index.html
 oder einfach
stefan.menschel@oracle.com
stefan.menschel@oracle.com
Oracle Streams Commander
Basics II
Primary
Secondary
Database
Database
Primary
Primary
Database
Database
Single Source Replication
Secondary
Secondary
Database
Database
Multiple Source Replication
Multiple Source Replication
Hub & Spoke
Multimaster
Primary
Intermediate
Secondary
Database
Database
Database
Single Source with Forwarding or Downstream Capture
stefan.menschel@oracle.com
Oracle Streams Commander
Architektur
OSC – Web Frontend
Oracle
HTTP-Server
OSC-Repository
im „Streams“
Schema
DB-Link
OSC Objekte
im „Streams“
Schema
repliziertes Schema
Database A
stefan.menschel@oracle.com
Database B
Oracle Streams Commander (OSC)
Installation
• Install OSC on top on your existing Streams Environment
• you can build an streams environment first
OSC Objekte
im „Streams“
Schema
OSC-Repository
im „Streams“
Schema
repliziertes Schema
Database A
stefan.menschel@oracle.com
Database B
Oracle Streams Commander (OSC)
Installation Streams Environment
1. anpassen 00_define.sql an Zielumgebung
stefan.menschel@oracle.com
Oracle Streams Commander (OSC)
00_define.sql
stefan.menschel@oracle.com
Oracle Streams Commander (OSC)
Build your Streams Environment
stefan.menschel@oracle.com
Oracle Streams Commander (OSC)
Installation OSC
stefan.menschel@oracle.com
Oracle Streams Commander (OSC)
Installation OSC
Installation OSC
in Abhängigkeit vom Streams Environment
Æ starten Scripte 01a…..sql (OSC – Repository DB)
01b..…sql (erste Ziel DB)
01c…..sql (weitere Ziel DB)
stefan.menschel@oracle.com
Oracle Streams Commander (OSC)
Installation OSC – Anpassung HTTP Server
New DAD in dads.conf
<Location /pls/osc>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername streams
PlsqlDatabasePassword streams
PlsqlDatabaseConnectString smensche-de:1521:mas10r2
PlsqlDefaultPage inhalt
PlsqlErrorStyle DebugStyle
</Location>
Anpassung httpd.conf
Alias /icons/
"D:\oracle\product\http\ohs/icons/"
Alias /osc_docu/
"C:\OSC\DOCUMENTATION/"
Alias /osc/
"C:\OSC\02 INSTALLATION OSC\OSC-SOURCE\icons/"
stefan.menschel@oracle.com
stefan.menschel@oracle.com
Hinweise 1
Oracle Streams Forum
http://forums.oracle.com/forums/forum.jspa?forumID=70
oder einfach
stefan.menschel@oracle.com
Hinweise 2
Healthcheck Script
My Oracle Support Æ DocID : 273674.1
stefan.menschel@oracle.com
Hinweise 3
Performance
• move LOGMNR into separate LOGMNR Tablespace
exec DBMS_LOGMNR_D.SET_TABLESPACE('LOG_MNR');
• set STREAMS_POOL_SIZE
• set _job_queue_interval
• configure 2 queue tables (one for capture + one for apply)
• set propagation latency to 1
exec dbms_aqadm.alter_schedule(queue_name,destination,latency=>1);
• improve performance of streams spillover table
alter table aq$_<queue_table_name>_p enable row_movement;
alter table aq$_<queue_table_name>_p shrink space;
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
stefan.menschel@oracle.com
experience
ORACLE
for Streams
stefan.menschel@oracle.com
stefan.menschel@oracle.com