人大金仓一键脚本备份
<h1>1、一键部署自动备份工具(所有修改都在kingbase用户下执行)</h1>
<p>su - kingbase</p>
<h2>1.1.逻辑备份</h2>
<p>cd /risen/soft/database/Kingbase/ES/V8/Server/kb_scripts/kb_backup/logical
vim backup8.conf
修改backup8.conf文件相对应的信息
kdb_home="/risen/soft/database/Kingbase/ES/V8/Server"(安装目录)
kdbback_dest="/risen/data/dbdata/kingbase/dump"(备份路径)
kdb_user="SYSTEM"
kdb_pass="Risen@2021"
kdb_port="16506"
kdb_host="127.0.0.1"
kdb_list="ZYLY_TEST" (备份库名)
keep_time="7" (自动清理时间周期)</p>
<h2>1.2.执行一键部署工具</h2>
<p>[kingbase@kingbase2 logical]$ ./fast_deploy_backup8.sh
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/511bac96b864eb664e21bd09bf177683" alt="" /></p>
<h2>1.3执行检查备份脚本backup8_check.sh</h2>
<p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/aaffab5f657376412bc5687cd8863a95" alt="" /></p>
<h1>2.物理备份</h1>
<h2>2.1配置参数</h2>
<p>在kingbase.conf下修改参数
wal_level='replica'
archive_mode='on'
archive_dest='/risen/data/dbdata/kingbase/archive' (归档路径)</p>
<h2>2.2修改rman.conf文件相对应的信息</h2>
<p>cd /risen/soft/database/Kingbase/ES/V8/Server/kb_scripts/kb_backup/rman
vim rman.conf #修改以下内容
kdb_home="/risen/soft/database/Kingbase/ES/V8/Server"
kdb_data="/risen/soft/database/Kingbase/ES/V8/data"
kdb_user="SYSTEM"
kdb_pass="Risen@2021"
kdb_port="16506"
kdb_host="127.0.0.1"
kdbback_dest="/risen/data/dbdata/kingbase/backup" (备份路径)
kdbarchive_dest="/risen/data/dbdata/kingbase/archive" (归档路径)
keep_num="3" (保留备份集份数)</p>
<h2>2.3执行fast_deploy_rman.sh</h2>
<p>物理备份路径和归档路径在rman.conf填完后,不用去手动创建路径,执行fast_deploy_rman.sh会自动创建,执行前检查备份路径下面是否为空,不为空清空在执行。
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/b95b62fdb470e49926c48922ebf04edf" alt="" /></p>
<h2>2.4执行./rman_check.sh</h2>
<p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/af9aa67d8208cb56fca82b6ea33977b2" alt="" /></p>
<h2>2.5 查看定时任务</h2>
<p>crontab -l
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/d26c4859788c6cdc21cd2b91fd9d7db9" alt="" /></p>