一、场景描述某公司工程师执行db.giveget_card.drop()，误删了线上表。好在每天都在做备份，这时候就体现了备份的重要性了，哈哈哈。..2、模拟故障时备份数据大小：rs_test01:PRIMARY>useycsbswitchedtodbycsbrsbrs_test01:PRIMARY>db.giveget_card.count();在删除3173391之前，更新了此表。rs_test01:PRIMARY>db.giveget_card.insert({id:1});WriteResult({"nInserted":1})rs_test01:PRIMARY>db.giveget_card.insert({id:2});WriteResult({"nInserted":1})rs_test01:PRIMARY>db.giveget_card.insert({id:3});WriteResult({"nInserted":1})rs_test01:PRIMARY>db.giveget_card.insert({id:4});WriteResult({"nInserted":1})其他表也有更新操作。rs_test01:PRIMARY>db.tab.find();{"_id":ObjectId("59354ba202d9a99ab2f879c6"),"name":"a"}{"_id":ObjectId("59354ba602d9a99ab2f879c7"),"name":"b"}{"_id":ObjectId("59354ba802d9a99ab2f879c8"),"name":"c"}{"_id":ObjectId("59354baa02d9a99ab2f879c9"),"name":"d"}删除操作后，这张表和其他表已更新。rs_test01:PRIMARY>db.giveget_card.find();{"_id":ObjectId("59354c28d905432aeaccd53c"),"id":5}{"_id":ObjectId("59354c2bd905432aeaccd53d"),"id":6}rs_test01:PRIMARY>db.tab.find();{"_id":ObjectId("59354ba202d9a99ab2f879c6"),"name":"a"}{"_id":ObjectId("59354ba602d9a99ab2f879c7"),"name":"b"}{"_id":ObjectId("59354ba802d9a99ab2f879c8"),"name":"c"}{"_id":ObjectId("59354baa02d9a99ab2f879c9"),"name":"d"}{"_id":ObjectId("59354ccfd905432aeaccd542"),"name":"e"}{"_id":ObjectId("59354cd2d905432aeaccd543"),"name":"f"}3.恢复步骤1.将tab表的giveget_card.bson和giveget_card.metadata保存在备份。json文件复制到/tmp/restore/ycsb目录下（自建目录），ycsb为库名。#cp/数据/备份/rs07/ycsb/giveget_card.*/tmp/restore/ycsb2。导出备份时间后误删操作前的oplog恢复表#mongodump--port2203-dlocal-coplog.rs-q'{"ts":{$gte:Timestamp(1496664480,10430),$lte:timestamp(1496665113,10430)}}'-o/tmp/oplog--timestamp是使用转换工具转换后的结果。3、使用bsondump查看oplog日志，找到drop操作的时间戳1496665069#bsondump/tmp/oplog/local/oplog.rs.bson{"ts":{"$timestamp":{"t":1496664760,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"7079172056815894727"},"v":2,"op":"i","ns":"ycsb.giveget_card","o":{"_id":{"$oid":"59354ab8c5308d8c7a9da8b5"},"id":1.0}}{"ts":{"$timestamp":{"t":1496664762,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"-1797107728294067016"},"v":2,"op":"i","ns":"ycsb.giveget_card","o":{"_id":{"$oid":"59354abac5308d8c7a9da8b6"},"id":2.0}}{"ts":{"$timestamp":{"t":1496664765,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"8604646791509150392"},"v":2,"op":"i","ns":"ycsb.giveget_card","o":{"_id":{"$oid":"59354abdc5308d8c7a9da8b7"},"id":3.0}}{"ts":{"$timestamp":{"t":1496664768,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"9018614066505371436"},"v":2,"op":"i","ns":"ycsb.giveget_card","o":{"_id":{"$oid":"59354ac0c5308d8c7a9da8b8"},"id":4.0}}{"ts":{"$timestamp":{"t":1496664994,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"-4471524661347063602"},"v":2,"op":"c","ns":"ycsb.$cmd","o":{"create":"tab"}}{"ts":{"$timestamp":{"t":1496664994,"i":2}},"t":{"$numberLong":"12"},"h":{"$numberLong":"-4215905958456607246"},"v":2,"op":"i","ns":"ycsb.tab","o":{"_id":{"$oid":"59354ba202d9a99ab2f879c6"},"名称":"a"}}{"ts":{"$timestamp":{"t":1496664998,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"6170506962401844481"},"v":2,"op":"i","ns":"ycsb.tab","o":{"_id":{"$oid":"59354ba602d9a99ab2f879c7"},"名称":"b"}}{"ts":{"$timestamp":{"t":1496665000,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"-8071456063660489895"},"v":2,"op":"i","ns":"ycsb.tab","o":{"_id":{"$oid":"59354ba802d9a99ab2f879c8"},"name":"c"}}{"ts":{"$timestamp":{"t":1496665002,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"4387884836668659146"},"v":2,"op":"i","ns":"ycsb.tab","o":{"_id":{"$oid":"59354baa02d9a99ab2f879c9"},"name":"d"}}{"ts":{"$timestamp":{"t":1496665069,"i":1}},"t":{"$numberLong":"12"},"h":{"$numberLong":"-6913449254950935781"},"v":2,"op":"c","ns":"ycsb.$cmd","o":{"drop":"giveget_card"}}2017-06-05T20:27:25.552+080010objectsfound4.复制oplog的bson文件到对应目录#cp/tmp/oplog/local/oplog.rs.bson/tmp/restore/oplog.bson此时恢复的目录结构：#pwd/tmp/restore#lsoplog.bsonycsb5至此，所有准备工作已经完成，恢复数据[root@ops-db-test02restore]#mongorestore--port2203--oplogReplay--oplogLimit=1496665069:1/tmp/restore2017-06-05T20:36:45.361+0800buildingalistofdbsandcollectionstorestorefrom/tmp/restoredir2017-06-05T20:36:45.361+0800读取元数据forycsb.giveget_cardfrom/tmp/restore/ycsb/giveget_card.metadata.json2017-06-05T20:36:45.364+0800restoringycsb.giveget_cardfrom/tmp/restore/ycsb/giveget_card.bson2017-06-05T20:36:48.30[......................]ycsb.giveget_card15.4MB/475MB(3.2%)2017-06-05T20:36:51.362+0800[#.......................]ycsb.giveget_card31.1MB/475MB(6.6%)2017-06-05T20:36:54.362+0800[##......................]ycsb.giveget_card46.6MB/475MB(9.8%)2017-06-05T20:36:57.362+0800[###.............]ycsb.giveget_card62.1MB/475MB(13.1%)2017-06-05T20:37:00.362+0800[###.....................]ycsb.giveget_card76.4MB/475MB(16.1%)2017-06-05T20:37:03.362+0800[####.....................]ycsb.giveget_card90.7MB/475MB(19.1%)2017-06-05T20:37:06.362+0800[#####......................]ycsb.giveget_card105MB/475MB(22.0%)2017-06-05T20:37:09.362+0800[######...................]ycsb.giveget_card120MB/475MB(25.2%)2017-06-05T20:37:12.362+0800[######...................]ycsb.giveget_card133MB/475MB(28.0%)2017-06-05T20:37:15.362+0800[#######................]ycsb.giveget_card146MB/475MB(30.8%)2017-06-05T20:37:18.363+0800[########...............]ycsb.giveget_card163MB/475MB(34.3%)2017-06-05T20:37:21.362+0800[########........................]ycsb.giveget_card178MB/475MB(37.4%)2017-06-05T20:37:24.362+0800[#########......]ycsb.giveget_card196MB/475MB(41.3%)2017-06-05T20:37:27.362+0800[##########......]ycsb.giveget_card214MB/475MB(45.0%)2017-06-05T20:37:30.362+0800[###########................]ycsb.giveget_card231MB/475MB(48.6%)2017-06-05T20:37:33.362+0800[############......]ycsb.giveget_card245MB/475MB(51.5%)2017-06-05T20:37:36.362+0800[#############......]ycsb.giveget_card261MB/475MB(54.8%)2017-06-05T20:37:39.362+0800[##############......]ycsb.giveget_card279MB/475MB(58.7%)2017-06-05T20:37:42.362+0800[###############......]ycsb.giveget_card297MB/475MB(62.5%)2017-06-05T20:37:45.362+0800[###############......]ycsb.giveget_card312MB/475MB(65.8%)2017-06-05T20:37:48.362+0800[################.......]ycsb.giveget_card328MB/475MB(69.0%)2017-06-05T20:37:51.362+0800[#################.......]ycsb.giveget_card341MB/475MB(71.8%)2017-06-05T20:37:54.362+0800[#################.......]ycsb.giveget_card356MB/475MB(74.9%)2017-06-05T20:37:57.362+0800[##################......]ycsb.giveget_card373MB/475MB(78.5%)2017-06-05T20:38:00.362+0800[###################。....]ycsb.giveget_card388MB/475MB(81.7%)2017-06-05T20:38:03.362+0800[####################....]ycsb.giveget_card405MB/475MB(85.2%)2017-06-05T20:38:06.362+0800[#####################...]ycsb.giveget_card419MB/475MB(88.2%)2017-06-05T20:38:09.362+0800[###################...]ycsb.giveget_card434MB/475MB(91.4%)2017-06-05T20:38:12.362+0800[######################..]ycsb.giveget_card442MB/475MB(93.1%)2017-06-05T20:38:15.362+0800[#######################.]ycsb.giveget_card459MB/475MB(96.6%)2017-06-05T20:38:18.362+0800[#######################.]ycsb.giveget_card475MB/475MB(99.9%)2017-06-05T20:38:18.427+0800[########################]ycsb.giveget_card475MB/475MB(100.0%)2017-06-05T20:38:18.427+0800restoringindexesforcollectionycsb。giveget_cardfrommetadata2017-06-05T20:38:44.680+0800finishedrestoringycsb.giveget_card(3173391documents)2017-06-05T20:38:44.680+0800replayingoplog2017-06-05T20:38:44.739+0800done6、查看恢复的结果rs_test01:PRIMARY>db.giveget_card.find({id:{$gte:1}});{"_id":ObjectId("59354cb9d905432aeaccd540"),"id":5}{"_id":ObjectId("59354cc0d905432aeaccd541"),"id":6}{"_id":ObjectId("59354ab8c5308d8c7a9da8b5"),"id":1}{"_id":ObjectId("59354abac5308d8c7a9da8b6"),"id":2}{"_id":ObjectId("59354abdc5308d8c7a9da8b7"),"id":3}{"_id":ObjectId("59354ac0c5308d8c7a9da8b8"),"id":4}数据内容为相同，但存储顺序与之前的数据存储顺序不同rs_test01:PRIMARY>db.giveget_card.count();3173397结果count=备份表数据3173391+6.7后更新的数据.因为dump出来的oplog还包括othertablesOperation.检查恢复过程中是否影响到其他表。rs_test01:PRIMARY>db.tab.find();{"_id":ObjectId("59354ba202d9a99ab2f879c6"),"name":"a"}{"_id":ObjectId("59354ba602d9a99ab2f879c7"),"name":"b"}{"_id":ObjectId("59354ba802d9a99ab2f879c8"),"name":"c"}{"_id":ObjectId("59354baa02d9a99ab2f879c9"),"name":"d"}{"_id":ObjectId("59354ccfd905432aeaccd542"),"name":"e"}{"_id":ObjectId("59354cd2d905432aeaccd543"),"name":"f"}--tab表中的数据与原表数据相同，即没有效果，说明来自其他表的日志正在运行为空。以上就是backup结合oplog的恢复操作。备份很重要！！！备份很重要！！！备份很重要！！！重要的事情说三遍~~~
