High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Standby not apply changes when add or delete file on primary.

Hi all,

   I have confuse about applying data between primary DB and standby DB with version is 9.2.0.4.

   I were setup DataGuard environment success. When I test archivelog by use: ALTER SYSTEM ARCHIVE LOG CURRENT; --> the standby can apply data ok.

   But when I add (or delete) new datafile , standby not apply this change. I checked again parameter standby_file_management  both of primary and standby and value is AUTO. And if I issue ALTER SYSTEM ARCHIVE LOG CURRENT on primary --> standby will apply these changes immediate.

   At the standby site I also were active Apply process before by ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center