We are attempting to migrate our RDS database to an Autonomous Database in Oracle Cloud (which uses GoldenGate). We have attempted to debug this issue with the Oracle Cloud migration and GoldenGate teams, but after a few attempts we believe that the issue could be more on the RDS side.
The log from the Oracle migration process is available below; note that the relevant part is the last section at the bottom of the log regarding "TRUNCATE TABLE SYSTEM.LOGMNR_SPILL$" and "RDSADMIN.RDSADMIN_TRIGGER_UTIL".
This error did not occur for our other RDS databases that were migrated to Oracle's ADB.
- What could be the reasons why we are encountering this error?
- Is there something that we can do to get around this issue?
...
2024-05-30 23:05:18 INFO OGG-02733 Heartbeat table found in the connected schema ggadmin, using this heartbeat table.
2024-05-30 23:05:18 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u02/Deployment/var/temp/BR/EXT15EKZ.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u02/Deployment/var/temp/
2024-05-30 23:05:18 INFO OGG-01851 filecaching started: thread ID: 139798012405504.
2024-05-30 23:05:18 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u02/Deployment/var/temp
/u02/Deployment/var/lib/cachemanager.
2024-05-30 23:05:18 INFO OGG-25340
Database Version:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.8.0.0.0.
2024-05-30 23:05:18 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".
2024-05-30 23:05:18 INFO OGG-26025
Database Unique Name: ORCL_A.
2024-05-30 23:05:23 INFO OGG-06604 Connected to database ORCL, CPU info: CPU Count 2, CPU Core Count 1, CPU Socket Count 1.
2024-05-30 23:05:23 INFO OGG-06618 Database ORCL Platform: Linux x86 64-bit.
2024-05-30 23:06:45 WARNING OGG-02045 Database does not have streams_pool_size initialization parameter configured.
2024-05-30 23:06:47 INFO OGG-02248 Logmining server DDL filtering enabled.
Source Context :
SourceModule : [er.redo.oraxo]
SourceID : [er/redo/oracle/redooraix.c]
SourceMethod : [attach]
SourceLine : [2275]
ThreadBacktrace : [16] elements
: [/u01/ogg/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
: [/u01/ogg/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/u01/ogg/bin/../lib/libgglog.so(_MSG_String_Int32_String(CSourceContext*, int, char const*, int, char const*, CMessageFactory::MessageDisposition))]
: [/u01/ogg/bin/extract()]
: [/u01/ogg/bin/extract(RedoIE::validateConfig(log_context_t*, ggs::gglib::ggocicpp::ORAConnection*, ggs::gglib::ggdatasource::DataSource*, ggs::gglib::ggapp::ReplicationContext*))]
: [/u01/ogg/bin/extract(RedoAPI::createInstance(ggs::gglib::ggdatasource::DataSource*, ggs::gglib::ggapp::ReplicationContext*))]
: [/u01/ogg/bin/extract(ggs::er::OraTranLogDataSource::setup())]
: [/u01/ogg/bin/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams const&))]
: [/u01/ogg/bin/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]
: [/u01/ogg/bin/extract()]
: [/u01/ogg/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/u01/ogg/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/u01/ogg/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/u01/ogg/bin/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/u01/ogg/bin/extract()]
2024-05-30 23:06:47 ERROR OGG-02028 Failed to attach to logmining server OGG$CAP_EXT15EKZ error 4,088 - ORA-04088: error during execution of trigger 'RDSADMIN.RDS_DDL_TRIGGER2'
ORA-00604: error occurred at recursive SQL level 2
ORA-20900: RDS restricted DDL found: TRUNCATE TABLE SYSTEM.LOGMNR_SPILL$
ORA-06512: at "RDSADMIN.RDSADMIN_TRIGGER_UTIL", line 915
ORA-06512: at line 1
ORA-06512: at line 12.
...
Thanks!