Error during execution of trigger 'RDSADMIN.RDS_DDL_TRIGGER2' when migrating database

0

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.

  1. What could be the reasons why we are encountering this error?
  2. 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!

1 Answer
0

Hi,

This post will help you understand where your Oracle error OGG-02028 comes from and maybe how to solve it.

See https://rheodata.com/resolving-ogg-02028-errors/

Best,

Didier

profile pictureAWS
EXPERT
answered 4 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions