My Oracle Support Banner

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 SEPTEMBER 15, 2020

Applies to:

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


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.


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

On SMS (Primary database):





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.