• Thanks for your assistance and your good product. We took our first Summit Canada data centre client live the first weekend in February with two standby servers. The latest patch supporting the ability to automatically process the archive log on the standby server is brilliant. I always like less maintenance and fewer things to go wrong. Keep up the good work.

    Mark Weeden, Senior Software Developer/Oracle DBA, OCP— Fiserv

Replicate Latest Changes

Dbvisit Replicate Latest Changes Listing

2.8.06 (4 August 2017)

  1. RQ-2589: Fix an APPLY crash due to an overflow in number precision when replicating to L
  2. RQ-2910: Improve communication between FETCHER and MINE
  3. RQ-3075: Various internal changes regarding FETCHER performance (#9995)
  4. RQ-3086: Fix an issue when List obsolete redo was not moving forward (#10276, #11094)
  5. RQ-3142: Improve thread locking causing error FATAL-5203
  6. RQ-3167: Fix an APPLY crash when running "apply commit transaction XXX"
  7. RQ-3172: Fix an APPLY crash because of wrong ordering of changes at the same SCN (#10465)
  8. RQ-3198: Fix a MINE crash with FATAL-6301 (#10538)
  9. RQ-3216: Fix an APPLY crash with FATAL-4101 (#10538)
  10. RQ-3246: Fix an APPLY crash with FATAL-4106: syntax error at (eval 2572) line 4, near " (#10616)
  11. RQ-3252: Improve handling of timeout and network errors in MINE shown in logfile as -1506, WARN-4213, WARN-4504
  12. RQ-3259: Fix an issue when notifications sometimes were not sent from FETCHER
  13. RQ-3263: Fix an APPLY crash with FATAL-1537 - Incorrect string value: '\xD3N DE ...' column 'SQL_TEXT_NOBIND' at row 1 (#10663)
  14. RQ-3278: Improve log file rotation on Windows shown in log as WARN-2910, WARN-2910 633, #10682, #10835)
  15. RQ-3288: Improve handling of FATAL-4101: Segment violation (#10799)
  16. RQ-3305: Improve sending notifications when ARCHONLY is used (#10793)
  17. RQ-3333: Improve FETCHER log file rotation (#10793, #10631)
  18. RQ-3349: Resolve an issue where once you specify any option for the support package in console it is remembered for duration of session (#10970)
  19. RQ-3356: Backport of fix of "Out of memory error" during support package creation (323)
  20. RQ-3450: Fix an issue when files of type *.rtf & *.jar stored as BLOBS were not icated correctly
  21. RQ-3476: Resolve SIGSEGV due to no LOB value in ECOL$ update in DDL transaction (#11228)

2.9.00 (30 June 2017)

  1. Q-248: Add support for XML datatype
  2. Q-465: Improved dictionary load during MINE startup
  3. Q-506: Support temporal validity (12c)
  4. Q-593: New supported target - PostreSQL (Community Edition)
  5. Q-609: Internal improvements - fetcher failing to send archive logs due to network related issue following art
  6. Q-755: Add additional information regarding TNS_AMDIN to Nextsteps.txt
  7. Q-951: For both RESOLVE and DISCARD HANDLER commands handle IGNORE and DISCARD as same (synonyms)
  8. Q-1089: Add support for ROWID datatype
  9. Q-1427: Allow user to change the default for conflict handlers
  10. RQ-1852: Add option to enable sql trace (10046)
  11. RQ-1965: Improve ASM read speed
  12. RQ-2073: RESOLVE CONFLICT LAST implemented
  13. RQ-2096: Internal improvement on log messages with regards to ASM auto detection
  14. RQ-2215: Fix notification from MINE when FETCHER is down
  15. RQ-2239: New supported target - Kafka Connect connector
  16. RQ-2274: Improved TIMESTAMP mapping from Oracle to MySQL
  17. RQ-2370: Add full supplemental logging for Replicate internal tables
  18. RQ-2385: Improved process when Fetcher hits high redo generation (#9161)
  19. RQ-2398: Allow storing metadata dictionary for source database in another Oracle database
  20. RQ-2471: all.sh script doesn't set ON_ERROR and ON_WARNING to SKIP in the DDC database
  21. RQ-2623: Internal improved handling of FATAL-9087
  22. RQ-2678: dba_constraints and dba_triggers permissions missing in all.sh for AWS RDS
  23. RQ-2702: Create support package in temporary "in-progress" file and rename it when finished
  24. RQ-2704: Improved SNMP notification descriptions to traps (#9065)
  25. RQ-2782: Add additional information about running processes to support package (#9616)
  26. RQ-2791: New supported target - Tibero
  27. RQ-2817: Better handling of ALTER TABLE TRUNCATE
  28. RQ-2858: Improved handling of PLSQL replication and resolving SIGSEGV on apply (#9789)
  29. RQ-2880: Resolve FATAL-4101: Segment violation (SIGSEGV) received (#9789)
  30. RQ-2889: Resolve FATAL0: (free_c) Error no out of bounds for memory accounting (#9836, #9899)
  31. RQ-2901: Command UNSET_CONFLICT_HANDLERS to set the conflict handlers to default values
  32. RQ-2910: Various internal changes regarding Fetcher performance (#9995)
  33. RQ-2940: Resolve incorrect mine of "alter table add column" with default or multiple columns (#10051)
  34. RQ-2987: Resolve issue where ORA-00957: duplicate column name reported (#10051, #10070)
  35. RQ-3067: Fix handling of RAW datatype in conflict handlers
  36. RQ-3142: Improve thread locking causing error FATAL-5203
  37. RQ-3148: Handle cases when support package tries to connect to apply database and can't do so
  38. RQ-3158: Fix resetting of the number of failed checks in fetcher sequence notification
  39. RQ-3164: Error email notification from Mine process did not respect NOTIFY SET ERRE settings
  40. RQ-3166: Add support for BINARY_DOUBLE and BINARY_FLOAT datatypes
  41. RQ-3187: Allow "()" around select clause in CTAS (#10465, #10473)
  42. RQ-3198: Resolve Mine crash on FATAL-6301 (#10538)
  43. RQ-3254: Fix crashing apply commit/rollback transaction
  44. RQ-3269: Resolve issue with logs not rotating on Windows based systems (#10631)
  45. RQ-3273: Fix MINE: FATAL-5259: Memory limit exhausted
  46. RQ-3282: Improve sending of data between Fetcher and Mine
  47. RQ-3286: Improve handling of FATAL-2811 (#10682)
  48. RQ-3288: Improve handling of FATAL-4101: Segment violation (#10799)
  49. RQ-3289: Support non-upper case variations of Replicate Editions in setup wizard (#10799)
  50. RQ-3305: Improved sending notifications when ARCHONLY is used (#10793)
  51. RQ-3323: Fix "Out of memory" error during support package creation. Introduced new parameter PORT_PACKAGE_MAX_ZIP_MEMBER_SIZE
  52. RQ-3333: Improve Fetcher log file rotation (#10793, #10631)
  53. RQ-3349: Resolve issue where once you specify any option for the support package in the console it is mbered for duration of session
  54. RQ-3395: Improve performance of "truncate" statement
  55. RQ-3432: Improved handling of Azure SQL Server - introduce _APPLY_MSSQL_IS_AZURE_VARIANT
  56. RQ-3469: Fix Incorrectly handled DATE column and other duplicities when updating table with LOB

2.8.04 (11 January 2017)

  1. Fix incorrect parse of trailing NULLs in updates (RQ-2927 #10038)
  2. Improve speed of mining large transactions with many chained rows (RQ-3015 #10094)
  3. Fix duplicate columns in DDL_FILE with multiple mines (RQ-2799 #9455)

2.8.02 (16 November 2016)

  1. Regexp value stored incompletely if SQL handler's regexp contains OR expression (RQ-2485 #9074)
  2. Use much fewer DMLs to set coflict handlers (RQ-2238)
  3. Handle enabled row movement (RQ-2391 #8942)
  4. CDCAUDIT on schema now makes new tables inherit the settings (RQ-2489)
  5. Abort reading plog when plog entry header has wrong size (RQ-2573 #9155)
  6. Fix length of LONG datatype (RQ-2636)
  7. Mine pessimistic commit (RQ-2306)
  8. Rename CDC Audit to Event Streaming (RQ-914)
  9. Fix deletion of obsolete plogs (RQ-2559 #9091)
  10. Fix dbvrep --no-termcap crashes on Windows and Unix (HP-UX, AIX, Solaris) (RQ-2562)
  11. Properly enable trigger fire once if user has GoldenGate license (RQ-971)
  12. Fix runtime 'uninitialised value' perl warnings for $err and $errstr (RQ-2708)
  13. Restrict conflict handlers for COMMIT and DDL operations (RQ-2701)
  14. Setup wizard was losing HDFS namenode configuration enetered by user (RQ-2764 #9607)
  15. Prevent resets of CSV separators in setup wizard (RQ-2786)
  16. Fix possible invalid trim length for LOB operations (RQ-2758 #9555)
  17. Fix mine performance when global temporary tables are in place (RQ-2685 #9457)
  18. Fix mine memory leaks in direct insert with LOB columns (RQ-2780 #9604)
  19. Fix "undef" value for next SCN when RAC thread is down (RQ-2438)
  20. Fix undefined db handle that causes "Can't call method commit" (RQ-2753 #9568)
  21. Fix column numbers if supplemental logging is not enabled (RQ-2820)
  22. Fix incorrect handling of columns changed from suplog to old values (RQ-2624 RQ-2736 #9581)
  23. Fix memory leak due to DML on internal tables in DDL operations (RQ-2796 #9666)
  24. Disable retiring obsolete transactions by default (RQ-2804)
  25. Fix trailing NULLs for unique keys and APPLY_USE_PK_ONLY (RQ-2864)
  26. Correct SQL statement in conflict log when internal variable APPLY_USE_PK_ONLY is used (RQ-2863)
  27. Fix mine crash when multiple CTASes happen concurrently (RQ-2899)
  28. Allow IGNORE/IGNOREALL as conflict resolution for DDL(not commit) (RQ-2899)
  29. Fix handling of non-Unicode multi-byte character sets in CLOB (RQ-2920)
  30. Fix crash in LOAD when a leading column was excluded (RQ-2925)
  31. Fix memory leak with trailing NULLs and pessimistic commit (RQ-2935 #10040)

2.7.22 (21 September 2016)

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

  1. Fix case with multiple replications going to the same mysql database (RQ-2321 #8743)
  2. Improve quoting of passwords in all.sh (RQ-2259)
  3. Fix uninitialized value "$dbi" in Setup Wizard (RQ-2308)
  4. Handle case where Oracle reports LOB length in bytes instead of chars (RQ-2468)
  5. Fix missing columns in LOB operation (RQ-2371 RQ-2408 #8972)
  6. Prevent warnings about uninitialised $Avisit::Dbreplicate::MineEngine::rlog_plog_map (RQ-2428 RQ-2453 #8939 #8976)
  7. Regexp value stored incompletely if SQL handler's regexp contains OR expression (RQ-2485 #9074)
  8. Handle special cases of incomplete assembly (RQ-2383 #8851)
  9. Fix incorrect handling of rollback to savepoint on target on plog boundary on RAC (RQ-2500 #9023)
  10. Improve mine speed for large inserts on non-replicated tables (RQ-2436 #8981)
  11. Improve handling of corrupted internal dictionary (RQ-2611 #9283)
  12. Handle undo segments with CLS < 15 (RQ-2560 #9141)
  13. Fix handling of lost writes, force reopen (RQ-2305 #8762)
  14. Use much fewer DMLs to set conflict handlers (RQ-2238)
  15. Handle enabled row movement (RQ-2391 #8942 RQ-2734 #9568)
  16. Abort reading plog when plog entry header has wrong size (RQ-2573 #9155)
  17. Fix possible apply crash when handling an invalid SQL (RQ-2657 #9353)
  18. Include replicate DDC and process name in all SNMP messages (RQ-2507 #9065)
  19. Fix deletion of obsolete plogs (RQ-2559 #9091)
  20. Fix mine crash due to invalid parse of operation 6.1 (RQ-2751)
  21. Detect killed transactions (RQ-2629 #9237)
  22. Fix mine memory leaks in direct insert with LOB columns (RQ-2780 #9604)
  23. Fix "undef" value for next SCN when RAC thread is down (RQ-2438)
  24. Fix undefined db handle that causes "Can't call method commit" (RQ-2753 #9568)
  25. Graceful handling of unexpected operation in 24.* operations (RQ-2784 #9616)

 

2.8.00 (02 June 2016)

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

 

  1. Change severity of some errors and warnings (RQ-792, RQ-789, RQ-788)
  2. MINE_TRUNCATE_WITHOUT_DDL is now a public variable (RQ-982)
  3. Improve error message for incorrect user-specified SQL in filtering, PL/SQL and newer/older handlers (RQ-1058)
  4. NOTIFY SEND TEST command (RQ-1072)
  5. Rename CDC/Audit to just audit in setup wizard (RQ-914)
  6. Alternate archive destination (MINE_ARCH_DEST, MINE_ARCH_DEST_FORMAT) (RQ-929, RQ-1189)
  7. 12c invisible column support (RQ-848)
  8. Improve check/reject of invalid SET values (RQ-1031)
  9. Improve formatting of status line (SCN 0, year 1980) (RQ-777)
  10. Response file support in setup wizard (RQ-907)
  11. Support named time zones in TIMESTAMP WITH TIME ZONE (RQ-925)
  12. 12c extended datatype support (RQ-511)
  13. Empty filter condition could crash apply (RQ-1143)
  14. Added sequence grants for DDL replication to support 12c generated by identity columns (RQ-737)
  15. Show full SQL text in SQL conflict, do not truncate (RQ-1159)
  16. Plog statistics in plog conflict count was not set (RQ-1215)
  17. FILTER SHOW command (RQ-1268)
  18. Postpone last LCR will now default to YES (RQ-1283, RQ-1608)
  19. Fix CDC commit timestamp on non-Oracle targets (RQ-1253)
  20. Auto-resolve locks on target by looking ahead for rollbacks on source (RQ-1307)
  21. Minor grammar improvements in user messages (RQ-1536, RQ-1293)
  22. Better support non-ASCII table and column names (RQ-1227)
  23. Support for 9i cross-endian (RQ-1081)
  24. Added option to skip DML changes done by a username (RQ-744)
  25. Fix LOAD stats for one-to-many (RQ-354)
  26. Hide passwords in scripts in support package (RQ-1073)
  27. Fix the full path to temp dir used by wintee (RQ-1201)
  28. Help for NOTIFY command fixed (RQ-1646)
  29. Improved LOAD performance (RQ-630, RQ-1438)
  30. EXCLUDE COLUMN command is now online by default (RQ-1210)
  31. Allow LOAD_REQUEST to be added when mine is running (RQ-1439)
  32. PREPARE_AND_LOAD command (RQ-494)
  33. Allow CDC to be configured at schema-level (RQ-1669)
  34. Fix CSV output was not properly configured if schema level was selected (RQ-1559)
  35. APPLY_LOOP_PREVENTION and MINE_LOOP_PREVENTION are now public variables (RQ-1565)
  36. SHUTDOWN now asks for confirmation and supplies additional info; IMMEDIATE keyword added (RQ-1413, RQ-1509, RQ-1686)
  37. Properly mark updated PKs and deleted PKs as keys, not as old values (RQ-1707)
  38. Add option to delete staging directories on first start of mine/apply (RQ-1726)
  39. Add option to auto-prepare table that is dropped and then recreated (RQ-1824)
  40. Fixed data pump job naming on import when using dp_exp method for APPLY.sh (RQ-1831)
  41. Add option to supplementally log all columns (RQ-1706)
  42. Add select * from v$thread, v$log, v$logfile to the MINE support package (RQ-1761)
  43. Recursive DML in DDL (RQ-1435)
  44. Add option to add limit on MINE to pause if too much disk space is occupied (RQ-1730)
  45. Replace primary key on DBRSCOL$ by plain index (RQ-1983)
  46. Prevent apply loop on DML: set DML_IGNORE_USER (RQ-744)
  47. Engine send show did not show expected output (RQ-1386)
  48. Strings were not 'quoted' in list conflict (RQ-1999)
  49. Add character set and NLS settings to the support package (RQ-1368)
  50. Hide passwords in all/batch scripts in support package (RQ-1073)
  51. Fetcher profiler (RQ-1764)
  52. Handle inconsistency in setup wizard (RQ-2055)
  53. Mine would not start after node went down in RAC (RQ-1944)
  54. Dbvrep returns error code when the command was invalid (RQ-2081)
  55. Add option --no-tty to completely give up tty (RQ-2084)
  56. Fix privileges of files created by Replicate, esp. plogs (RQ-2092)
  57. Print error messages to STDERR (RQ-2090)
  58. Added new process type KAHITI for proper handling of OEM replications (RQ-2077)
  59. A new instantiation type scn_list for OEM replication (RQ-2128)
  60. Fixed typos in "PROCESS is running/PAUSED" messages (RQ-2204)
  61. Ask for MySQL admin password in all script when password saving was disabled in Setup Wizard (RQ-2217)
  62. Create Dbvisit Replicate repository in MySQL with password (RQ-2218)
  63. Ensure that all script has nonzero exit status on failure (RQ-2209)
  64. Command "set VARIABLE =" now reports error instead of setting VARIABLE to "=" (RQ-2214)
  65. Add public parameter APPLY_USE_PK_ONLY used in apply for using primary key columns only in where clause (RQ-2141)
  66. Setup Wizard would not run all.sh script when asked to do so (RQ-757)
  67. Check DBID before adding database-level supplemental logging (RQ-1879)
  68. On 9i FETCHER not picking any changes up until after the switch (RQ-2392)
  69. Improve handling of corrupted internal dictionary (RQ-2611 #9283)
  70. Handle undo segments with CLS < 15 (RQ-2560 #9141)
  71. Fix case with multiple replications going to the same mysql database (RQ-2321 #8743)
  72. Improve quoting of passwords in all.sh (RQ-2259)
  73. Handle case where Oracle reports LOB length in bytes instead of chars (RQ-2468)
  74. Fix missing columns in LOB operation (RQ-2371 RQ-2408 #8972)
  75. Prevent warnings about uninitialised $Avisit::Dbreplicate::MineEngine::rlog_plog_map (RQ-2428 RQ-2453 #8939 #8976)
  76. Handle special cases of incomplete assembly (RQ-2383 #8851)
  77. Fix incorrect handling of rollback to savepoint on target on plog boundary on RAC (RQ-2500 #9023)

2.7.20 (14 February 2016)

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

This is a maintenance release. The following items were fixed and/or added:

  1. Fix parsing of freelist redo on HPUX (RQ-2042 #8201)
  2. Fix conflict on heartbeat table in single-database replication (RQ-2059)
  3. Fix directory selection for support package file list_files_arcs.txt (RQ-2044)
  4. Speed up rollback on apply (RQ-2007)
  5. PREPARE in console could get incorrect start SCN after locking the table (RQ-2080)
  6. Make ALTER INDEX RENAME DLL work (RQ-2078)
  7. Fix crash in a particular case of rollback (RQ-2099 RQ-2196 #8373 #8330)
  8. Fix crash while parsing CFA redo change (RQ-2103)
  9. Fix missed DDL when it was split into multiple redo records and mixed with other DDL (RQ-2093)
  10. Fix invalid parse of DSC change (possibly crashing mine) (RQ-1796, #8413)
  11. Fix possible missing changes due to incomplete copy of archivelog (RQ-2119 #8244)
  12. Possible notify thread crash (RQ-2159 #8480)
  13. Add DBRSCOMMON_HEARTBEAT to support package (RQ-2164)
  14. Fix very consuming processing of archive logs by fetcher (RQ-1961)
  15. Fix possible crash in one-to-many configuration when sending notification (RQ-2120)
  16. Fix possible crash/hang when parsing array insert on index (RQ-2157)
  17. Fix looping of TRUNCATE command in 2-way replication (RQ-2174)
  18. Fix incorrect replication of LOBs in cascaded replication (RQ-2208)
  19. Fix mine lagging due to waiting for the whole arc to be delivered while fetcher is transfering the online version of the very same redo log (RQ-2195)
  20. Fix possible slowdown of mine (load table info) (RQ-2226 #7933)
  21. Redolog maintenance is run even when first redo log needed remains same (RQ-2231)
  22. LOAD would use too many sessions on source database (RQ-2253)
  23. Handle cases where there are multiple changes to the same LOB with no DML in between (RQ-2244 #8532 #8647)
  24. Add trailing NULLs to DELETEs (RQ-2252 #8647 #8656)
  25. Quote passwords in scripts (RQ-2259 RQ-2224)
  26. Fix mine LWN speed (RQ-2258)
  27. Fix handling of FLOAT on non-Oracle targets (RQ-1992 #8726)
  28. Backport of new LOAD code from 2.8, fixing many issues (RQ-2267 #8723)
  29. Fix possible missed rollback when there is >128 undo segments (RQ-2265 #8684)
  30. Add option to handle ambiguity with trailing NULLs (RQ-2269 #8699)
  31. Mine would not start after node went down in RAC (RQ-1944)
  32. Apply support package cannot be created when DDC file is used without MINE_PASSWORD (RQ-2349)
  33. Fix possible race condition in determining name of a rename table (RQ-2270 #8751)

2.7.18 (15 September 2015)

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

This is a maintenance release. The following items were fixed and/or added:

  1. Fix some cases of recursive DDL related to tables with FK (RQ-1953)
  2. Let DDL scripts honour column exclusion  (RQ-1938 RQ-1958)
  3. Fix possible lost of trace debug data (RQ-1946)
  4. Fix incorrect processing Ctrl-C on AIX during show all command (RQ-1809)
  5. Parse/ignore bitmap allocations in redo (RQ-1981)
  6. Fix apply trimming trailing spaces in strings over 2k (RQ-1975)
  7. Re-read redo block if the expected header is not there (#8086)
  8. Handle Oracle bug that causes invalid 9i-like redo header on 11g (#8086, RQ-1990)
  9. Ignore tables used by Compression Advisor since 11.2.0.4 (RQ-1993)
  10. Detect compressed data in non-direct load and skip them (RQ-1989, #8149)
  11. --no-termcap failed on Windows when entering passwords in wizard (RQ-1994)
  12. MSSQL watchdog: add XID of source transaction to watchdog info (RQ-1889)
  13. Fix keeping the history of Thread-redo-plog for RAC environment (RQ-1867)
  14. Some specific numbers (e.g. 10^25) were replicated as null (RQ-1996)

 

2.7.16 (11 August 2015)

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

This is a maintenance release. The following items were fixed and/or added:

  1. Ignore preparing SCHEDULER$_ tables (RQ-1828)
  2. Fix undef warning on conflict during LOAD (RQ-1807)
  3. Fix conflicts due to incorrect order of LOAD vs open transactions (RQ-1807)
  4. Fix missing grammar rules for prepare table with rename to MSSQL (RQ-1834)
  5. Improve speed of writing plog to disk (RQ-1833)
  6. Add 'alter table drop primary key' to supported DDLs (RQ-1869)
  7. Ignore DDL to add virtual columns issued by DBMS_STATS (#7868)
  8. Fix invalid column name when using empty prefix in CDC/Audit (RQ-1875 #7865)
  9. Reopen of redo on RAC would cause reset of LCR id (RQ-1867)
  10. Fix crash if session info in redo was in the middle of a transaction, not the beginning (#7832)
  11. Fix Mine 'pauses' when one of the 4 target machines is down (RQ-1847)
  12. Improve mine speed for large LWN blocks in redo (RQ-1871 #7842)
  13. GZIP on windows corrupts the plog file (RQ-1873)
  14. Fix invalid column used on 9i in IOT delete (#7856)
  15. Mine speed and profiling improvements (#7798)
  16. Fix possible conflict on plog boundary due to mine restart (RQ-1940)

 

2.7.14 (17 June 2015)

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

This is a maintenance release. The following items were fixed and/or added:

  1. DROP_SUPPLEMENTAL_LOG_DATA parameter added to keep supplog data when unpreparing the table (RQ-1537)
  2. Possible slowdown on CSV output due to often requery of column names (RQ-1560)
  3. Fix truncation of varchar data if it contained ASCII 0 (RQ-1562)
  4. Fix possible temporary conflict with parallel apply of timestamp with time zone (RQ-1638)
  5. Improve quoting of backslash in table name in APPLY.sh (RQ-1548)
  6. Improved feedback for exec/! command (RQ-1598)
  7. Fix auto-retry on mysql connection lost (RQ-1631)
  8. Handle possible ORA-00001 on session audit information (RQ-1662, #7468)
  9. Watchdog for SQL Server (RQ-627)
  10. Improve DDL created for tables replicated to mysql - TIMESTAMP columns (RQ-395)
  11. Fix PROCESS LOCK SCHEMAS for double quoted schema name (RQ-1281)
  12. Fix possible crash in watchdog (RQ-1736)
  13. Reduce apply memory usage for large uncommitted transactions (RQ-1673)
  14. Improved error reporting for failed SMTP connections and auto-retry for failed SQL statements for MySQL target (RQ-957)
  15. Improved error reporting for failed SMTP connections and auto-retry for failed SQL statements for MSSQL target (RQ-958)
  16. Auto-resolve locks on target by looking ahead for rollbacks on source (RQ-1307)
  17. Increase mine speed by updating row counts less frequently (RQ-1671)
  18. Select default process name even if user does not use the usual MINE/APPLY names (RQ-1720)
  19. Fix The conversion of the nvarchar value overflowed an int column error for MSSQL (RQ-1723)
  20. Fix Invalid precision value (SQL-HY104) (RQ-1437)
  21. Ignore ORA-10655: Segment can be shrunk error (caused by Segment Advisor DDL) (RQ-1741)
  22. Relax rules on HOSTNAME:PORT_NUM (RQ-1561)
  23. Getting the correct start PLOG from the start SCN when adding a new replication pair (RQ-1688)
  24. Remove harmless warnings caused by table shrink (RQ-1760)
  25. Fix 9i support on HP-UX (RQ-1810 #7720)
  26. Fix memory leak (RQ-1673)

 

2.7.12 (23 Mar 2015)

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

 

This is a maintenance release. The following items were fixed and/or added:

  1. Possible PK violation just after start after nolock (RQ-1316)
  2. Fix possible locks with loads with many partial rollbacks (RQ-881)
  3. Fix possible crash in support package (RQ-1432)
  4. Fix possible LOB incorrect truncation (#7234)
  5. Fix possible memory leak with LOBs (RQ-1505 #7261)
  6. Fix possible crash in apply commit transaction (#7044)
  7. Fix possible crash during rollforward after conflict (#7283)
  8. Exclude global temporary tables (RQ-1494)
  9. Fix auto-prepare of new tables in 2-way replication (RQ-1522)
  10. Add option to disable IPv6 support (RQ-1554)
  11. Getting the correct start PLOG from the start SCN (RQ-1538)
  12. Fix the FILTER syntax in manpage/help (RQ-1145)
  13. Improve speed for multiple 'rolled back on source' conflicts (RQ-1624)

 

2.7.10 (09 Jan 2015)

 

Note: If upgrading from 2.6.02 or previous version and running RAC, the following
grant should be executed by sysdba:
SQL> grant select on gv_$transaction to dbvrep;

 

This is a maintenance release. The following items were fixed and/or added:

  1. Apply performance improvements; more detailed profiling (RQ-1377, RQ-1364, RQ-1360)
  2. Apply minor memory leaks fixed, fixes in thread-level memory accounting (RQ-1336, RQ-1379)
  3. Reduce locking in plog transfer on apply (RQ-1275)
  4. Fix mine memory leak (RQ-1346, RQ-1214)
  5. Mine could run out of OS memory, not realizing it's over its own limit (RQ-1346)
  6. LOBs would not be trimmed in some cases of update (RQ-1237)
  7. Made watchdog message more clear; added option for watchdog to show SQL with actual values insted of binds: WATCHDOG_NOBIND_SQL (RQ-1336)

 

2.7.08 (12 Dec 2014)

This is a maintenance release.

  1. Fix Use of uninitialized values Notify Sequence SCN diff (RQ-1180)
  2. Fix in DDL for TIMESTAMP on SQL Server (RQ-1184)
  3. Fix possible conflict with restart during LOAD (RQ-1028)
  4. Possible missing column info in CTAS with LOBs (RQ-1188)
  5. Alternate archive destination (MINE_ARCH_DEST, MINE_ARCH_DEST_FORMAT) (backport of RQ-929, RQ-1189)
  6. Apply speed improvement: better skipping of rollbacks if all changes were already skipped (RQ-1192)
  7. Fix possible skip part of redo log on RAC (RQ-1150)
  8. Support named time zones in TIMESTAMP WITH TIME ZONE (backport of RQ-925)
  9. ALTER INDEX [IN]VISIBLE support (RQ-847)
  10. Fix "Use of uninitialized value in concatenation (.) or string at (eval21) line 408" in LIST PROGRESS (RQ-1190)
  11. Incorrect parse of array insert on big-endian (columns > 250 bytes) (RQ-1195, RQ-1196, RQ-1197, #6641, #6534)
  12. Allow table names using reserved keywords (RQ-1208)
  13. Formatting fixes in list conflict for non-Oracle (timestamps, dates) (RQ-395)
  14. Create table as select (and DDL commands) now include precision in timestamps (RQ-1228)
  15. Better error handling for SMTP authentication (RQ-1067)
  16. Fix number of sent emails in console output for NOTIFY SEND (RQ-1238)
  17. LOBs would not be trimmed in some cases of update (RQ-1237)
  18. For NOTIFY SEND commands user can choose the process to be used (RQ-1241)
  19. Change name of finished transactions to '(transaction ended)' (RQ-1264)
  20. NOTIFY_PEER_DOWN parameter is now used to decide what peers should the notification be send for (RQ-1212)
  21. Minor cleanup of error messages when mine cannot start (RQ-1266)
  22. Fix LIST PROGRESS output in scheduled Heartbeat and Daily_progress emails (RQ-1134)
  23. Fix possible crash setting conflict handlers for quoted table name (RQ-1262)
  24. Console could show dropped tables long after they were gone (RQ-1193)
  25. Fix: loop prevention did not affect DDL operations (RQ-1299)
  26. Fix memory leak on apply for non-OCI targets (RQ-1296)
  27. Fix possible mised rollback (RQ-1340)
  28. Fix possible locking with rollbacks and apply_postpone_last_lcr (RQ-881)
  29. Fix possible missing where clause in LOB ops (RQ-1343)
  30. Fix parsing of longer index keys (RQ-1224)

 

2.7.06 (4 Sep 2014)

This is a maintenance release.

 

  1. Fix setup wizard rename schema was case-sensitive even on Oracle (RQ-1140)
  2. Fix possible double-LOAD when plog transfer restarted (RQ-1144)
  3. Fix incorrect counters with NOLOCK - open transactions during all.sh (RQ-1122)
  4. Reduce number of parse calls (one or two per transaction) (RQ-1151)
  5. Fix formatting of conflict SQL (missing to_date) (RQ-395)
  6. Show full SQL text in SQL conflict, do not truncate (backport of RQ-1159)
  7. Possible wrong start SCN with NOLOCK on RAC (RQ-1028)
  8. Fix Use of uninitialized value $last_one_batch_cnt_full in LIST PROGRESS (RQ-1164)
  9. Fix Use of uninitialized value $mine_next_dtime in Notify Sequence SCN diff (RQ-1165)
  10. Small performance and profiling improvements (#6580)
  11. Empty filter condition could crash apply (RQ-1143)
  12. Apply progress includes rate per second (RQ-1157)

 

2.7.04 (18 Aug 2014)

 

The following items were fixed and/or added:

  1. Include ALTER TABLE DROP (col1, ...) in DDL replication (RQ-1085)
  2. Fix possible out-of-order mine on RAC (RQ-463)
  3. Fix pre-all.sh script compatibility with 9i (RQ-1106)
  4. Fix PREPARE_SCHEMA_EXCEPTIONS when multiple delimiters were entered (RQ-1109)
  5. Automatically exclude nested tables from replication (RQ-1108)
  6. Fix possible crash by conflict with Audit enabled table (RQ-976)
  7. Fix use of uninitialized value in numeric ge in NotifyLite (RQ-1097)
  8. Rollback could be ignored if the number of undo segments was very high (RQ-1095)
  9. Fix undef warning for some cases of network issues (RQ-1099)
  10. Fix repository upgrade bug for non-Oracle targets (RQ-1114, RQ-1115)
  11. Fix lookahead when rollback is in next plog (RQ-1111)
  12. Remove warning when insufficient privileges for a log switch (RQ-1118)
  13. Fix in getting SCN of open transaction in all.sh (RQ-1120)
  14. Increase how much into the future we look for upcoming rollback on conflict (RQ-1111)
  15. Improve apply loop prevention to handle more complicated scenarios (RQ-1123)
  16. Fix possible crash when unprepared a table that is in conflict (RQ-1130)
  17. Fix possible UTF-8 incorrect replication on MySQL (RQ-706)
  18. Fix PREPARE_SCHEMA_EXCEPTIONS with LOAD instantiation (RQ-1132)
  19. Fix possible missing rollback to savepoint on 12c with multi-tenant (RQ-1111, RQ-1120)
  20. Fix missing list progress in notification emails (RQ-1134)

 

2.7.02 (11 July 2014)

This is a maintenance release.

Note: If upgrading from a previous version and running RAC, the following grant should be executed by sysdba:

SQL> grant select on gv_$transaction to dbvrep;

 

The following items were fixed and/or added:

  1. LOAD with NOLOCK might skip load on apply (RQ-202)
  2. pre-all script checks if supplemental logging is already enabled (RQ-1071)
  3. Reconnect on ASM read errors (RQ-965)
  4. All existing variables added to the console HELP (RQ-623)
  5. Do not show indexes etc. in list progress (RQ-1076)

 

2.7.00 (26 June 2014)

  1. NEW - 12c multi-tenant support (RQ-505)
  2. NEW - Nolock data instantiation. Removes the need to lock source tables during instantiation (RQ-202)
  3. NEW - RAW, LONG RAW and LONG support for SQL Server and mysql (RQ-751)
  4. NEW - 12c metadata-only default values (RQ-508)
  5. NEW - DDL now includes "alter table enable/disable" (RQ-446)
  6. NEW - Check low disk space (RQ-829)
  7. License could miscalculate number of tables replicated (RQ-569)
  8. Fixed possible fake wait for more data in redo when not necessary (RQ-700)
  9. Unrecoverable (nologging) operation was not detected (RQ-524)
  10. Proper handling of UTF8/16 source data for mysql replication (RQ-706)
  11. DDL replication did not auto-exclude system/hidden columns (RQ-732)
  12. PROCESS command replaces ENGINE for common (and documened) tasks (RQ-687)
  13. PROCESS SETUP command can now manually enable/disable DDL replication (RQ-694)
  14. Allow for PREPARE SCHEMA to skip few tables (RQ-530)
  15. Show unsupported direct insert (e.g. compression) as "Unrecov" in list progress (RQ-393)
  16. REPREPARE (and UNPREPARE) adjust apply progress count to get 100% completion (RQ-251) 
  17. Possible crash during savepoint for non-Oracle (RQ-758)
  18. Hadoop output does not require non-threaded OCI (RQ-628)
  19. CSV (filesystem and Hadoop) now correctly populates commit timestamp (RQ-562)
  20. Fixed possible crash for CSV ouput (RQ-762)
  21. CSV (filesystem and Hadoop) now use UTF-8 output (RQ-763)
  22. Hadoop CSV now uses ISO 8601 format for dates, timestamps and intervals. Filesystem use similar one, but better parsable by Excel. (RQ-763)
  23. Proper character set conversion of source data for mysql and SQL Server (RQ-760)
  24. Fixes for mysql as database storage for CSV/Hadoop (RQ-774)
  25. Store data about files created (DBRSAPPLY_FILEOUTPUT_FILES) for CSV/Hadoop (RQ-562)
  26. Fixes for columns spanning multiple blocks (RQ-432)
  27. Ignore recursive DDL (RQ-446)
  28. Fix conflict lock on alter table add column (RQ-731)
  29. CTAS could cause harmless "Decrementing SCN" warning in apply logfile (RQ-443)
  30. Do not include old trace files in support package (RQ-625)
  31. Limit history in csv files included in support package (RQ-816)
  32. Set internal parameters accordingly in case of async I/O on source (RQ-325)
  33. Improve setup wizard questions for Oracle AWS RDS (RQ-858)
  34. Add option to exclude statistics in export/import (DPUMP_EXCLUDE_STATS) (RQ-861)
  35. Do not increase conflict count if conflict ignored as ROLLED BACK ON SOURCE (RQ-875)
  36. Fix default in setup wizard on rerun with dp_networklink changed to load (RQ-639)
  37. Added more information to DBRSAPPLY_CONFLICT_LOG (RQ-877)
  38. Automatically exclude DBMS_TABCOMP_TEMP_(UN)CMP (RQ-885)
  39. Improved diagnostics for failed connection (RQ-898)
  40. Setup wizard could offer options not convered by selected license (RQ-910)
  41. Possible apply crash/memory corruption (RQ-913)
  42. Mysql possible issues due to transaction isolation (RQ-775, RQ-779, RQ-942)
  43. Add timestamp and function name to trace file (RQ-889)
  44. APPLY_POSTPONE_LAST_LCR is now a documented parameter (RQ-945)
  45. Change question order in SQL Server settings (RQ-949)
  46. Support package adds output of the LIST commands (RQ-551)
  47. CDC commands needed restart of console to take effect (RQ-927)
  48. Column headers added to support package CSVs (RQ-768)
  49. Handle nicely ROLLED BACK ON SOURCE on non-Oracle target, too (RQ-875)
  50. LOAD could load some data twice if restarted on RAC (RQ-1010)
  51. pre-all.sh did not enable db-level minimal logging (RQ-1014)
  52. no-lock would lock tables unnecessarily (RQ-202)
  53. LOAD now supports quote-necessary tables, too (RQ-1015)
  54. Handle COMPATIBLE setting of 12.0 (instead of usual 12.1) (RQ-505)
  55. Setup wizard - fix errors in some cases of editing existing configuration (RQ-1026)
  56. Direct insert was ignored if data object id was different from object id (RQ-1027)
  57. Typos in log messages corrected (RQ-1030) 

 

2.6.06 (11 June 2014)

This is a maintenance release. The following items were fixed and/or added:

  1. Log output of running *-all script on Windows (RQ-409)
  2. Fix deleting of orphaned obsolete online redo log files from mine_stage (RQ-908)
  3. Fix possible notification for 'table 0' (RQ-954)
  4. Do not connect to apply for auto-unprepare (#6224)
  5. Fix possible crash due to wrong order of SCN (#6022)
  6. Fix possible ignore of change after rollback to savepoint on RAC (#6240)
  7. Fix possible infinite loop (mine hang) on RAC (#6022)
  8. Fix LOB repeats where columns with row change broken into multiple row-pieces (#6240, RQ-967)
  9. Better handling of unsupported datatypes in LOAD instantiation (#6289, RQ-978)
  10. _ENABLE_5_19_PARSE now skips loading of all audit information, too (RQ-361, #6299)
  11. Fix crash of APPLY COMMIT/ROLLBACK TRANSACTION (#6240)
  12. Do not increase conflict count if conflict ignored as ROLLED BACK ON SOURCE (backport of RQ-875)
  13. NEWER/OLDER handlers are valid for UPDATE conflict only (RQ-983)

2.6.04 (12 May 2014)

This is a maintenance release. The following items were fixed and/or added:

  1. Fix "ORA-01466: unable to read data - table definition has changed" (RQ-678)
  2. Possible crash for stuck apply threads with rollbacks involved (RQ-821)
  3. Quote column names in apply SQL (RQ-864)
  4. Improve handling of RAC cross-thread rollbacks (RQ-863)
  5. Allow double-quoted table names (RQ-865)
  6. Update obsolete plog even if no transactions are active (RQ-890)
  7. Fix grants not being replicated, added parameter DDL_REPLICATE_GRANTS (RQ-544)
  8. Improved diagnostics for failed connection (RQ-898)
  9. Fix errors in updating licensing measures (#6095)
  10. Fixes in deleting obsolete redo logs (RQ-904)
  11. Possible out-of-order mine just after log switch (RQ-821)
  12. Possible apply crash/memory corruption (RQ-913)
  13. Incorrect position of rollback to savepoint on RAC (RQ-921)
  14. Limit the number of repeated notifications (RQ-576)
  15. Possible crash due to use of OCI with non-Oracle target (#6221)
  16. Possible crash due to use of OCI with non-Oracle target (#6221)
  17. Query gv$transaction on RAC (RQ-956)

 

2.6.02 (21 March 2014)
This is a maintenance release. The following items were fixed and/or added:

  1. _EXIT_CONDITION renamed to REDO_READ_METHOD (RQ-688)
  2. Fixed possible crash with CSV output (RQ-670)
  3. Profiler automatically disables threaded OCI to generate proper results (RQ-650)
  4. FAST_NOLOG/NOLOG conflict handling would crash apply (RQ-621)
  5. Fix replication of NULL BFILE (#5433, RQ-703)
  6. Fixed possible fake wait for more data in redo when not necessary (RQ-700)
  7. Possible crash while parsing LOB information (RQ-756)
  8. Fixed possible crash for conflict on commit (#5790)
  9. Unrecoverable (nologging) operation was not detected (RQ-524 backport)
  10. Fixed possible warning in LIST PROGRESS (RQ-778)
  11. Set transaction isolation level to READ COMMITED for MySQL (RQ-775,RQ-779)
  12. Minor fixes to remove warnings for unnecessary redo data (#5828)
  13. Support package should not connect to other database to check connections, e.g. target database may be unreachable from source (#5828 RQ-785)
  14. Possible crash with NULL BFILE (RQ-738)
  15. Plog maintenance speed improvement (RQ-749)
  16. Fix PREPARE checking whether table exists on target using invalid SQL for SQL Server (RQ-801)
  17. Loggging of errors to database - reconnect on failure to log (RQ-806)
  18. Fix possible wrong where condition in LOB operation (RQ-815)
  19. Possible crash during savepoint for non-Oracle (backport RQ-758)
  20. Fix possible crash when object column was not excluded (#5894)
  21. Fixed some cases of wrong order of changes on RAC (#5882)
  22. Simple check for redo lost writes (#5886)
  23. Fix handling of redo >2GB (#5905)
  24. Fix apply memory usage with trailing NULL cols (RQ-828)
  25. Removed superfluos wait when reading lots of irrelevant changes (RQ-832)
  26. Added workarounds for ASYNC/DIRECT I/O (#5919)
  27. Fix cases of duplicate columns in where clause (old and suplog) (#5935)
  28. ORA-24344: success with compilation error in all.bat (RQ-807, #5755)
  29. Fix for "wrong order" of changes due to I/O limits (#5887)
  30. Reduce frequency of updates on DBRSMINE_RLOG_PLOG_MAP (#5951, #5944)
  31. Success with compilation error in all.bat (RQ-807)
  32. Incorrect hostname:port in setup wizard could crash it (RQ-817)
  33. Sort output of SHOW by variable name, then process (RQ-643)
  34. Fix possible BLOB corruption (RQ-836)
  35. "none" instantiation still created dpump script (RQ-753)
  36. Fix showing internal default value MSSQL instead of SQL Server (RQ-780, #5960, #5967)
  37. Incorrect order of rollback in plog can cause apply stuck and/or crash (RQ-852)

 

2.6.00 (8 January 2014)

  1. Enable more detailed profiling on demand
  2. Fix possible DDL repeat upon apply restart (but conflicting DDL will not be repeated on restart)
  3. NOTIFY SET/SHOW to suspend notifications
  4. Limited support for CSV/Hadoop target, including HDFS
  5. Allow @ to load tables/schemas in Step 3 of setup wizard from file
  6. Support for Oracle AWS RDS
  7. HP-UX mail fixes
  8. Minor questions removed from setup wizard
  9. Fixed possible crash of apply under memory pressure
  10. Improve last obsolete redo calculation speed
  11. Fixes in direct insert for row chaining
  12. Automatic heartbeat table DBRSCOMMON_HEARTBEAT
  13. Fix checking supported table name for lowercase chars
  14. Fix all.sh script for MSSQL dbvrep database drop/create
  15. Load does a log switch, so the LOAD files get obsolete sooner
  16. Removed debug messages for spill to disk from logfile
  17. Load sometimes not done again after mine restart
  18. Remove spurious warnings about "No current conflict" from the log
  19. Incorrect prepare of CREATE TABLE (index added, too) on big-endian possible
  20. Possible conflict on RAC after restart (incorrect ordering of log switches)

 

2.5.18 (20 December 2013)

  1. Fix possible apply crash with conflict and then a rollback to savepoint
  2. Fix mine not-resending partially-send plogs
  3. Better memory management on apply, also for large rollbacks
  4. Fix possible crash on apply lookahead
  5. Fix for obsolete plogs not being deleted on mine
  6. _ENABLE_5_19_PARSE now skips loading of all audit information, too
  7. STATUS_SHOW_PAST_CONFLICTS default changed to NO

 

2.5.16 (21 November 2013)

  1. Improve plog transfer in case of high number of plogs
  2. Fix possible crash on 9i (mine)
  3. Fix possible crash under memory pressure (apply)
  4. Fix row chaining for SUPLOG columns

 

2.5.14 (18 November 2013)

  1. Improve error reporting in network code
  2. Add option to always keep last LCR in queue to prevent locking
  3. Fix retry on checksum error, for mine and for fetcher
  4. Improve performance on log switch
  5. Fix notifications (scn/seq/time difference)
  6. Fix race condifition in file delivery
  7. Fix handling of slow v$archived_log query
  8. APPLY REGISTER PLOG
  9. added timestamp to LIST OBSOLETE REDO and the mine log

 

2.5.12 (2 November 2013)

  1. Limit number of retries in conflict (then revert to PAUSE)
  2. Handle better network timeouts under load - cancel incoming requests, don't let the queue grow
  3. Fix backup ddc file handling of __ variables
  4. Log pause/resume to log file
  5. Fix parsing of non-logging information on 9i
  6. Fix possible error in LOB handling (crash after conflict)
  7. Keep plogs/downstream redo logs longer on disk (limited by age and size)
  8. Make redo/plog transfer more reliable when receiver is busy processing changes
  9. Retire obsolete transactions: PLOG SCN set to mine_next_scn instead of the oldesct SCN
  10. Fix: LIST PREPARE when filtering the output (Use of uninitialized value in concatenation)
  11. Fix: separation of select and update in the LOB handling
  12. Fix: fetcher with RAC could skip some changes near log end
  13. Fix: possible wrong column name assigned to a column in a LOB operation
  14. Improvement in speed of log switch (deletion of obsolete plogs)
  15. Fix LIST APPLY PLOGS for MSSQL and MySQL
  16. Fix LIST MINE REDOLOGS for the NULL NextSCN
  17. Added ENGINE CLEAR PREVIOUS WARNINGS command and added to the *-setup.dbvrep script
  18. Network improvements when large amount of plogs were created since replication started
  19. Add possibility to disable automatic unstuck tries
  20. Remove Failed to open lofile message from support package

 

2.5.10 (17 October 2013)

  1. Fix: Testsuite 13 is waiting for the dbvrep user to disconnect
  2. Added ORA-22922 check to the testsuite 13
  3. Added _INIT_DICTIONARY_LOAD_AS_OF_SCN parameter
  4. Logging output of *-all.sh script, log added to the support package not for Windows)
  5. Fix: truncate spaces at end of SETUP_SCRIPT_PATH
  6. Fix: Setup Wizard-step 4: MINE cannot be changed once it was checked as "Not used, work done by MINE1."
  7. Setup wizard Step 4 - changes in reusing already configured MINE processes
  8. Fix: check memory limit a bit late, after apply queue was processed
  9. Fix terminal issue on HP-UX with --no-termcap
  10. Handle unknown DDL types in notification emails
  11. Fix SQL shown in conflicts
  12. Fix possible ODBC cast mismatch
  13. Allow errors to be ignored by Oracle code (APPLY_IGNORE_ERROR_CODES)
  14. Add option to use direct I/O (Linux only)
  15. RAC improvements for idle thread(s)
  16. Fix LIST CONFLICT for SQL Server
  17. Removed bogus warning message on log reopen
  18. Fixed possible crash on log reopen
  19. Fix edition setting in the Setup Wizard
  20. Fix: list stats all shows number of commits for both commits and rollbacks
  21. Fix in IOT handling on big-endian machines
  22. Fix: reading n+1 bytes when checking for data dictionary column changes
  23. Fixed various conditions for RAC restart
  24. Changed quoting to [] in SQL Server
  25. Fix missing data in create table as select (big-endian)
  26. SQL Server use datetime2 in conversion to dates
  27. Improve wording in healthcheck emails
  28. Fix FETCHER.MINE_PEER for one-to-many
  29. Improve support for RAC with disabled threads
  30. Notify if process seems to be hung/locked
  31. Datapump import would not be replicated under some circumstances
  32. Limit the amount of internal data replicated during initialization
  33. Fix SCN in list conflict

 

2.5.08 (16 September 2013)

  1. Fix: unused/hidden commands not excluded for some cases of PREPARE command
  2. Ordering in Suppack's CSVs
  3. Fix prepare table issue when upgrading from previous version

 

2.5.06 (13 September 2013)

 

  1. Fix: case sensitivity when setting RDBMS type in the Setup Wizard
  2. Fix: unknown error string when creating support package
  3. Fix: Use of uninitialized value $DBI::errstr in pattern match (m//)
  4. Fix: Added check on APPLY_RDBMS=MySQL for the set_transaction_name method
  5. V$ARCHIVED_LOG added to the support package
  6. When reloading apply LCRs from disk, do more frequent free of stuff no-longer needed
  7. Let fetcher honor _EXIT_CONDITION, too
  8. Default value for _MINE_FORCE_SCN_UPDATE_IDLE_COUNT changed to 0
  9. Support package fetcher includes redo logs
  10. Change to default path on Windows to c:\Users\%user%\Documents
  11. Handle missing checksums in redo logs
  12. Ignoreall: do not look ahead for upcomming rollback (improves speed for large number of ignored conflicts)
  13. Handle case when non-LONG column needs to concated from two row pieces
  14. Better handle failures when rotating old redologs (sent by fetcher)
  15. Fix error for ROLLBACK in SQL Server
  16. Do not truncate SQL in conflict log table
  17. Fix mine hang due to file locking (Windows)
  18. Fix: subsequent FILTER commands could be ignored until restart
  19. Make LIST STATUS work from command line/script
  20. Fix failing support package (mysql)
  21. Make apply respond to commands even if session is locked
  22. Mine LOAD performance improvements
  23. Fix LOB locator issue with ROLLBACK
  24. PROGRAM_VERSION in DBRSCOMMON_VERSION value fixed
  25. cfg files, onetime ddc file, grant scripts and dbsetup scripts moved to the config directory
  26. Handle unusued, hidden or internal Oracle columns (excldue from replication)
  27. Fix possible crash in applier threads during creating savepoint
  28. Do
  29. wngrade checks for version too new

2.5.04 (24 August 2013)

  1. LIST PREPARE shows whether table/schema is prepared with DDL and PLSQL
  2. Detect DataPump directory, check for CDB-specific only
  3. Detect corrupted plog/redolog transfer
  4. Fix evaluation expiry days in license bar
  5. Fix license expiration check
  6. Fix: apply starts processing LOAD sooner, sooner skips already processed load plog; fix crash on 10 million load
  7. LOAD option for initial load
  8. Honour EXCLUDE COLUMN for DDL CREATE_WITH_DICT, use this in wizard
  9. Minor fix in the console feedback for filter setting
  10. Check plog size on retransfer

 

2.5.02 (19 August 2013)

  1. New Replicate editions (LTD/XTD/MAX)
  2. Optionally send emails on DDL
  3. Fixes in rollback in apply
  4. Servernames added to the Win step 4 in Nexsteps.txt (creating services)
  5. Fix: datapump import scripts honor renames
  6. 9i mine did not detect proper operation for ORP
  7. Warning message (undef variable) with idle threads: fixed
  8. Fix quouting around sqlplus login
  9. Do not update last obsolete sequence too often if the query is too slow
  10. Fix crashing LIST TRANSACTIONS on Windows
  11. 12c support (no new features)
  12. Mine speed improvements
  13. Race condition in log read - retry
  14. Skip SYS dictionary updates when nothing actually happens
  15. Fix cases when CTAS was not detected due to newlines in DDL text
  16. Fix: one-to-many secondary apply fails due to plog check (UUID)
  17. Let mine send to apply retry the failed plogs faster
  18. Fix: mysql could issue SET TRANSACTION
  19. Fix: do not delete old plogs if no apply was ever started
  20. Fix: crash with apply rollback transaction
  21. Honor --no-termcap on Windows
  22. Retry failed internal SQL for DML operations
  23. Add NLS_LANG option KEEP_UNDEF

 

2.4.34 (17 August 2013)

  1. Fixes in rollback in apply
  2. Fix: datapump import scripts honor renames
  3. Warning message (undef variable) with idle threads: fixed
  4. Fix quouting around sqlplus login
  5. Do not update last obsolete sequence too often if the query is too slow
  6. Fix crashing LIST TRANSACTIONS on Windows
  7. Mine speed improvements
  8. Race condition in log read - retry
  9. Skip SYS dictionary updates when nothing actually happens
  10. Fix cases when CTAS was not detected due to newlines in DDL text
  11. Fix: one-to-many secondary apply fails due to plog check (UUID)
  12. Let mine send to apply retry the failed plogs faster
  13. Fix: mysql could issue SET TRANSACTION
  14. Fix: do not delete old plogs if no apply was ever started
  15. Fix: crash with apply rollback transaction
  16. Honor --no-termcap on Windows
  17. Retry failed internal SQL for DML operations
  18. Add NLS_LANG option KEEP_UNDEF

 

2.4.32 (01 Aug 2013)

  1. AIX fixes
  2. Fixed warning message in log for plog sequence on redo restart
  3. Fix: Finding PLOG when instantiate_scn < first plog's SCN
  4. Fix: reread on redo checksum error
  5. Fix: handle unformatted redo blocks
  6. Fix: 9i suplog fixes
  7. EULA update
  8. Changed default for DISPLAY_TABLE_NAME_IN_LIST_PROGRESS to BOTH
  9. Fix: after obsoleting some LCRs/LOBs, we'd end up in infinite loop on next log switch
  10. Added version information to the support package
  11. Change the never-used defaults for network interfaces
  12. Apply memory usage improvements
  13. Fix: direct insert (19.1) cross-endian fixes
  14. Improve profiling for remote commands sent to apply
  15. Fix: auto-retry get_log_status (FATAL-1154)
  16. Mine: ignore multi block undo
  17. Fixed crash in setup wizard when unable to connect to database
  18. Minor changes to man page and help command
  19. Improved error reporting for failed SMTP connections
  20. Auto-retry for failed SQL statements
  21. AIX stack trace to tracefile
  22. Fix: Process_logger_queue does not log all the feedback
  23. Fix: wait SCN flip for 9i
  24. Fix: crash after unprepare of a table while in conflict
  25. Add old NULL values to update/delete statements (prevent conflict on tables without PK)
  26. Fix rollback limit if last matched was id = 0
  27. Fix apply crash: missing savepoint after conflict resolved as ok/rolled back on source
  28. REPREPARE command
  29. Mine can print open transaction detail to log on log switch
  30. Fix: old NULL values as pre-values even when not actually present
  31. Do not store sys/system passwords if requested by the user in the setup wizard
  32. Purge very old data in dbrsmine_rlog_plog_map, dbrsmine_plog_history, and dbrsapply_plog_history
  33. Fixed row assembly for direct insert
  34. Apply prints messages for rollback into the log
  35. Fix direct insert itl count (mine SIGSEGV crash)
  36. Let lookahead start at conflict LCR, not the last LCR loaded (fixes issue with mutliple rollbacks in same transaction)
  37. Fix: ENGINE LOCK does not lock tables because of end-of-line character in the SCHEMA name in the command file
  38. Fix: Locking the table with unsupported table name was not handled correctly
  39. Trimming spaces off the ddc name in the Setup Wizard
  40. chmod start_console.sh in during the setup wizard
  41. Fix: remove mine_stage redolog after retransfer that changes the filename
  42. Fix possible crash after apply plog transfer restart
  43. Replicate TRUNCATE even if DDL is not selected
  44. Less agressive memory cleanup under memory pressure
  45. Fix: feedback buffer not printed when try_connect fails
  46. Fix: possible crash with large trace messages in apply threads
  47. Fix: use LCR plog id, not current plog id when creating savepoints - fixes conflicts due to incorrect rollbacks
  48. Lookahead: span redologs
  49. Lookahead: fix case when it would ignore rollback just next to the conflict LCR
  50. Do not add IS NULL to where condition if the colmuns is LOB or LONG
  51. Mark skipped LCRs, so they won't be tried again during rollforward
  52. Fix warning (process not chosen) in one-to-many configurations
  53. Add RBA to watchdog messages
  54. Make apply session lock detection RAC-aware
  55. APPLY ROLLBACK TRANSACTION
  56. License bar added.
  57. Make APPLY ROLLBACK TRANSACTION work to transaction that has yet to come.
  58. Minor fixes for the command HEALTHCHECK FOR
  59. Revamp rollback in mine to make it simpler and more reliable
  60. DDL CREATE: properly set INTERVAL precisions
  61. Fix crash when we try to recconect to database after ORA error
  62. Do not abend if upcomming archive log is missing; instead send email and wait for the file to be restored
  63. Fix detection of mine init complete - check exactly this run of all.sh
  64. Completely ignore SIGPIPE (remove the console message)
  65. Variable _APPLY_MYSQL_WAIT_TIMEOUT added, session variable wait_timeout is set accordingly when connecting to target MySQL
  66. Do not include ROLLED BACK ON SOURCE in conflicts (change default behaviour)
  67. Server names added to the Nextsteps.txt
  68. Don't print WARN-4504 if the issue is Broken pipe

 

2.4.30 (31 May 2013)

  1. Fix memory leak on mine (non-replicated table data)
  2. Fix: HELP record for the DUMP command
  3. Handle limit of 33 columns in supplemental log group (9i), do not try to enable the supplemental logging if already done (prevents DDL lock)
  4. Honor kill -12 even while in C OCI call
  5. MSSQL renamed to SQL Server
  6. Show a more friendly database description in setup wizard (mysql/SQL Server)
  7. DISPLAY_TABLE_NAME_IN_LIST_PROGRESS to govern what table name to show when rename is used

 

2.4.28 (17 May 2013)

  1. Fix: removal of obsolete redologs could delete actual archivelogs or online logs, even those not sent by fetcher

 

2.4.26 (17 May 2013)

  1. Fix LIST STATS for mysql target
  2. OFF for notification time would evaluate as midnight
  3. No support package for simple db connectivity errors
  4. Small fixes in the test emials sent by NOTIFY SENDQ
  5. Changed logo in notification emails
  6. Fix: obsolete redologs were not deleted by mine (fetcher in use)
  7. Fix: improve mine speed in case of large history of DDL changes
  8. Support TRUNCATE for mysql and MS SQL

 

2.4.24 (9 May 2013)

  1. Fix crash due to incorrect parse of index operation (kdxbur
  2. Fix numbering of columns in supplemntal logging for LOB operations
  3. Improve speed for non-replicated partitioned tables
  4. SHOW now displays a message when no such variable exists
  5. Add current threshold to notification emails for time differenc
  6. Fix: added SNMP trap for time difference
  7. Improve error messaging when the operation fails (change text for OK-0)
  8. Fix some cases when crash would create two support packages instead of one
  9. Fix: auditing information could contain excess binary characters
  10. Remove [] non-described tables from list progress, use list progress (not all) in daily progress
  11. Fix: PL/SQL would see only first column of primary key
  12. Fix: IOT: distinguish between key and other columns
  13. Fix: advance SCN even when some of RAC threads are idle
  14. Fix: crash during ENGINE LOCK run from console
  15. Fix: check RBA limits properly on restart (even pre-start SCN)
  16. Fix: log packaging sometimes failed with fetcher configuration
  17. Fix: WAN/LAN setting in the setup wizard was ignored
  18. Fix: allow OFF for time values
  19. Fix: memory usage for big-endian (signature merging)

 

2.4.22 (8 April 2013)

  1. Fix LIST STATS on MSSQL
  2. CLEAR APPLY COUNTERS now sets conflicts counts for all tables to zero, as expected
  3. Fix of notification thread crash due to invalid dates
  4. Ignore DROP INDEX BIN$..$ (purge recyclebin)
  5. Fix support package apply on MSSQL
  6. Increase max number of threads for RAC to 16
  7. Fixes for logging of errors to COMMON_ERRORLOG
  8. Fix check for prepare schema on MSSQL
 
 

Worldwide

Businesses in over 110 countries worldwide with Oracle® Database Standard Edition trust Dbvisit to protect and share their data.

READ MORE >

Our Partners

Join a growing community of Oracle experts using Dbvisit software as the key to unlocking untapped revenue from customers and prospects.

READ MORE >

Key Benefits

Dbvisit provides Oracle® Database Standard Edition users with affordable disaster recovery and data replication solutions.

READ MORE >

Our Services that make your work easier and your data safer

Protect

Our maintenance and support commitment to you

READ MORE >

 

Connect

Our integrated learning channel for you

READ MORE >