experience
ORACLE
for Oracle Streams Commander
[email protected]
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.
[email protected]
Oracle Streams Commander (OSC)
Stefan Menschel
BU Server Technology Germany
ORACLE Deutschland GmbH
[email protected]
SQL> SELECT … FROM dba_capture;
SQL> SELECT … FROM dba_apply;
SQL> EXEC DBMS_CAPTURE_ADM.START_CAPTURE(…
[email protected]
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
[email protected]
Æ
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
[email protected]
[email protected]
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
[email protected]
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
[email protected]
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
[email protected]
Database B
Oracle Streams Commander (OSC)
Installation Streams Environment
1. anpassen 00_define.sql an Zielumgebung
[email protected]
Oracle Streams Commander (OSC)
00_define.sql
[email protected]
Oracle Streams Commander (OSC)
Build your Streams Environment
[email protected]
Oracle Streams Commander (OSC)
Installation OSC
[email protected]
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)
[email protected]
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/"
[email protected]
[email protected]
Hinweise 1
Oracle Streams Forum
http://forums.oracle.com/forums/forum.jspa?forumID=70
oder einfach
[email protected]
Hinweise 2
Healthcheck Script
My Oracle Support Æ DocID : 273674.1
[email protected]
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;
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
experience
ORACLE
for Streams
[email protected]
[email protected]