KES 备份任务管理
备份任务管理
注意:
1. 如果sys_backup.conf中关于数据库的信息有所修改,需要执行sys_backup.sh init 重新初始化备 份功能。
2. 如果sys_backup.conf中关于备份周期和时间点的信息有所修改,执行sys_backup.sh start 重新配置自动备份周期。
一、sys_backup.sh start(启动定时备份任务)
执行示例:
[kingbase@kesv9 bin]$ sys_backup.sh start
# pre-condition: check the non-archived WAL files
Enable some sys_rman in crontab-daemon
no crontab for kingbase
Set full-backup in 7 days
Set incr-backup in 1 days
0 2 */7 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=full backup >> /KingbaseES/V9/Server/log/sys_rman_backup_full.log 2>&1
0 4 */1 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=incr backup >> /KingbaseES/V9/Server/log/sys_rman_backup_incr.log 2>&1
查看任务计划中已添加:
[kingbase@kesv9 bin]$ crontab -l
0 2 */7 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=full backup >> /KingbaseES/V9/Server/log/sys_rman_backup_full.log 2>&1
0 4 */1 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=incr backup >> /KingbaseES/V9/Server/log/sys_rman_backup_incr.log 2>&1
二、sys_backup.sh pause(暂停定时备份任务)
[kingbase@kesv9 bin]$ sys_backup.sh pause
# pre-condition: check the non-archived WAL files
Pause the sys_rman...DONE
[kingbase@kesv9 bin]$ crontab -l
0 2 */7 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=full backup >> /KingbaseES/V9/Server/log/sys_rman_backup_full.log 2>&1
0 4 */1 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=incr backup >> /KingbaseES/V9/Server/log/sys_rman_backup_incr.log 2>&1
三、sys_backup.sh unpause(恢复定时备份任务)
[kingbase@kesv9 bin]$ sys_backup.sh unpause
# pre-condition: check the non-archived WAL files
Un-Pause the sys_rman...DONE
[kingbase@kesv9 bin]$ crontab -l
0 2 */7 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=full backup >> /KingbaseES/V9/Server/log/sys_rman_backup_full.log 2>&1
0 4 */1 * * /KingbaseES/V9/Server/bin/sys_rman --cOnfig=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=incr backup >> /KingbaseES/V9/Server/log/sys_rman_backup_incr.log 2>&1
问题: 暂停定时任务和恢复定时任务,修改哪个配置文件了? 看crontab 和 sys_rman.conf内容没有变化;
四、sys_backup.sh stop(取消定时备份任务)
[kingbase@kesv9 bin]$ sys_backup.sh stop
# pre-condition: check the non-archived WAL files
Disable all sys_rman in crontab-daemon
[kingbase@kesv9 bin]$ crontab -l
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作