Hi guys,
there is a network maintenance scheduled to be done over the weekend.
Lets say if it is going to take more than 4hr,
should the replication be deferred on the primary and stop the redo apply on the physical standby db?
understand that if there is a network issue happen in the data- guard env, data - guard is able to resolve the gaps.
But that is provided there is really a network issue that happens.
But this time round since is a scheduled maintenances, we should defer it and stop the application on the standby db.
My rational is that there may be 'reconnection issue' from the pri to the standby db from too many 'failed attempts' to the standby db even though in actual fact the standby db is still up or the network has resume already.
And to my best understand to re- establish the conenction from the pri to the standby db to resume the replication, one have to actually bounce the standby database.
My reading could be misunderstood so would really appriciate your contribution on my question.