The database you specified is running in NOARCHIVELOG mode and not in ARCHIVELOG mode. Please contact your Oracle DBA to perform "ALTER DATABASE ARCHIVELOG".
The Oracle database will not keep all the Archive Logs by default when NoArchiveLog mode is used, therefore CDC cannot capture changes unless the ArchiveLog mode is used.
To resolve the error, it is best to work with a seasoned Oracle database administrator. These tips may be helpful:
1. Add the Archive Log destination location:
edit your init.ora / spfile with the following information
log_archive_dest='/<username>/oradata/archlog' (for example)
log_archive_format='%t_%s.dbf' (for example)
2. On the local Oracle computer, connect using SQL Plus or another tool. Switch the user context to sysdba. Then shutdown the datatabase, and startup without opening the database (mount only), to change the Archivelog setting.
The database you specified is not setup for supplemental logging as required. Please contact your Oracle DBA to perform "ALTER DATABASE ADD SUPPLEMENTAL LOG DATA".
The Oracle database will not log enough information for CDC to be successful in log mining by default, therefore you should manually enable Supplemental Log Data to ensure the nessary changes are logged for the log miner to capture.
Connect to the database using SQL Plus or another tool and run the command to add the supplemental log data.
SUPPLEMENTAL LOG DATA;
<< Back to Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity Topics