Replicate Latest Changes

Dbvisit Replicate Latest Changes Listing

2.3.14 (14 May 2012)

1. Fixed fetcher issue when current redo was overwritten, now correctly falls back to archived copy
2. DDL scripts and CTAS did not handle correctly RAW columns
3. CTAS could cause incorrect PLOG CRC checksum
4. Improve mine speed (limit flushing to disk, do not write progress so often to log)
5. Support for HP-UX
6. Support for 4k redo block size (Avanced Disk Format)
7. Fallback console when termcap does not work, LIST STATUS command
8. Speed-up prepare schema/table if single-scn is used
9. Fix in row-migration handling

 

2.3.12 (2 May 2012)

1. Fixes in fetcher (could stop in some scenarios)
2. Fixed crash when audit data was not present in the source (e.g. DDL)
3. Fixed crash when mine re-read CTAS for table that has been unprepared
4. Table was still present in list progress/notify emails even when unprepared
5. Removed incorrect warning about SCN mismatch on big-endian platforms
6. Fixed error for overwrite/newer/older conflict handlers
7. Changed how much of a long error message is printed on crash

 

2.3.10 (1 May 2012)

1. Setup wizard now defaults to use INADR_ANY (0.0.0.0) for listen interfaces, thus making dbvrep processes listen on all network interfaces
2. Added directory for dp import
3. Check tables on apply only if no import scripts are created (e.g. for resetlogs instantiation)
4. Default conflict handlers
5. Streamline setup wizard questions for tables and schemas
6. Backup re-downloaded plogs (and redologs from fetcher). Can be useful for support.
7. Create table as select support (without LOB columns)
8. Fix various small bugs with table/schema rename in setup wizard and ddl-create
9. Fix various small bugs in set_conflict_handlers command
10. DBRSAPPLY_PKG now has audit information variables (this version thus requires repository uprade)

 

2.3.08 (16 April 2012)

1. If exp or expdp (using file) is used to load the data, the script now contains the import, too
2. Fix: disappearing list progress in console
3. DDL scripts (created by *-all script) now include primary keys (if CDC is not used)
4. Fixed default path names in setup wizard if target was on different platform (Windows x Un*x)
5. Disable hostname detection if multiple hostnames are found (on RAC, we could autodetect wrong node)
6. Fix for 2-way (and other shared-database) replication setup.dbvrep script
7. Support can enable special dynamic library handling
8. Bundle the mysql libraries
9. Fixed memory leak introduced in 2.3.04
10. LIST CONFLICT command
11. DDL commands get a proper id (shown and used with conflicts)
12. Fixed truncate of long commands at 2kB
13. Do not generate support package for "Could not open port" error (usually shown when dbvrep was already running)
14. Fixes in online PREPARE
15. Fixes in parsing new user being created
16. PREPARE could fail if executed as first command just after console started
17. Let SHOW_CONFLICT_HANDLERS handle properly tables that are prepared on mine only

 

2.3.06 - (10 April 2012)

1. RAC - fixed bugs in RAC degraded mode (when some of the node(s) are down)
2. Setup wizard checks whether the specified tables/schemas exist
3. Variable APPLY_COLUMN_NAMES_MAP can be used to rename columns globally

 

2.3.04 - (31 March 2012)

1. Fix handling of NULL LOBs
2. Self-locked apply session: we try to go on with other sessions (fixes crashes due to UK/FK/PK locking on index duplicates)
3. Self-fixing conflict with incorrect date format
4. RAC - fixed bugs in thread merging (caused mine not to detect log switch)
5. RAC - fixed bugs in log switching (could skip some LCRs near the redolog end)
6. RAC - fixed bugs in thread merging (idle thread could skip some LCRs when becomes non-idle; strand flushes could cause incorrect order of SCNs)
7. RAC - fixed bugs in mine restart (stats and plog)

 

2.3.02 (16 March 2012)

