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)
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.
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):
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms