# BTC database backup 27-12-2022 > Date: 27-11-2022 > Backup By: Anto Joeis > Time: 10.10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **7.13GB** ![](https://i.imgur.com/SVNVWXs.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **19725678** Storage size: **4.73GB** ![](https://i.imgur.com/g3Dr2Un.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-12-04-2022-12-27 ssh to BTC database ssh test@10.100.1.8 mkdir factory-backup-2022-12-04-2022-12-27 Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-12-04-2022-12-27 Modify folder permission: chmod -R 777 factory-backup-2022-12-04-2022-12-27 ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-12-04-2022-12-27 ls factory-backup-2022-12-04-2022-12-27/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-12-04-2022-12-27 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-12-26 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 18456613 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.70GB** ![](https://i.imgur.com/gOneDc5.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **1270888** Storage size: **0.29GB** ![](https://i.imgur.com/QohJSoU.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 05-12-2022 > Date: 05-12-2022 > Backup By: Anto Joeis > Time: 10.30 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **6.3GB** ![](https://i.imgur.com/xMpgG4t.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **17551269** Storage size: **4.1GB** ![](https://i.imgur.com/9KJAPEN.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-11-15-2022-12-05 ssh to BTC database ssh test@10.100.1.8 mkdir factory-backup-2022-11-15-2022-12-05 Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-11-15-2022-12-05 Modify folder permission: chmod -R 777 factory-backup-2022-11-15-2022-12-05 ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-11-15-2022-12-05 ls factory-backup-2022-11-15-2022-12-05/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-11-15-2022-12-05 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-12-04 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 17537786 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.26GB** ![](https://i.imgur.com/Mw4rV9M.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **29088** Storage size: **0.006GB** ![](https://i.imgur.com/8NqRLjW.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 16-11-2022 > Date: 16-11-2022 > Backup By: Anto Joeis > Time: 10.30 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **5.2GB** ![](https://i.imgur.com/v1IpIYF.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **12466292** Storage size: **3.1GB** ![](https://i.imgur.com/b2tRlpr.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-10-31-2022-11-16 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-10-31-2022-11-16 Modify folder permission: chmod -R 777 factory-backup-2022-10-31-2022-11-16 ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-10-31-2022-11-16 ls factory-backup-2022-10-31-2022-11-16/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-10-31-2022-11-16 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-11-15 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 11749127 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.3GB** ![](https://i.imgur.com/ZeUcksc.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **721814** Storage size: **0.17GB** ![](https://i.imgur.com/vlp9s0l.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 01-11-2022 > Date: 01-11-2022 > Backup By: Anto Joeis > Time: 10.10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **3.9GB** ![](https://i.imgur.com/uiFFkzL.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **6616793** Storage size: **1.6GB** ![](https://i.imgur.com/6IMQMQl.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-10-24-2022-11-01 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-10-24-2022-11-01 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-10-24-2022-11-01 ls factory-backup-2022-10-24-2022-11-01/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-10-24-2022-11-01 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-10-31 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 4987019 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.7GB** ![](https://i.imgur.com/nkw625j.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **1629898** Storage size: **0.3GB** ![](https://i.imgur.com/R4R1VHC.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 25-10-2022 > Date: 25-10-2022 > Backup By: Anto Joeis > Time: 10.20 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **3.0GB** ![](https://i.imgur.com/KsbCzWD.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **3283344** Storage size: **0.7GB** ![Uploading file..._s7qtaranj]() 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-10-19-2022-10-25 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-10-19-2022-10-25 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-10-19-2022-10-25 ls factory-backup-2022-10-19-2022-10-25/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-10-19-2022-10-25 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-10-24 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 2572925 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.4GB** ![](https://i.imgur.com/i2UVDSD.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **712081** Storage size: **0.17GB** ![](https://i.imgur.com/CydwSxk.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 20-10-2022 > Date: 20-10-2022 > Backup By: Anto Joeis > Time: 10.00 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **5.5GB** ![](https://i.imgur.com/hrNoALb.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **13714362** Storage size: **3.3GB** ![](https://i.imgur.com/ljMpYjo.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-09-29-2022-10-20 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-09-29-2022-10-20 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-09-29-2022-10-20 ls factory-backup-2022-09-29-2022-10-20/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-09-29-2022-10-20 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-10-19 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 12287621 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.8GB** ![](https://i.imgur.com/DlFHNnG.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **1427358** Storage size: **0.5GB** ![](https://i.imgur.com/NBB3Rta.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 30-09-2022 > Date: 30-09-2022 > Backup By: Anto Joeis > Time: 10.30 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **5.7GB** ![](https://i.imgur.com/bXTZjSf.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **15984462** Storage size: **3.5GB** ![](https://i.imgur.com/JVIbNNB.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-09-18-2022-09-30 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-09-18-2022-09-30 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-09-18-2022-09-30 ls factory-backup-2022-09-18-2022-09-30/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-09-18-2022-09-30 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-09-29 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 14662512 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.4GB** ![](https://i.imgur.com/XWA2k6g.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **1333537** Storage size: **0.3GB** ![](https://i.imgur.com/BbtENE0.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 19-09-2022 > Date: 19-09-2022 > Backup By: Nayana, Anto Joeis > Time: 10.00 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **5.3GB** ![](https://i.imgur.com/GJz9mnO.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **13416315** Storage size: **3.2GB** ![](https://i.imgur.com/n08w8fq.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-09-04-2022-09-19 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-09-04-2022-09-19 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-09-04-2022-09-19 ls factory-backup-2022-09-04-2022-09-19/dtaDB/ * Copy backup to RD_backup machine 1. ssh test@10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-09-04-2022-09-19 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-09-18 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 12498319 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.2GB** ![](https://i.imgur.com/8XnUI4O.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **925021** Storage size: **0.21GB** ![](https://i.imgur.com/oEp9o2l.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 05-09-2022 > Date: 05-09-2022 > Backup By: Nayana, Anto Joeis > Time: 10.00 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **5.0GB** ![](https://i.imgur.com/3PpS1BX.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **13018582** Storage size: **3.0GB** ![](https://i.imgur.com/DyWQZk0.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-08-25-2022-09-05 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-08-25-2022-09-05 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-08-25-2022-09-05 ls factory-backup-2022-08-25-2022-09-05/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-08-25-2022-09-05 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-09-04 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 12337470 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.1GB** ![](https://i.imgur.com/o8OModn.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **688042** Storage size: **0.18GB** ![](https://i.imgur.com/SlthgcI.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 26-08-2022 > Date: 26-08-2022 > Backup By: Nayana, Anto Joeis > Time: 10.00 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **4.8GB** ![](https://i.imgur.com/IW8vMzr.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **12985430** Storage size: **2.9GB** ![](https://i.imgur.com/QyA6cfs.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-08-17-2022-08-26 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-08-17-2022-08-26 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-08-17-2022-08-26 ls factory-backup-2022-08-17-2022-08-26/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-08-17-2022-08-26 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-08-25 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 11359522 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.3GB** ![](https://i.imgur.com/D6P3QuI.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **1634151** Storage size: **0.4GB** ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 18-08-2022 > Date: 18-08-2022 > Backup By: Nayana > Time: 10.00 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **4.7GB** ![](https://i.imgur.com/Qwriwlz.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents:**12543741** Storage size: **2.8GB** ![](https://i.imgur.com/UFmmwtT.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-08-09-2022-08-18 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-08-09-2022-08-18 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-08-09-2022-08-18 ls factory-backup-2022-08-09-2022-08-18/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-08-09-2022-08-18 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-08-17 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 10847381 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **2.2GB** ![](https://i.imgur.com/EYMK2KS.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **1697128** Storage size: **0.4GB** ![](https://i.imgur.com/wDfo9Bn.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 10-08-2022 > Date: 10-08-2022 > Backup By: Nayana > Time: 10.00 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: ** 4.6 GB** ![](https://i.imgur.com/RW098w6.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: 11620749 **** Storage size: ** 2.8 GB** ![](https://i.imgur.com/M5xzppF.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2022-06-05-2022-07-08 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-07-07-2022-08-10 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-07-07-2022-08-10 ls factory-backup-2022-07-07-2022-08-10/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-07-07-2022-08-10 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-08-09 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 10683307 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.9GB** ![](https://i.imgur.com/tr2Rd2z.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 939608**** Storage size: 0.2GB **** ![](https://i.imgur.com/B3PSgx1.png) ---------------------------------------------------------- ---------------------------------------------------------- ---------------------------------------------------------- # BTC database backup 08-07-2022 > Date: 08-07-2022 > Backup By: Nayana > Time: 10.40 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: ** 4.5 GB** ![](https://i.imgur.com/43GZscc.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents:11397230 **** Storage size: ** 2.8 GB** ![](https://i.imgur.com/Lz9pWmm.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-06-05-2022-07-08 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-06-05-2022-07-08 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-06-05-2022-07-08 ls factory-backup-2022-06-05-2022-07-08/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-06-05-2022-07-08 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-07-07 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 11375704 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.7 GB** ![](https://i.imgur.com/othqNuo.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents:21768 **** Storage size: 0.004 **** ![](https://i.imgur.com/XSxI5j6.png) ---------------------------------------------------------- # BTC database backup 06-06-2022 > Date: 06-06-2022 > Backup By: Nayana > Time: 10.10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **5.07 GB** ![](https://i.imgur.com/BVchW4x.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: 14810889 **** Storage size: **3.5 GB** ![](https://i.imgur.com/SG2qHcF.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-05-16-2022-06-06 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-05-16-2022-06-06 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-05-16-2022-06-06 ls factory-backup-2022-05-16-2022-06-06/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-05-16-2022-06-06 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-06-05 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 14808484 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **1.6 GB** ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **13357** Storage size: **0.003GB** ----------------------------------- ----------------------------------- # BTC database backup 17-05-2022 > Date: 17-05-2022 > Backup By: Nayana > Time: 10.20 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 4.2 GB** ![](https://i.imgur.com/gZU6SeI.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: 11959595 **** Storage size: ** 2.72 GB** ![](https://i.imgur.com/Jo5hsD2.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-05-03-2022-05-17 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-05-03-2022-05-17 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-05-03-2022-05-17 ls factory-backup-2022-05-03-2022-05-17/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-05-03-2022-05-17 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-05-16 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 10270756 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.8 GB** ![](https://i.imgur.com/l2y4BV6.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 883245 **** Storage size: 0.4 **GB** ![](https://i.imgur.com/lAPxxAo.png) ----------------------------------- ----------------------------------- # BTC database backup 04-05-2022 > Date: 04-05-2022 > Backup By: Nayana > Time: 10.20 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 5.4 GB** ![](https://i.imgur.com/7Wqilx3.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: 16707175 **** Storage size: ** 4 GB** ![](https://i.imgur.com/6szPo5v.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-04-13-2022-05-04 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-04-13-2022-05-04 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-04-13-2022-05-04 ls factory-backup-2022-04-13-2022-05-04/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-04-13-2022-05-04 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-05-03 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 15848288 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.6 GB** ![](https://i.imgur.com/5J2nyob.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 883245 **** Storage size: 0.20 **GB** ![](https://i.imgur.com/0hay4FD.png) ----------------------------------- ----------------------------------- # BTC database backup 14-04-2022 > Date: 14-04-2022 > Backup By: Nayana > Time: 10.35 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 4.73 GB** ![](https://i.imgur.com/xniWI83.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents:14670595 **** Storage size: ** 3.43 GB** ![](https://i.imgur.com/OA15kJn.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-03-22-2022-04-14 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-03-22-2022-04-14 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-03-22-2022-04-14 ls factory-backup-2022-03-22-2022-04-14/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-03-22-2022-04-14 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-04-13 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 13510111 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.6 GB** 3565531136 ![](https://i.imgur.com/lIXGHzr.png) ![](https://i.imgur.com/02pfp6N.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 1162264 **** Storage size: ** 0.33 GB** 2170617856 ![](https://i.imgur.com/TPkQ5nF.png) ![](https://i.imgur.com/Jk3Ptou.png) ********************************************** ****************************** ************************************************* # BTC database backup 23-03-2022 > Date: 23-03-2022 > Backup By: Nayana > Time: 10.10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 4.6 GB** ![](https://i.imgur.com/g2PSi1u.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents:14958923 **** Storage size: ** 3.4 GB** ![](https://i.imgur.com/n7E1xK0.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-03-08-2022-03-23 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-03-08-2022-03-23 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-03-08-2022-03-23 ls factory-backup-2022-03-08-2022-03-23/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-03-08-2022-03-23 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-03-22 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 13644730 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.5 GB** ![](https://i.imgur.com/H6wTpfD.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 1314809 **** Storage size: ** 0.3GB** ![](https://i.imgur.com/rsSgxKx.png) ----------------------------------- ----------------------------------- # BTC database backup 09-03-2022 > Date: 09-03-2022 > Backup By: Nayana > Time: 10.00 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 5.06 GB** ![](https://i.imgur.com/dD8VXir.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents:16853226 **** Storage size: ** 3.94 GB** ![](https://i.imgur.com/WC66TA6.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-02-14-2022-03-09 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-02-14-2022-03-09 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-02-14-2022-03-09 ls factory-backup-2022-02-14-2022-03-09/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-02-14-2022-03-09 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-03-08 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 14988287 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.59 GB** ![](https://i.imgur.com/uBAISnM.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 1865853 **** Storage size: ** 0.46 GB** ![](https://i.imgur.com/76X48Jw.png) ----------------------------------- ----------------------------------- # BTC database backup 15-02-2021 > Date: 15-02-2022 > Backup By: Nayana > Time: 10.10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 5.07 GB** ![](https://i.imgur.com/z6FLUxX.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **17590126** Storage size: ** 4.05 GB** ![](https://i.imgur.com/EdqI6t7.png) 2. Create folder : Check existing folders ```l Path: /home/test/ Command: ls -lrt factory-backup-2022-01-20-2022-02-15 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2022-01-20-2022-02-15 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2022-01-20-2022-02-15 ls factory-backup-2022-01-20-2022-02-15/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2022-01-20-2022-02-15 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-02-14 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 16326271 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **1.3 GB** ![](https://i.imgur.com/HeZjS7r.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 1264644 **** Storage size: ** 0.28 GB** ![](https://i.imgur.com/6oRG5eQ.png) --- --- --- # BTC database backup 21-01-2021 > Date: 21-01-2021 > Backup By: Nayana > Time: 10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 3.96 GB** ![](https://i.imgur.com/5p1EJu2.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **13102065** Storage size: ** 3.05 GB** ![](https://i.imgur.com/Q2NE0vA.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2021-12-22-2022-01-21 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2021-12-22-2022-01-21 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-12-22-2022-01-21 ls factory-backup-2021-12-22-2022-01-21/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2021-12-22-2022-01-21 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2022-01-20 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 11804483 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: ** 1.2GB** ![](https://i.imgur.com/NC3cqF6.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: 1306267 **** Storage size: ** 0.29 GB** ![](https://i.imgur.com/jA8IZjJ.png) --- --- --- # BTC database backup 23-12-2021 > Date: 23-12-2021 > Backup By: Nayana > Time: 10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: * 3.08 GB** ![](https://i.imgur.com/rC8Gtcz.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **9602036** Storage size: ** 2.25 GB** ![](https://i.imgur.com/kOHBpET.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2021-12-05-2021-12-23 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2021-12-05-2021-12-23 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-12-05-2021-12-23 ls factory-backup-2021-12-05-2021-12-23/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2021-12-05-2021-12-23 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2021-12-22 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 9135378 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **1.75 GB** ![](https://i.imgur.com/zlTSvSb.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **468436** Storage size: ** 0.92GB** ![](https://i.imgur.com/AxnXYVC.png) --- --- --- # BTC database backup 06-12-2021 > Date: 06-12-2021 > Backup By: Nayana > Time: 9.30 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: *3.2 GB** ![](https://i.imgur.com/OTL4roS.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **10636626** Storage size: **2.5 GB** ![](https://i.imgur.com/nxq8G5c.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt factory-backup-2021-11-07-2021-12-06 ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2021-11-07-2021-12-06 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-11-07-2021-12-06 ls factory-backup-2021-11-07-2021-12-06/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2021-11-07-2021-12-06 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2021-12-05 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 10637195 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **0.77 GB** ![](https://i.imgur.com/iYCog57.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **47** Storage size: ** 0.0001GB** ![](https://i.imgur.com/umngKat.png) --- --- --- # BTC database backup 08-11-2021 > Date: 20-10-2021 > Backup By: Nayana > Time: 10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **3.3 GB** ![](https://i.imgur.com/Y8MpeJ7.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **10005835** Storage size: **2.3 GB** ![](https://i.imgur.com/tPzAFZO.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2021-10-19-2021-11-08 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-10-19-2021-11-08 ls factory-backup-2021-10-19-2021-11-08/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2021-10-19-2021-11-08 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2021-11-07 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 10005681 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **0.71 GB** ![](https://i.imgur.com/qYFCGP2.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **384** Storage size: **0.00027 GB** ![](https://i.imgur.com/r08w1pb.png) --- --- --- # BTC database backup 20-10-2021 > Date: 20-10-2021 > Backup By: Nayana > Time: 9.30 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **2.6 GB** ![](https://i.imgur.com/fUelgGN.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **7266595** Storage size: **1.71 GB** ![](https://i.imgur.com/XC8RaYv.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2021-09-28-2021-10-20 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-09-28-2021-10-20 ls factory-backup-2021-09-28-2021-10-20/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2021-09-28-2021-10-20 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2021-10-19 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 6720341 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **0.79 GB** ![](https://i.imgur.com/OY0PBjd.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **546254** Storage size: **0.15 GB** ![](https://i.imgur.com/mkIRWxp.png) --- --- --- # BTC database backup 29-09-2021 > Date: 29-09-2021 > Backup By: Nayana > Time: 10.15 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **3.67 GB** ![](https://i.imgur.com/ZHcYigz.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **13318964** Storage size: **3.07 GB** ![](https://i.imgur.com/0YUXOOm.png) 2. Create folder : Check existing folders ``` Path: /home/test/ Command: ls -lrt ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2021-08-31-2021-09-29 Modify folder permission: chmod -R 777 <folder name> ``` 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-08-31-2021-09-29 ls factory-backup-2021-08-31-2021-09-29/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2021-08-31-2021-09-29 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2021-09-28 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 12896938 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **0.69 GB** ![](https://i.imgur.com/PKEQxEu.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **52875** Storage size: **0.09 GB** ![](https://i.imgur.com/fwmyV4c.png) --- --- --- # BTC database backup 01-09-2021 > Date: 01-09-2021 > Backup By: Nayana > Time: 10 AM ## dtaDB database statistics (Before delete) 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **4.7 GB** ![](https://i.imgur.com/cvF8IiA.png) ## Realtimestatus statistics (Before delete) **realtimestatus** No. of documents: **3468815** Storage size: **4.2 GB** ![](https://i.imgur.com/VZ6QCRD.png) 2. Create folder : ssh to BTC database ssh test@10.100.1.8 mkdir <folder name> Folder name format:<factory-backup-(START Date yyyy-mm-dd)-(End Date yyyy-mm-dd)> factory-backup-2021-08-05-2021-09-01 Modify folder permission: chmod -R 777 <folder name> 3. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-08-05-2021-09-01 ls factory-backup-2021-08-05-2021-09-01/dtaDB/ * Copy backup to RD_backup machine 1. ssh to 10.10.80.76 2. Execute below command on 10.10.80.76 scp -r test@10.100.1.8:/home/test/factory-backup-2021-08-05-2021-09-01 /home/test/BTC/ ``` ## Delete Realtimestatus records * ssh to Factory database ssh test@10.100.1.8 * sudo su * execute command in mongo shell * mongo * use dtaDB * Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2021-08-31 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 17511530 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` ## dtaDB database statistics (after delete) 5. Database and collection statistics after deleting old records **dtaDB** Storage size: **0.65 GB** ![](https://i.imgur.com/omPeCOE.png) ## Realtimestatus statistics (after delete) **realtimestatus** No. of documents: **52875** Storage size: **0.13 GB** ![](https://i.imgur.com/ZMQXJBZ.png) --- --- --- # Backup BTC MongoDB Server (08/06/2021) > Backup By: Hunter > Date: 06-08-2021 1. Database and collection statistics before deleting old records **dtaDB** Storage size: **1.24 GB** ![](https://i.imgur.com/j4vfKxP.png) **realtimestatus** No. of documents: **3468815** Storage size: **0.84 GB** ![](https://i.imgur.com/p5fI7Hb.png) 2. Compress and backup the existing dtaDB on the production server ``` mongodump --uri="mongodb://10.100.1.8:27017/dtaDB?" --gzip --out=/home/test/factory-backup-2021-07-25-2021-08-06 ls factory-backup-2021-07-25-2021-08-06/dtaDB/ scp -r test@10.100.1.8:/home/test/factory-backup-2021-07-25-2021-08-06 /home/test/BTC/ ``` 3. Delete the old records in realtimestatus collection ``` db.realtimestatus.deleteMany({"date":{$lt: new ISODate("2021-08-05 00:00:00.000Z")}}) { "acknowledged" : true, "deletedCount" : 3415940 } # Compact the collection db.runCommand({compact:'realtimestatus'}) ``` 4. Database and collection statistics after deleting old records **dtaDB** Storage size: **0.41 GB** ![](https://i.imgur.com/GzVRmwH.png) **realtimestatus** No. of documents: **52875** Storage size: **0.01 GB** ![](https://i.imgur.com/ESM5LEu.png)