Slide 1

Slide 1 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Understanding Oracle GoldenGate BGOUG, June 2014 Sandanski

Slide 2

Slide 2 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 “The more I learn, the more I realize how much I don't know.” - Albert Einstein So Many Oracle Manuals, So Little Time – Iggy Fernandez blog

Slide 3

Slide 3 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Pictures VS Bullets

Slide 4

Slide 4 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Who Am I • (Sve)toslav Gyurov • Principal consultant at e-DBA • Working mainly on Exadata and migrations • GTD and 7 Ps (Proper Planning and Preparation Prevents Piss Poor Performance ) • I’m tall – 202cm (6 feet 717⁄32 inches) • Futurama and Friends big fan • I blog – http://sve.to and tweet - @sgyurov

Slide 5

Slide 5 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Customers Some of our Customers

Slide 6

Slide 6 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Introduction

Slide 7

Slide 7 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Introduction • GoldenGate Software founded in 1995 • Acquired by Oracle in September 2009 • Now part of the Oracle Fusion Middleware product family • Near real-time transactional data replication in a heterogeneous computing environment

Slide 8

Slide 8 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Introduction • Supported topologies: – Unidirectional (reporting or migration) – Bi-directional (active-passive or active-active) – Broadcast (data distribution) – Consolidation (DWH consolitation)

Slide 9

Slide 9 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Supported databases • Oracle Database 9.2i, 10g, 11g, 12c • TimesTen 7.0.5 • MySQL 4.1, 5.0 • IBM DB2 8.1, 8.2, 9.1, 9.5 • Microsoft SQL Server 2000, 2005, 2008 • Teradata V2R5, V2R6 • Sybase ASE 12.5.4, 15.0

Slide 10

Slide 10 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Architecture

Slide 11

Slide 11 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Oracle GoldenGate for Oracle Database

Slide 12

Slide 12 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 System requirements • Supported platforms • Memory and disk requirements • Network configuration • Database version • Supported data types and objects

Slide 13

Slide 13 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Supported version • Oracle GoldenGate 11g supports: – Oracle Database Oracle 10.2.0.4+, Oracle 11.1.0.6+, Oracle 11.2.0.1+ • Oracle GoldenGate 12c supports: – Oracle Database 11.1.0.6+, 11.2.0.1+, 12.1.0.1+ • Source and target GG must be same versions!

Slide 14

Slide 14 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Extract (capture) • Data pump (routing) • Replicat (delivery) • Trails or extract files • Checkpoints • Manager • Collector

Slide 15

Slide 15 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Extract – Capture mechanism of Oracle GoldenGate – Initial load or change synchronization – Extract captures DML and DDL operations – Only captures committed transactions – Writes to trail files

Slide 16

Slide 16 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Extract continued – Log-based – Filtering – Bounded Recovery – 4H – CACHEMGR – Classic capture (trigger based) – Integrated capture (11.2.0.4)

Slide 17

Slide 17 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configuration options

Slide 18

Slide 18 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Classic capture • Was the original capture method • Trigger based • Restricted support for the complex data types • Supports any database except multitenant container database • Redolog/archive log mining

Slide 19

Slide 19 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Integrated capture • Integrated within the database • Interacts directly with a database logmining server • Supports more data and storage types • Only mode that supports multitenant db • Support for Basic, OLTP, EHCC compression • Compatibility must be set to 11.2.0.4

Slide 20

Slide 20 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Data pump – Not Oracle Datapump – Just another extract process – Reads trail and send it over network (TCP/IP) – Transfer is always ASYNCHRONOUS – Compression and encryption are optional – pass-through mode

Slide 21

Slide 21 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Replicat – Runs on the target – Reads trail and reconstructs DML or DDL – Performs data filtering, mapping, and conversion – Apply can be delayed – COMMIT NOWAIT - starting v11.1.1.1 – Integrated and nonintegrated replicat (trigger based)

Slide 22

Slide 22 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Trail – Local and remote trail – Extract writes to trail – Data pump and Replicate reads from trail – Stored in ./dirdat/ by default – Names are automatically generated (lt) and (rt) – Unique six-digit sequence number from 000000 to 999999 – The data in this trail file is in commit order sequence!

Slide 23

Slide 23 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Manager – Controls Golden Gate – Runs on each system – Maintain port numbers – Performs trail management

Slide 24

Slide 24 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Checkpoint – Store current read or write position – Extract – checkpoint file – Replicate – checkpoint table

Slide 25

Slide 25 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Components • Collector – Communicates with remote Extract and Manger – Receive extracted db changes – Writes changes to the trail – Uses TCP/IP

Slide 26

Slide 26 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Supported Data Types • Data types supported by integrated and classic capture mode: – NUMBER – BINARY FLOAT – BINARY DOUBLE – CHAR – VARCHAR2 – LONG – NCHAR – NVARCHAR2 – RAW – LONG RAW – DATE – TIMESTAMP – CLOB – NCLOB – BLOB – SECUREFILE and BASICFILE

Slide 27

Slide 27 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Supported Data Types • The following data types are no supported: – REFs – ANYDATA – ANYDATASET – ANYTYPE – BFILE – MLSLABEL – ORDDICOM – TIMEZONE_ABBR – URITYPE – UROWID (classic capture)

Slide 28

Slide 28 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 RAC support • RAC is supported – Limited support with classic capture – Fully supported with integrated capture • Shared storage support: – DBFS – ACFS – OCFS

Slide 29

Slide 29 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 High Availability • Oracle GI integration – Oracle Grid Infrastructure Bundled Agent (starting 11.2.0.3) – Manually create agent script (prior 11.2.0.3) • Golden Gate AUTOSTART of groups – Upon start Manager will start Extract, Data Pump and Replicat

Slide 30

Slide 30 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Security • Oracle GoldenGate security options: – Trail File encryption (AES) – Password encryption (no clear-text passwords) – TCP/IP encryption (AES or Blowfish) – Trusted connection (low sec to high sec) – Command authentication

Slide 31

Slide 31 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configuration

Slide 32

Slide 32 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Installation • Environment: – OEL 6.4 – Oracle Database 11.2.0.4 – Oracle GoldenGate 12.1.2.0.0 – GoldenGate Integrated capture and apply! SQL> desc sve.orders; Name Null? Type ---------------------------- -------- ---------------------------- ORDER_ID NOT NULL NUMBER ORDER_DATE DATE CUSTOMER_NAME VARCHAR2(64)

Slide 33

Slide 33 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Installation • Latest version – 12.1.2 and just 326 MB! unzip -q 121200_fbo_ggs_Linux_x64_shiphome.zip cd fbo_ggs_Linux_x64_shiphome/Disk1/ ./runInstaller

Slide 34

Slide 34 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Installation

Slide 35

Slide 35 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Pre checks • Oracle GoldenGate database Complete Database Profile check script for Oracle DB (All Schemas) (Doc ID 1298562.1) • Oracle GoldenGate database Schema Profile check script for Oracle DB (Doc ID 1296168.1)

Slide 36

Slide 36 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Database requirements • Configure logging properties – Archivelog mode – Force logging – Minimal supplemental logging – Table-level logging (supplemental log groups) – Enable Flashback – 11.2.0.4 • ENABLE_GOLDENGATE_REPLICATION=true

Slide 37

Slide 37 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configure Database SQL> alter database add supplemental log data; SQL> alter database force logging; SQL> create tablespace ggs_data datafile '/oracle/oradata/orcl/orcl_ggs_data_01.dbf' size 128m autoextend on next 16m maxsize 4g; SQL> create user ggs_owner identified by Welcome1 default tablespace ggs_data temporary tablespace temp; SQL> grant connect, resource, dba to ggs_owner; SQL> alter system set enable_goldengate_replication=true; SQL> EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE( - grantee => 'ggs_owner', privilege_type => 'capture', grant_select_privileges=> true, do_grants => TRUE);

Slide 38

Slide 38 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configure GoldenGate • Create extract param file vi vi $GG_HOME/dirprm/orcle1.prm EXTRACT ORCLE1 USERID ggs_owner PASSWORD Welcome1 LOGALLSUPCOLS UPDATERECORDFORMAT COMPACT DDL INCLUDE MAPPED EXTTRAIL /oracle/product/12.1.2.GG/dirdat/lt TABLE sve.*;

Slide 39

Slide 39 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configure GoldenGate • Create pump param file using ggsci [oracle@oel2 12.1.2.GG]$ ./ggsci GGSCI (oel2) 2> edit params orclp1 EXTRACT ORCLP1 USERID ggs_owner PASSWORD Welcome1 RMTHOST my-remote-host.net, MGRPORT 7809 RMTTRAIL /oracle/product/12.1.2.GG/dirdat/rt PASSTHRU TABLE sve.*;

Slide 40

Slide 40 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configure GoldenGate • Create replicat param file [oracle@oel1 12.1.2.GG]$ ./ggsci GGSCI (oel1) 2> edit params orclr1 REPLICAT ORCLR1 DBOPTIONS INTEGRATEDPARAMS(parallelism 6) USERID ggs_owner PASSWORD Welcome1 ASSUMETARGETDEFS MAP sve.*, TARGET sve.*;

Slide 41

Slide 41 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configure GoldenGate • Add supplemental logging and register extract [oracle@oel2 12.1.2.GG]$ ./ggsci GGSCI (oel2) 1> DBLOGIN USERID ggs_owner password Welcome1 Successfully logged into database. GGSCI (oel2) 2> ADD TRANDATA sve.* Logging of supplemental redo data enabled for table SVE.ORDERS. TRANDATA for scheduling columns has been added on table 'SVE.ORDERS'. GGSCI (oel2) 3> register extract orcle1 database Extract ORCLE1 successfully registered with database at SCN 962593.

Slide 42

Slide 42 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Behind the scenes Thu Jun 12 11:22:07 2014 Logminer Bld: Build started ALTER SYSTEM SWITCH ALL LOGFILE start (orcl) Thu Jun 12 11:22:25 2014 Logminer Bld: Done 2014-06-12 11:22:43.735000 +01:00 GoldenGate CAPTURE CP01 for OGG$CAP_ORCLE1 with pid=30, OS id=4272 is in combined capture and apply mode. Capture OGG$CAP_ORCLE1 is handling 1 applies. -- capture is running in apply-state checkpoint mode. 2014-06-12 11:22:47.259000 +01:00 Starting persistent Logminer Session with sid = 1 for GoldenGate Capture OGG$CAP_ORCLE1

Slide 43

Slide 43 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Are we there yet ? • Checklist: – Database – Extract process – Data pump process – Replicat process • Start the processes and enjoy life!

Slide 44

Slide 44 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Start capture GGSCI (oel2) 22> start extract orcle1 Sending START request to MANAGER ... EXTRACT ORCLE1 starting GGSCI (oel2) 23> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING ORCLE1 00:00:10 00:00:02 • Start Extract

Slide 45

Slide 45 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Trail files SQL> insert into orders (order_id, order_date, customer_name) values (1,to_date('2014-06-11', 'YYYY- MM-DD'), 'Sve'); SQL> commit; [oracle@oel2 12.1.2.GG]$ strings /opt/oracle/product/11.2.1.GG/dirdat/lt000000 | tail -6 SVE.ORDERS 2014-06-11:00:00:00 SveT AAAVVDAAEAAAACvAAA 9862636 3.18.926Z

Slide 46

Slide 46 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Oracle Database 12c

Slide 47

Slide 47 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Oracle Database 12c • Extract – capture from multiple pluggable dbs to single trail – Must operate in integrated capture mode – Must connect to root container • Replicat – Apply only to one pluggable db – Integrated delivery

Slide 48

Slide 48 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Configure GoldenGate cat > $GG_HOME/dirprm/orclp1.prm EXTRACT ORCLE1 USERID ggs_owner PASSWORD Welcome1 LOGALLSUPCOLS UPDATERECORDFORMAT COMPACT DDL INCLUDE MAPPED EXTTRAIL /oracle/product/12.1.2.GG/dirdat/lt SOURCECATALOG pdb1 TABLE sve.*; SEQUENCE sve.seq*; SOURCECATALOG pdb2 TABLE scott.*; SEQUENCE scott*.seq*; • Extract in 12c

Slide 49

Slide 49 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Trail files, logdump and GoldenGate records

Slide 50

Slide 50 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Trail file FileHeader and TrailInfo MachineInfo DatabaseInfo Commited transaction ProducerInfo

Slide 51

Slide 51 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Logdump • Mainly used by Oracle Support • Swiss army knife of troubleshooting GoldenGate • Enables search, read and save data in a trail file • Identify a transaction for a given SCN in Oracle • Identify the before images of a row • Count the number of changes table

Slide 52

Slide 52 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 GoldenGate record Operation and time of record Object Before or after image Record data in HEX Length of record and RBA in trail Column information with data Record data in ASCII Header, transaction information

Slide 53

Slide 53 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Monitoring

Slide 54

Slide 54 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Monitoring • Command line – ggssi – info, status, lag, view report – Monitoring lag – Process report – Error log – Discard file

Slide 55

Slide 55 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Monitoring GGSCI (oel2) 12> info orcle1 EXTRACT ORCLE1 Last Started 2014-06-12 11:40 Status RUNNING Checkpoint Lag 00:00:09 (updated 00:00:08 ago) Process ID 4449 Log Read Checkpoint Oracle Integrated Redo Logs 2014-06-12 13:54:10 SCN 0.986714 (986714) GGSCI (oel2) 13> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING ORCLE1 00:00:10 00:00:02

Slide 56

Slide 56 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Monitoring • Management Pack for Oracle GoldenGate • Oracle GoldenGate Plug-in on OEM 12c Cloud Control

Slide 57

Slide 57 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Monitoring • SQL Developer – Bobby Curtis http://dbasolved.com/

Slide 58

Slide 58 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Best Practices

Slide 59

Slide 59 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 • Run it in your environment and find the best solution for you, but keep in mind: – Monitor the processes – Purge the logs – Keep enough archivelogs – Use integrated modes where possible

Slide 60

Slide 60 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Good news everyone

Slide 61

Slide 61 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 License • Of course it is licensed • And yes, both databases must be licensed • Processor license cost - $17500 • The Oracle GoldenGate product includes license cover for Active Data Guard.

Slide 62

Slide 62 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Statement of direction Oracle Streams continues to be supported but will not be enhanced to support any new database features in future releases. This means that Streams will continue to support exactly what it supports today (11.2) in future releases. It also means that any new database features, data types, or capabilities will not be supported by Streams. Customers who want to take advantage of the new data types and features will need to license Oracle GoldenGate.

Slide 63

Slide 63 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Bottom line • It worked for me! • Integrated capture/apply vs nonintegrated • Same version on source and target • Remember the 7Ps rule!

Slide 64

Slide 64 text

+44 (0) 844 811 3600 [email protected] www.e-dba.com A RedStack Technology Company Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014 Thank you!