I searched as much as possible but found lesser and lesser.
some update actions has done on mogo db or an specific collection.
we have oplog which contains any update.
what can I do without exiting from the environment through a somple process, preferable a single query update revert the effect of faulty update.
- there are point in time restore which I do not like. the process if faulty itself and complex. there are some correct updates after faulty update which should still remain. then I should remove them from oplog and apply oplog without time restriction.
- the oplog replay impose some unnecessery procedures like creating an standby DB and do repairements there(strange design)
- oplog ops manager is just creating a layer of complexity over data layer and also is not avaiable on comunity edition.
so in breif how I can revert effect of some updates through mongo shell and have data avaiable again as long as it does not contradict later changes made on collections