Dataguard

Register missing archive logs on a standby database

Sometimes we may end up with archive logs missing on a standby database. It can happen due to a variety of reasons. Here we discuss some scenarios where archive logs are missing at a standby database site and how to register it manually. Redo...

Troubleshooting Oracle Dataguard Transport and Apply issue

I share this post to explain how we identified and fixed an issue when our physical standby (Active Dataguard) apply was delayed and replication fell behind the primary database. Though this is a single unique scenario, the post should be a diagnostic approach when troubleshooting Oracle dataguard...

Safely remove primary and standby databases in a Dataguard configuration

In this article, we will see how we can safely remove a clustered primary and standby databases that are in an Active Dataguard configuration. Environment Primary (PRMY) is a RAC database with 2 instances. Standby (STBY) is a RAC database...

Latest posts

Removing Oracle Application Express (APEX) on 19c database fails

Oracle APEX Release 21.1.0 was released on May 12, 2021. My 19c Oracle Database came with Oracle...
- Advertisement -

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of...

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM...

Must read

- Advertisement -

You might also likeRELATED
Recommended to you

SQLs slow in 19c

Issue We patched our...

How to rename a PDB in 19c

Let's look at how to rename a...