在线备份恢复

1、在线库级全备
(1) 创建备份目录
mkdir -p  /opt/gbase/bak1/library
chown -R gbase:gbase /opt/gbase/bak1/library
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/library  -p GBase2O11O531 -PNanda_123
backup database tpch  level 0
show backup
quit

2、在线表级全备
mkdir -p  /opt/gbase/bak1/table
chown -R gbase:gbase /opt/gbase/bak1/table
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/table -p GBase2O11O531 -PNanda_123
backup table tpch.lineitem level 0
show backup
quit

查看当前数据量
gccli -vvv -Dtest -e"select count(*)  from lineitem;"

3、在线库级增量
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/library  -p GBase2O11O531 -PNanda_123
backup database test level 1
show backup
quit

4、在线表级增量
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/table -p GBase2O11O531 -PNanda_123
backup table test.lineitem level 1
show backup
quit

5、关闭后台脚本
############################################################################################################################33
gccli -vvv -Dtest -e"truncate table lineitem;"
gccli -vvv -Dtest -e"select count(*)  from lineitem;"

1、库级全量恢复
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/library  -p GBase2O11O531 -PNanda_123
show backup
recover database  test 0 0
quit

2、表级全量恢复
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/table -p GBase2O11O531 -PNanda_123
show backup
recover table test.lineitem 0 0
quit

gccli -vvv -Dtest -e"select count(*)  from lineitem;"

3、库级增量恢复
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/library  -p GBase2O11O531 -PNanda_123
show backup
recover database  test 0 1
quit

4、表级增量恢复
python $GCLUSTER_HOME/bin/gccow.py  -d /opt/gbase/bak1/table -p GBase2O11O531 -PNanda_123
show backup
recover table test.lineitem 0 1
quit

gccli -vvv -Dtest -e"select count(*)  from lineitem;"