Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Preferences
Contact Us
Feedback
AWS Documentation
Create an AWS Account

Troubleshooting RDS for Oracle replicas

PDF
RSS
Focus mode
Troubleshooting RDS for Oracle replicas - Amazon Relational Database Service
Monitoring Oracle replication lagTroubleshooting Oracle replication failure after adding or modifying triggers

This section describes possible replication problems and solutions.

Monitoring Oracle replication lag

To monitor replication lag in Amazon CloudWatch, view the Amazon RDS ReplicaLag metric. For more information about replication lag time, see Monitoring read replication and Amazon CloudWatch metrics for Amazon RDS.

For a read replica, if the lag time is too long, query the following views:

  • V$ARCHIVED_LOG – Shows which commits have been applied to the read replica.

  • V$DATAGUARD_STATS – Shows a detailed breakdown of the components that make up the ReplicaLag metric.

  • V$DATAGUARD_STATUS – Shows the log output from Oracle's internal replication processes.

For a mounted replica, if the lag time is too long, you can't query the V$ views. Instead, do the following:

  • Check the ReplicaLag metric in CloudWatch.

  • Check the alert log file for the replica in the console. Look for errors in the recovery messages. The messages include the log sequence number, which you can compare to the primary sequence number. For more information, see Amazon RDS for Oracle database log files.

Troubleshooting Oracle replication failure after adding or modifying triggers

If you add or modify any triggers, and if replication fails afterward, the problem may be the triggers. Ensure that the trigger excludes the following user accounts, which are required by RDS for replication:

  • User accounts with administrator privileges

  • SYS

  • SYSTEM

  • RDS_DATAGUARD

  • rdsdb

For more information, see Miscellaneous considerations for RDS for Oracle replicas.

On this page

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.