Using Oracle DataGuard for Disaster Recovery (DR), The Datafile on SMS-DR (Standby Site) is Not Removed Eventhough Has Been Removed on SMS (Primary Site) (Doc ID 1602914.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle DataGuard is being used to synchronize Primary database (SMS) with Standby database (SMS-DR).

If a datafile is removed from Primary database, DataGuard will reflected it to Standby database. As the result, both Primary and Standby database would have same level of data.

However, this is not the case. Removed datafiles (on Primary database) are still existing on Standby database.

This is especially happening to CCS_BE_CDR tablespace/datafile which is holding customer's CDR (Call Data Record). On weekly basis, a script will run to remove older tablespace/datafile.

E.g.

In Primary database,the oldest if from Week 34, while in Standby database the oldest coming from Week 27.

On SMS (Primary database):

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms