dump和restore命令实现全备、增量备份和差异备份

最新推荐文章于 2024-07-17 04:39:40 发布
最新推荐文章于 2024-07-17 04:39:40 发布
阅读量4.3k 收藏 2
点赞数
分类专栏： Linux Basic Management Linux Linux学习之路 文章标签： dump restore 全备 增量备份 差异备份
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/justdb/article/details/10041001
版权

差异备份，在全备的基础上做备份。因为tar命令不能实现差异备份，所以本文讲解如何用dump和restore命令实现。当然dump和restore命令也可以实现全备和增量备份。

 

一 创建备份目录 分区 挂载

[root@serv01 data]# mkdir /backup
[root@serv01 data]# fdisk /dev/sdb
[root@serv01 data]# fdisk /dev/sdc
[root@serv01 data]# mkfs.ext4 /dev/sdb1
[root@serv01 data]# mkfs.ext4 /dev/sdc1
 
[root@serv01 data]# mount /dev/sdb1 /data
[root@serv01 data]# mount /dev/sdc1/backup/

二 拷贝文件、修改配置文件

#拷贝文件
[root@serv01 data]# rm -rf *
[root@serv01 data]# cp /boot/* .
cp: omitting directory `/boot/efi'
cp: omitting directory `/boot/grub'
cp: omitting directory `/boot/lost+found'
#向fstab文件追加内容
[root@serv01 data]# echo "/dev/sdb1/data ext4 defaults 1 2" >> /etc/fstab
[root@serv01 data]# echo "/dev/sdc1/backup ext4 defaults 1 2" >> /etc/fstab

三 dump和restore——实现全备

[root@serv01 data]# yum install dump -y
#dump：支持增量备份和差异备份，只能对单独的分区进行备份
#0：全备
#u：把/etc/dumpdates更新
#f：备份后的名字
[root@serv01 data]# cd /backup/
[root@serv01 backup]# ls
lost+found
[root@serv01 backup]# rm -rf lost+found/
#第一次查看，发现dumpdates没有任何内容
[root@serv01 backup]# ls /etc/dumpdates
/etc/dumpdates
#备份
[root@serv01 backup]# dump -0uf data01.dump/data/
 DUMP: Date of this level 0 dump: Fri Aug 2 18:57:53 2013
 DUMP: Dumping /dev/sdb1 (/data) to data01.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 59 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 18:57:53 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data01.dump
 DUMP: Volume 1 completed at: Fri Aug 2 18:57:53 2013
 DUMP: Volume 1 50 blocks (0.05MB)
 DUMP: 50 blocks (0.05MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 0 dump: Fri Aug 2 18:57:53 2013
 DUMP: Date this dump completed: Fri Aug  2 18:57:53 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
[root@serv01 backup]# ll
total 52
-rw-r--r—. 1 root root 51200 Aug  2 18:57 data01.dump
#查看dumpdates文件，发现已经更新了
[root@serv01 backup]# cat /etc/dumpdates
/dev/sdb1 0 Fri Aug  2 18:57:53 2013 +0800
 
#还原，数据没有了，重新备份
[root@serv01 backup]# cd /data
[root@serv01 data]# ls
lost+found
[root@serv01 data]# rm -rf *
[root@serv01 data]# cp /boot/* ./
cp: omitting directory `/boot/efi'
cp: omitting directory `/boot/grub'
cp: omitting directory `/boot/lost+found'
[root@serv01 data]# cd /backup/
[root@serv01 backup]# ls
data01.dump
[root@serv01 backup]# rm -rf *
[root@serv01 backup]# ls
[root@serv01 backup]# > /etc/dumpdates
[root@serv01 backup]# dump -0uf dump01.dump/data/
 DUMP: Date of this level 0 dump: Fri Aug 2 19:02:20 2013
 DUMP: Dumping /dev/sdb1 (/data) to dump01.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 18674 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 19:02:20 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing dump01.dump
 DUMP: Volume 1 completed at: Fri Aug 2 19:02:20 2013
 DUMP: Volume 1 18670 blocks (18.23MB)
 DUMP: 18670 blocks (18.23MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 0 dump: Fri Aug 2 19:02:20 2013
 DUMP: Date this dump completed: Fri Aug  2 19:02:20 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
#进入data目录，发现有数据
[root@serv01 backup]# cd /data
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         symvers-2.6.32-131.0.15.el6.x86_64.gz  vmlinuz-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  System.map-2.6.32-131.0.15.el6.x86_64
#全部删除，模拟数据丢失
[root@serv01 data]# rm -rf *
[root@serv01 data]# ls
#恢复数据
[root@serv01 data]# restore -rf/backup/dump01.dump
#恢复成功
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         restoresymtable                       System.map-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  symvers-2.6.32-131.0.15.el6.x86_64.gz  vmlinuz-2.6.32-131.0.15.el6.x86_64
 
[root@serv01 data]# cp /etc/passwd ./
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         passwd          symvers-2.6.32-131.0.15.el6.x86_64.gz vmlinuz-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  restoresymtable  System.map-2.6.32-131.0.15.el6.x86_64
[root@serv01 data]# cd /backup/

四 dump和restore——实现增量备份

#增量备份：1-9
#dump：备份磁盘上的块，不止是文件；只能备份单独的分区
 
[root@serv01 data]# rm -rf *
[root@serv01 data]# cp /boot/* .
cp: omitting directory `/boot/efi'
cp: omitting directory `/boot/grub'
cp: omitting directory `/boot/lost+found'
[root@serv01 data]# cd /backup/
[root@serv01 backup]# ll
total 18672
-rw-r--r--. 1 root root 19118080 Aug  2  2013dump01.dump
[root@serv01 backup]# rm -rf dump01.dump
 
#第一次备份：全备
[root@serv01 backup]# dump -0uf data01.dump/data/
 DUMP: Date of this level 0 dump: Fri Aug 2 11:25:57 2013
 DUMP: Dumping /dev/sdb1 (/data) to data01.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 18674 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:25:57 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data01.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:25:57 2013
 DUMP: Volume 1 18670 blocks (18.23MB)
 DUMP: 18670 blocks (18.23MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 0 dump: Fri Aug 2 11:25:57 2013
 DUMP: Date this dump completed: Fri Aug  2 11:25:57 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
[root@serv01 backup]# ll
total 18672
-rw-r—r—. 1 root root 19118080 Aug  2 11:25 data01.dump
#拷贝文件到data目录
#第二次备份：增量备份
[root@serv01 backup]# cp /etc/inittab/data/
[root@serv01 backup]# dump -1uf data02.dump/data/
 DUMP: Date of this level 1 dump: Fri Aug 2 11:26:28 2013
 DUMP: Date of last level 0 dump: Fri Aug 2 11:25:57 2013
 DUMP: Dumping /dev/sdb1 (/data) to data02.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 55 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:26:28 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data02.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:26:28 2013
 DUMP: Volume 1 50 blocks (0.05MB)
 DUMP: 50 blocks (0.05MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 1 dump: Fri Aug 2 11:26:28 2013
 DUMP: Date this dump completed: Fri Aug  2 11:26:28 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
[root@serv01 backup]# ll
total 18724
-rw-r--r--. 1 root root 19118080 Aug  2 11:25 data01.dump
-rw-r--r—. 1 root root    51200 Aug 2 11:26 data02.dump
#再次拷贝文件
[root@serv01 backup]# cp /etc/passwd /data/
#第三次备份：增量备份
[root@serv01 backup]# dump -2uf data03.dump/data/
 DUMP: Date of this level 2 dump: Fri Aug 2 11:27:07 2013
 DUMP: Date of last level 1 dump: Fri Aug 2 11:26:28 2013
 DUMP: Dumping /dev/sdb1 (/data) to data03.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 55 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:27:07 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data03.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:27:07 2013
 DUMP: Volume 1 50 blocks (0.05MB)
 DUMP: 50 blocks (0.05MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 2 dump: Fri Aug 2 11:27:07 2013
 DUMP: Date this dump completed: Fri Aug  2 11:27:07 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
[root@serv01 backup]# cat /etc/dumpdates
/dev/sdb1 0 Fri Aug  2 11:25:57 2013 +0800
/dev/sdb1 1 Fri Aug  2 11:26:28 2013 +0800
/dev/sdb1 2 Fri Aug  2 11:27:07 2013 +0800
#第四次备份：增量备份
[root@serv01 backup]# dump -3uf data04.dump/data/
 DUMP: Date of this level 3 dump: Fri Aug 2 11:28:48 2013
 DUMP: Date of last level 2 dump: Fri Aug 2 11:27:07 2013
 DUMP: Dumping /dev/sdb1 (/data) to data04.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 50 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:28:48 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data04.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:28:48 2013
 DUMP: Volume 1 40 blocks (0.04MB)
 DUMP: 40 blocks (0.04MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 3 dump: Fri Aug 2 11:28:48 2013
 DUMP: Date this dump completed: Fri Aug  2 11:28:48 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
[root@serv01 backup]# cat /etc/dumpdates
/dev/sdb1 0 Fri Aug  2 11:25:57 2013 +0800
/dev/sdb1 1 Fri Aug  2 11:26:28 2013 +0800
/dev/sdb1 2 Fri Aug  2 11:27:07 2013 +0800
/dev/sdb1 3 Fri Aug  2 11:28:48 2013 +0800
#进入data目录，模拟数据丢失
[root@serv01 backup]# cd /data
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         inittab  symvers-2.6.32-131.0.15.el6.x86_64.gz
initramfs-2.6.32-131.0.15.el6.x86_64.img  passwd  vmlinuz-2.6.32-131.0.15.el6.x86_64
[root@serv01 data]# rm -rf *
[root@serv01 data]# ls
#恢复数据：一级一级地恢复
[root@serv01 data]# restore -rf/backup/data01.dump
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         restoresymtable                        System.map-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  symvers-2.6.32-131.0.15.el6.x86_64.gz  vmlinuz-2.6.32-131.0.15.el6.x86_64
[root@serv01 data]# restore -rf/backup/data03.dump
restore: Incremental tape too low
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         restoresymtable                       System.map-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  symvers-2.6.32-131.0.15.el6.x86_64.gz  vmlinuz-2.6.32-131.0.15.el6.x86_64
[root@serv01 data]# restore -rf/backup/data02.dump
[root@serv01 data]# restore -rf/backup/data03.dump
[root@serv01 data]# restore -rf/backup/data04.dump
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         inittab  restoresymtable                        vmlinuz-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  passwd  symvers-2.6.32-131.0.15.el6.x86_64.gz
 
#恢复时报错：
#1.恢复的数据不对：查看挂载是否正确
#2.restore: Incremental tape too high 同一级别的备份了多次，所以会报这个错误，检查/etc/dumpdates文件和拼写是否错误

五 dump和restore——实现差异备份

#演示差异备份
[root@serv01 data]# cd /backup/
[root@serv01 backup]# rm -rf *
[root@serv01 backup]# rm -rf data01.dump
[root@serv01 backup]# > /etc/dumpdates
#首先全备
[root@serv01 backup]# dump -0uf data01.dump/data/
 DUMP: Date of this level 0 dump: Fri Aug 2 11:43:51 2013
 DUMP: Dumping /dev/sdb1 (/data) to data01.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 16672 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:43:51 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data01.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:43:51 2013
 DUMP: Volume 1 16680 blocks (16.29MB)
 DUMP: 16680 blocks (16.29MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 0 dump: Fri Aug 2 11:43:51 2013
 DUMP: Date this dump completed: Fri Aug  2 11:43:51 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
[root@serv01 backup]# cat /etc/dumpdates
/dev/sdb1 0 Fri Aug  2 11:43:51 2013 +0800
#拷贝fstab文件
[root@serv01 backup]# cp /etc/fstab /data/
#差异备份
[root@serv01 backup]# dump -1uf data02.dump/data/
 DUMP: Date of this level 1 dump: Fri Aug 2 11:44:20 2013
 DUMP: Date of last level 0 dump: Fri Aug 2 11:43:51 2013
 DUMP: Dumping /dev/sdb1 (/data) to data02.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 55 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:44:20 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data02.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:44:20 2013
 DUMP: Volume 1 50 blocks (0.05MB)
 DUMP: 50 blocks (0.05MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 1 dump: Fri Aug 2 11:44:20 2013
 DUMP: Date this dump completed: Fri Aug  2 11:44:20 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
#拷贝yum.conf文件
[root@serv01 backup]# cp /etc/yum.conf/data
[root@serv01 backup]# dump -1ufdata021.dump /data/
 DUMP: Date of this level 1 dump: Fri Aug 2 11:44:47 2013
 DUMP: Date of last level 0 dump: Fri Aug 2 11:43:51 2013
 DUMP: Dumping /dev/sdb1 (/data) to data021.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 60 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:44:47 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data021.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:44:47 2013
 DUMP: Volume 1 60 blocks (0.06MB)
 DUMP: 60 blocks (0.06MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 1 dump: Fri Aug 2 11:44:47 2013
 DUMP: Date this dump completed: Fri Aug  2 11:44:47 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
#拷贝文件，然后差异备份
[root@serv01 backup]# cp /etc/networks/data
[root@serv01 backup]# dump -1ufdata0211.dump /data/
 DUMP: Date of this level 1 dump: Fri Aug 2 11:45:34 2013
 DUMP: Date of last level 0 dump: Fri Aug 2 11:43:51 2013
 DUMP: Dumping /dev/sdb1 (/data) to data0211.dump
 DUMP: Label: none
 DUMP: Writing 10 Kilobyte records
 DUMP: mapping (Pass I) [regular files]
 DUMP: mapping (Pass II) [directories]
 DUMP: estimated 65 blocks.
 DUMP: Volume 1 started with block 1 at: Fri Aug  2 11:45:34 2013
 DUMP: dumping (Pass III) [directories]
 DUMP: dumping (Pass IV) [regular files]
 DUMP: Closing data0211.dump
 DUMP: Volume 1 completed at: Fri Aug 2 11:45:34 2013
 DUMP: Volume 1 70 blocks (0.07MB)
 DUMP: 70 blocks (0.07MB) on 1 volume(s)
 DUMP: finished in less than a second
 DUMP: Date of this level 1 dump: Fri Aug 2 11:45:34 2013
 DUMP: Date this dump completed: Fri Aug  2 11:45:34 2013
 DUMP: Average transfer rate: 0 kB/s
 DUMP: DUMP IS DONE
 
#模拟数据删除
[root@serv01 backup]# cd /data
[root@serv01 data]# rm -rf *
#恢复时需要有全备的文件和想恢复的文件（或者最后一次），只需要两个
[root@serv01 data]# restore -rf/backup/data01.dump
[root@serv01 data]# restore -rf/backup/data021.dump
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         inittab          symvers-2.6.32-131.0.15.el6.x86_64.gz
fstab                                    passwd           vmlinuz-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  restoresymtable  yum.conf
[root@serv01 data]# rm -rf *
[root@serv01 data]# restore -rf/backup/data01.dump
[root@serv01 data]# restore -rf/backup/data0211.dump
[root@serv01 data]# ls
config-2.6.32-131.0.15.el6.x86_64         inittab   restoresymtable                        yum.conf
fstab                                    networks symvers-2.6.32-131.0.15.el6.x86_64.gz
initramfs-2.6.32-131.0.15.el6.x86_64.img  passwd   vmlinuz-2.6.32-131.0.15.el6.x86_64
 
#差异备份：一定是在全备的基础上
 
#dd没有增量备份的功能
#磁盘拷贝（对拷）
[root@serv01 backup]# cd /data/
[root@serv01 data]# ls
[root@serv01 data]# cp /boot/* .
cp: omitting directory `/boot/efi'
cp: omitting directory `/boot/grub'
cp: omitting directory `/boot/lost+found'
[root@serv01 data]# dd if=/dev/sdb1of=/dev/sdc1
dd: writing to `/dev/sdc1': Input/outputerror
4192897+0 records in
4192896+0 records out
2146762752 bytes (2.1 GB) copied, 71.3082s, 30.1 MB/s
[root@serv01 data]# df -h
Filesystem            Size Used Avail Use% Mounted on
/dev/sda2             9.7G  1.1G 8.1G  12% /
tmpfs                 188M     0 188M   0% /dev/shm
/dev/sda1             194M   25M 160M  14% /boot
/dev/sda5             4.0G  137M 3.7G   4% /opt
/dev/sr0              3.4G 3.4G     0 100% /iso
/dev/sdb1             2.0G   54M 1.9G   3% /data
/dev/sdc1             2.0G   35M 1.9G   2% /backup
[root@serv01 data]# ls /backup/
config-2.6.32-131.0.15.el6.x86_64        symvers-2.6.32-131.0.15.el6.x86_64.gz vmlinuz-2.6.32-131.0.15.el6.x86_64
initramfs-2.6.32-131.0.15.el6.x86_64.img  System.map-2.6.32-131.0.15.el6.x86_64


六 相关文章


  我的邮箱：wgbno27@163.com
  新浪微博：@Wentasy27         
  微信公众平台：JustOracle（微信号：justoracle）
  数据库技术交流群：336882565（加群时验证 From CSDN XXX）
  Oracle交流讨论组：https://groups.google.com/d/forum/justoracle
  By Larry Wen


katoonSina CSDN
@Wentasy 博文仅供参考，欢迎大家来访。如有错误之处，希望批评指正。原创博文如需转载请注明出处，谢谢 :) [CSDN博客]
Wentasy
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
数据的物理备份 完全备份 （dump）增量备份差异(binlog) 的使用 从过查找binlog日志 有选择的恢复数据（一）
weixin_46923884的博客
05-21 297
【数据备份-完全备份-物理备份】 tar -zcf /opt/mysql.tar.gz /var/lib/mysql/* //打包备份的数据库文件 scp -r /opt/mysql.tar.gz 新的主机IP地址：/opt/ //拷贝备份文件到目标主机 tar -xf /opt/mysql.tar.gz -C /opt/ //解包 rm -rf /var/lib/mysql/* cp -r /opt/* /var/lib/mysql/ //把备份文件考到目标路径 system
linux dump/restore
kunatnet的专栏
06-24 599
1.dump/restore 参　　数： 　-0123456789 　备份的层级。 　-b 　指定区块的大小，单位为KB。 　-B 　指定备份卷册的区块数目。 　-c 　修改备份磁带预设的密度与容量。 　-d 　设置磁带的密度。单位为BPI。 　-f 　指定备份设备。 　-h 　当备份层级等于或大雨指定的层级时，将不备份用户标示为"nodump"的文件。 　-n 　当备份工作需要
mongodb增量备份和恢复
最新发布
weixin_41450106的博客
07-17 55
go相关视频讲解：golang context 并发编程实战考题——实现带有过期功能的单机锁MongoDB增量备份和恢复 MongoDB是一款高性能、高可用的NoSQL数据库，广泛应用于大数据处理、实时分析等场景。然而，随着数据量的不断增长，数据备份和恢复成为了数据库管理的重要环节。本文将介绍MongoDB的增量备份和恢...
TDengine使用taosdump工具进行数据备份（导出）和恢复（导入）
小菜鸟的博客
05-29 1221
导出所有数据库使用 -A 代替 -D，后不跟数据库名，但是博主没成功，使用 -D 单独导出一个库是很稳定的，导出目录下包含一个sql文件和一个tdenginexxxxxxxx的文件夹，不用理会文件内容，导入时直接使用改目录。其中sql文件夹下是导出命令生成的文件和目录，那么导入时的路径也使用。就是说，以下命令为一组导出导入，假设数据库名为。相关文件，这些导出的相关文件可以导入时使用。数据文件，详情请参照官方文档。使用 -i 来进行数据恢复。
Linux中dump和restore命令详解
md_555的专栏
11-21 3530
1.dump/restore 只用来备份和还原ext2/ext3系统，其他文件系统不能使用。 2.dump -0u -f 存放的备份文件路径 备份的文件 -u 参数详解 它的主要作用是把备份的记录写入/etc/dumpdates文件中，另外只用备份分区时才可以使用，在分区下的子目录或者文件时不能使用的。 例如: 我们的Linux系统中分为/ /root /home 这3个分区，那么我们备
redis主从复制（增量备份、读写分离）
Lei_Da_Gou的博客
07-21 478
redis完成主从复制（增量备份）很简单： SLAVEOF 192.168.88.110 6379 redis查看复制信息： INFO replication 测试如下（三台服务器、保证slave可以ping通主机的6379端口即可）： 注意点：slave过多会影响master的性能，甚至slave的网络差延迟大都会影响master的性能（根据redis.conf中的配置文件...
Python 实现文件的全备份和差异备份详解
09-21
3. **增量备份**：仅备份自上次备份（无论是全备份还是增量备份）以来发生更改的文件。这种方式可以进一步节省存储空间，但恢复过程可能更复杂。 #### 二、备份方案的选择 选择合适的备份策略取决于几个因素，包括...
mysql mysqldump数据备份和增量备份
12-15
本篇文章主要探讨如何利用 `mysqldump` 工具进行全量备份和增量备份，这两种备份策略在不同场景下都有其独特优势。 全量备份是指备份数据库的所有数据，包括表结构、数据、索引等所有信息。在 MySQL 中，通常使用 `...
restore命令 还原备份
01-09
restore命令用来还原由dump操作所备份下来的文件或整个文件系统(一个分区)。 语法格式：restore [参数] [文件] 常用参数： -b 设置区块大小，单位是Byte -c 不检查dump操作的备份格式，仅准许读取使用旧格式的...
利用dump-restore实现备份还原
11-09
通过 `dump` 和 `restore` 命令，用户可以在 Linux 系统上高效地执行增量备份、差异备份以及文件系统的还原。这种备份机制不仅提供了灵活性，还确保了数据的安全性和完整性。在实际操作中，理解并熟练掌握 `dump` 和...
Mysql数据库全量和增量备份
04-04
MySQL 数据库全量和增量备份 MySQL 数据库全量和增量备份是指对 MySQL 数据库进行的完整备份和增量备份，以确保数据的安全和可靠性。本篇文章将对 MySQL 全量和增量备份进行详细的介绍，包括 binlog 日志的说明、...
oracle增量备份修复dg,【Oracle】基于SCN的增量备份修复DataGuardGAP
weixin_34776437的博客
04-05 309
1. 首先来模拟 Gap 的产生 1.1. 备库关闭： SYS@dgtest_sshutdown immediate; 1.2. 主库切换日志 SYS@dgtestselect SEQUENCE#,ARCHIVED,STATUS from v$log; SEQUENCE# ARC STATUS ---------- --- ---------------- 61 YES ACTIVE 62 YES...
incremental backup恢复错误一例
weixin_34380948的博客
11-15 495
本文着重讲一次恢复过程中出现的错误的解决方法，给自己备忘，也给需要的人参考。 错误现象：关闭standby数据库，将restore standby controlfile to '/u01/rmanbak/fordg/control01.ctl'恢复出来的控制文件覆盖现有的控制文件，重新启动后出现以下问题： Sat Mar 23 06:42:37 CST...
ZYNQ PS动态配置PL动态加载
jingjiankai5228的博客
09-17 5105
ZYNQ 在线加载
Linux下文件数据的备份和恢复命令： dump 和 restore
wzb56的资料库
05-18 5468
1. dump的Linux  Manual：// 用于数据的转储，备份。 转储dump可能用到的几个文件：    /dev/st0               default tape unit to dump to        /etc/dumpdates               dump date records        /etc/fstab
oracle数据库备份之exp增量备份
zcb_data的博客
05-11 8017
    本篇只介绍使用exp对oracle数据库定时备份并如何恢复的方法。    Oracle数据库有三种标准的备份方法，它们分别是导出／导入（EXP/IMP、EXPDP/IMPDP）、热备份和冷备份。导出备件是一种逻辑备份，冷备份和热备份是物理备份。    exp支持增量备份，而expdp不支持增量备份    exp/imp增量导出是一种常用的数据备份方法，它只能对整个数据库来实施，并且必须作为...
Linux数据备份与恢复 dump、restore、dd命令
weixin_33701617的博客
12-19 550
dump命令：备份分区、文件或目录 在Linux系统中 dump 命令是没有安装的，所以先安装一下 dump 命令，安装命令如下： [root@localhost ～]# yum -y install dump dump 命令可以支持 0～9 共 10 个备份级别。其中，0 级别指的就是完全备份，1～9 级别都是增量备份级别。 也就是说，当我们备份一份数据时，第一次备份应该使用 0...
Oracle自动备份_sqlplus_exp/imp三种模式
AKelly的博客
05-17 819
oracle备份与还原
oracle备份数据exp,oracle数据库备份之exp增量备份
weixin_39871378的博客
04-03 1367
oracle exp增量备份实验Oracle数据库有三种标准的备份方法，它们分别是导出／导入(EXP/IMP、EXPDP/IMPDP)、热备份和冷备份。导出备件是一种逻辑备份，冷备份和热备份是物理备份。exp支持增量备份，而expdp不支持增量备份。exp/imp增量导出是一种常用的数据备份方法，它只能对整个数据库来实施，并且必须作为SYSTEM来导出。在进行此种导出时，系统不要求回答任何问题。导...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值