Oracle Change Data Capture Setup with Streamkap
ARCHIVELOG
mode is enabled, your Oracle database will be taken offline.ARCHIVELOG
mode, run this script:
ARCHIVELOG
mode has been enabled, run this query:
Database log mode
is Archive Mode
then it is enabled.
SUPPLEMENTAL_LOG_DATA_MIN
is YES
it is enabled.
GROUP# | SIZE_MB | STATUS |
---|---|---|
1 | 50 | INACTIVE |
2 | 50 | INACTIVE |
3 | 50 | CURRENT |
GROUP# | LOCATION | STATUS |
---|---|---|
1 | /opt/oracle/oradata/ORCLCDB/redo01.log | ACTIVE |
2 | /opt/oracle/oradata/ORCLCDB/redo02.log | INACTIVE |
3 | /opt/oracle/oradata/ORCLCDB/redo03.log | UNUSED |
INACTIVE
and UNUSED
groups can be dropped and recreated.
ACTIVE
log so we can drop it.
ACTIVE
group to INACTIVE
. The switch could take several minutes, so be patient and recheck the size periodically. Once the status reaches INACTIVE
, replace the last, old log file and confirm all logs are resized:
GROUP# | SIZE_MB | STATUS |
---|---|---|
1 | 1024 | CURRENT |
2 | 1024 | UNUSED |
3 | 1024 | ACTIVE |
… | … | … |
{group_number}
should follow sequentially. There is no benefit to organising log groups in sequences such as 10,20,30
or mixed sizing such as 128MB, 1024MB, 512MB
.For example, if the highest group number is 3
and log file /opt/oracle/oradata/ORCLCDB/redo03.log
of size 1024MB
, the next log file added should be group 4
and log file /opt/oracle/oradata/ORCLCDB/redo04.log
of size 1024MB
.GROUP# | SIZE_MB | STATUS |
---|---|---|
1 | 1024 | CURRENT |
2 | 1024 | UNUSED |
3 | 1024 | ACTIVE |
4 | 1024 | INACTIVE |
5 | 1024 | INACTIVE |
… | … | … |
STREAMKAP_SIGNAL
. It will not be recognised if given another name.STREAMKAP_USER
or the username you chosepublic
. See Enable Snapshots for more informationbytes
)CREATE TABLE
privileges?LOG_MINING_TABLE
. If the Connector fails, it can use the last recorded value from that table to recover.
CDB
column should show YES
.
V$
tables which are not available from within a PDB.