1. One-to-many and two-way support
2. Filtering/subsetting support
3. CDC/Audit
4. PL/SQL replication
5. Apply threaded to improve performance (Oracle OCI only)
6. Prepare as of SCN
7. Support for AL32UTF16/UTF8 NCHAR/NVARCHAR2
8. Initial data copy now supports DDL including additional CDC/Audit columns if applicable
9. FLOAT datatype support
10. RESOLVE as IGNOREALL
11. PAUSE is now default handling for non-specified cases, e.g. error on COMMIT, DDL etc.
12. SMTP TLS support for email sending
13. Autodetect NLS_LANG in setup wizard and let apply honour it
14. LIST OBSOLETE REDO command
15. Try to skip applying changes that are going to be rolled back
16. Support package tries to use asmcmd copy
17. /tmp/par-*/cache/inc/BUILD_VERSION identifies version that uses this particular cache directory
18. Memory usage considerably lowered
19. Improved support package contents on Windows
20. Code cleanup
21. Cluster key move fix
22. Setup wizard defaults hostname to database hostname from v$database
23. Apply OCI statement cache improved
24. Show PL/SQL DDL commands replicated
25. Fixed notification peer down
26. Notification emails now include the image inline
27. Setup wizard supports two-way and one-to-many replication
28. Windows: list progress did not show last apply date
29. On Oracle targets (OCI) sets module/action to show which transaction is being applied (and start SCN)
30. Single-scn instantiation is now default in setup wizard
31. LONG and LONG RAW datatype support

 

2.2.18 - (16 March 2012)

1. Fixed race condition in mine that could cause incorrect column/datatype in apply SQL
2. DDL CREATE TABLE as SELECT should not be replicated  (some syntax sugar cause mine to not detect it is actually a CTAS)
3. Fixed that sometimes plog did not became obsolete and stayed thus on the filesystem (and were reread on apply startup)
4. Fixed empty LOB handling (caused ORA-24801: illegal parameter value in OCI lob function)
5. Fixed 9i query to get current incarnation
6. Redo log parsing 9i fixes

 

2.2.16 - (6 March 2012)

1. 2.2.14 did not print correctly error message on exit and generated support package even from console errors
2. Handle case when init happened on end of redo log
3. Fix of LWN reorder (private redo strands)
4. Add support package on apply conflict via hidden parameter
5. Fix of notification (complained about "OK" table not being replicated)
6. Fix of set_conflict_handlers (would cause apply to abort when used from console)
7. NLS_LANG can be set in ddc file
8. Fix: last LCR in redo log was sometimes ignored
9. Fix: varchar column was occasionally treated as number
10. Handle resetlogs (ignore logs from past incarnations)
11. Fix: last few LCRs in plog were attributed to next plog
12. Fix: occassional two-task error in propagate thread
13. Prevent apply loop on DDL: set DDL_IGNORE_USER
14. Rollback could be attributed to wrong transaction, resulting in conflict

 

2.2.14 - (10 February 2012)

1. Automatic invoke of support package on fatal crash
2. Fix of 11gR2 row chaining bug

 

2.2.12 - (4 February 2012)

1. Fix of missed changes on 11.2 (multiple in-flight row pieces)
2. Enable supplemental logging would fail with syntax error if no tables were found
3. Caching fix, fixing ORA-1036 and 0 rows affected transient errors on apply
4. Fix of start SCN handling on apply that could cause skipped changes in conflicting transactions after apply restart
5. Prepare schema raised syntax error when invoked on empty schema
6. Fix of Oracle missing to include proper row piece information when inserting a migrated row

 

2.2.10 - (20 January 2012)

1. Unprepare affects datapump script
2. Datapump script race condition with supplemental logging fix (schema level)
3. Fix of RESET variable command
4. Fix of PAUSE/RESUME for process with non-default names
5. Do not rename table to BIN$... in list progress
6. Fix of TIMESTAMP handling in lie of Oracle implicit timezone conversions
7. Fix of decreasing SCN
8. Datapump export/old export ways of data copy
9. Single SCN instantiation support for data instantiation

 

2.2.08 - (6 January 2012)

1. Datapump script fix - dot in dblink is acceptable character
2. Datapump script race condition with supplemental logging fix
3. Support package fix for logs in ASM

 

