备份恢复实例

一、准备工作（创建目录、授权、切换模式）
cexec 'mkdir -p /home/gbase/backup/ '
cexec 'chown -R gbase:gbase /home/gbase/backup '
-- 集群级备份需要  gcadmin switchmode readonly

二、命令行备份恢复
1、 表备份、查看、恢复 
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backup -e "backup table test.t level 0"
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backup -e "backup table test.t level 1"
        #注意录数据库 drop table t;
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backup -e "recover table test.t 0 1"
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backup -e "recover table test.t 0 0"
        #注意登录数据库 refresh table t;
    
2、 库备份、查看、恢复
   gcrcman.py -Ugbase -pgbase20110531 -r 4 -d"/home/gbase/backupdb" -e "backup database test level 0"
   gcrcman.py -Ugbase -pgbase20110531 -r 4 -d"/home/gbase/backupdb" -e "backup database test level 1"
   gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backupdb -e "show backup"
        #注意登录数据库  drop database test;
   gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backupdb -e "recover database test 0 1"
   gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backupdb -e "recover database test 0 0"
        #注意登录数据库  refresh 表名 或 重启

3、 实例备份、查看、恢复
    
    gcadmin switchmode readonly
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backupins -e "backup level 0"
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backupins -e "backup level 1"
        #可删除库 可选
        #gcadmin switchmode recovery
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backupins -e "recover 0 1"
    gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backupins -e "recover 0 0"
        
    gcadmin switchmode normal

三、交互式进入  gcrcman.py -Ugbase -pgbase20110531 -r 4 -d /home/gbase/backup 
    a、表备份恢复 全量 增量 
    backup table test.t level 0
    backup table test.t level 1
        #注意录数据库 drop table t;
    recover table test.t 0 1
    recover table test.t 0 0
        refresh table t;

    
    b、库级备份恢复 全量 增量
    backup database test level 0
    backup database test level 1
        #注意登录数据库  drop database test;
    recover database test level 1
    recover database test level 0
        #注意登录数据库  refresh table 表名 或重启
    
    
    c、实例级备份恢复 全量 增量 gcadmin switchmode readonly
    
    backup level 0
    backup level 1
        #可删除库 可选
        #gcadmin switchmode recovery
    recover  0 1
    recover  0 0

    
    
四、删除

gcrcman.py -Ugbase -pgbase20110531 -d"/home/gbase/backup" -e "delete ${cycle_id}"