Standby not apply changes when add or delete file on primary.
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;