2.2.06 - (2 January 2012)

1. LOB support
2. Improved startup speed of dbvrep executable
3. RAC support for node shutdown/startup
4. Ability to disable apply loop prevention (support simple cascaded destonations config)
5. Loop&sleep when cannot create new pooled connection to apply database
6. .trc files to collect debug info instead of using .log file; added %I (PID) and %U (unique string) placeholders
7. License type (R*)
8. One-to-many support
9. New setup wizard to support one-to-many
10. Email FATAL errors

 

2.1.08 - (30 December 2011)

1. Fix of PREPARE command
2. Fix of dictionary update when view is created

 

2.1.06 - (14 December 2011)

1. Fix of trailling blanks being trimmed in character fields
2. Support for delayed initial target table load (e.g. data pump import)

 

2.1.04 - (4 December 2011)

1. Handle multiple dictionary changes at same SCN
2. LogPackaging fix with ASM
3. Added time information into trace files
4. Fixed RAC thread syncing when conflicted with LWN
5. New default for MAIL_FROM if the usual default fails validity checks

 

2.1.02 - (30 November 2011)

1. AIX and SPARC support
2. Apply fix for case when two transactions are committed at the same SCN
3. Data type support extended to RAW, BFILE, TIMESTAMPs, INTERVALs
4. Resolve conflict as ROLLBACK
5. Partitioning
6. Support for non-ordered redo logs/multiple redo streams (11.2 default feature)
7. Crash report informations is written to .trc files
8. New Setup wizard
9. Improved network outage handling
10. Upgrade/downgrade repository
11. ASM instance name autodetection

 

2.0.16 (4 November 2011)

1. NULLs were improperly quoted in non-bind SQL in conflict log
2. LIST APPLY PLOGS fix of SQL
3. Notifications were not enabled even if configured
4. SHUTDOWN command for non-existent process was a fatal error, changed to warning
5. Lightweight thread feedback now included in log file

 

2.0.14 (14 October 2011)

1. Fix: SCN handling when wrapped
2. Out-of-order mine dictionary changes
3. Improved mine dictionary debugging

 

2.0.12 (23 September 2011)

1. START SERVICE command treated as START_SERVICE in order not to confuse Windows users by the mandatory underscore. 
2. KTB alignment fix for 10.2.0.5.
3. MINE_STAGING_DIR created if needed on startup (only if fetcher is enabled)
4. Ignored DDL conflict did not change current schema back and apply failed with FATAL-6615
5. Mine now skips DDL DROP "BIN$..." commands

 

2.0.10 (20 September 2011)

1. Autocreation of directories when creating Windows service
2. New defaults for script and log directories if the current user has no home directory
3. Basic support for initial data load using Data Pump
4. Fix for Index-Organized Table overflow segment crash

 

2.0.08 (11 September 2011)
Fixes:

1. Autocreation of trace directories fix
2. Redologs not closed fix
3. Assembly fix (caused merge of multiple updates to single one)
4. Direct insert compression detection fix
5. Apply conflict log not included in support package fix

Known limitations:

1. With RAC all nodes must be available, and all the threads must be opened by the instances.
2. No current support for following data types:
   LOBs, XMLType
   Table cluster related DDL
   IOTs (index-organized tables)
   NCHAR, NVARCHAR, NVARCHAR2
   INTERVAL, TIMESTAMP datatypes
   Object datatypes (includes ADT, VARRAY, nested tables etc.)
3. No support for compression
4. Currently for RAC 11.2 the _log_parallelism_max = 1 parameter needs to be set to disable redo optimisation

 

2.0.06 (2 September 2011)

1. Oracle 11.2 - block cleanout fixed
2. Oracle 11.2 - DDL parsing fixed

 

2.0.04 (25 August 2011)

1. Error reporting before process initialization is complete and DDC is loaded
2. Setup wizard instructions text improved
3. Added checks for incomplete redo change records
4. Fixed handling of non-existing DDC file

 

2.0.02 (15 August 2011)

1. New release