![[转]db如何快速回滚+恢复，DBA的神技能](http://www.mobabel.net/wp-content/themes/hueman/assets/front/img/thumb-medium-empty.png)
[转]db如何快速回滚+恢复，DBA的神技能
技术人如果经常线上操作DB，河边走久了，难免出现纰漏： update错数据了 delete错数据了 drop错数据了 咋办？找DBA恢复数据呗，即使恢复不了，锅总得有人背呀。 画外音：把数据全删了，怎么办，怎么办？
-
epan says:抢购场景下，一般限定一个人一台，结合业务来实现。 -
biguoyong says:
-
Just One Pure ITer
技术人如果经常线上操作DB，河边走久了，难免出现纰漏： update错数据了 delete错数据了 drop错数据了 咋办？找DBA恢复数据呗，即使恢复不了，锅总得有人背呀。 画外音：把数据全删了，怎么办，怎么办？
Follow:
![[汇总]AI经验](http://www.mobabel.net/wp-content/themes/hueman/assets/front/img/thumb-small-empty.png)
| Cookie | Duration | Description |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |