Hello Team,
Greetings!
Scenario: 1
Server setup: 2 node (ASYNC) streaming replication with EFM configured + Witness node
Backup schedule: full + log only backup + advanced logic etc.,
Archive Delete option box is checked
When node 2 fails (standby), full backup gets triggered and consecutive log only backups are running; however archive log clean up function fails and eventually log clean up is avoided on node 1 (Primary, only standing node)
Is this expected? How can we ensure that archive log clean up happens when all of the standby’s are down?
Scenario: 2
Server setup: 4 node (SYNC) streaming replication with EFM configured + Witness node
Backup schedule: full + log only backup + advanced logic etc.,
Archive Delete option box is checked
When node 2,3,4 fails (standby), full backup gets triggered and consecutive log only backups are running; however archive log clean up function fails and eventually log clean up is avoided on node 1 (Primary, only standing node)
Is this expected? How can we ensure that archive log clean up happens when all of the standby’s are down?
Kindly revert for any clarification.
Thanks,
Kamal