If my synchronous DB is out of sync and not getting sync, how to solve this issue. Can incremental backup be applied? right?
The recovery of the reported issue depends upon the exact issue and cause of out of sync. If an issue occurred due to missing WAL files then the user can pass missing WAL from archive backups but if it’s due to some other changes like creation of tablespace etc then the restoration of incremental backup not helpful.