View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005071 | SymmetricDS Pro | Bug | public | 2021-08-13 14:42 | 2021-11-04 20:09 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.12 | Fixed in Version | 3.12.12 | ||
| Summary | 0005071: Oracle log miner handle multiplexed redo log file | ||||
| Description | Oracle log miner should handle multiplexed redo log files, when the same redo log is written to multiple files for redundancy. If a redo log from the same group is added for mining, Oracle will return the following error: Caused by: java.sql.SQLException: ORA-1289: cannot add duplicate logfile /nredo/FAAAL/redo03n.log If you query v$logfile, you will see multiple log files for the same group#. Group# | Status | Type | Member | Is_ | CON_ID 3 Online /redo/FAAAL/redo03.log NO 0 3 Online /nredo/FAAAL/redo03n.log NO 0 2 Online /redo/FAAAL/redo02.log NO 0 2 Online /nredo/FAAAL/redo02n.log NO 0 1 Online /redo/FAAAL/redo01.log NO 0 1 Online /nredo/FAAAL/redo01n.log NO 0 | ||||
| Tags | dialect: oracle, log miner | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-08-13 14:42 | elong | New Issue | |
| 2021-08-13 14:42 | elong | Status | new => assigned |
| 2021-08-13 14:42 | elong | Assigned To | => elong |
| 2021-08-13 14:42 | elong | Tag Attached: dialect: oracle | |
| 2021-08-13 14:42 | elong | Tag Attached: log-miner | |
| 2021-08-13 14:43 | elong | Status | assigned => resolved |
| 2021-08-13 14:43 | elong | Resolution | open => fixed |
| 2021-08-13 14:43 | elong | Fixed in Version | => 3.12.12 |
| 2021-08-13 14:43 | elong | Summary | Oracle log miner handle mulitplexed redo log file => Oracle log miner handle multiplexed redo log file |
| 2021-11-04 20:09 | elong | Status | resolved => closed |
| 2022-08-09 17:57 | admin | Tag Renamed | log-miner => log miner |