人大金仓联机物理还原

<h1>一、查看已有备份集</h1> <p>1.切换kingbase用户执行：su - kingbase 2.查看备份集： sys_rman show -B /home/kingbase/backup/(备份集目录) <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/60e1d7cc4d58cf069e21613f8f383722" alt="" /></p> <h1>二、联机物理还原</h1> <p>还原前先停服务：systemctl stop kingbase 查看进程是否存在：ps -ef |grep kingbase(若存在，则kill掉) 不存在： <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/38030f5e292eb2bd745ac972ad8b644f" alt="" /> 存在： <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/20b28093b4e04d2aeba9f1bb279bd565" alt="" /> 备份原数据目录data，重命名data为data1 mv /risen/soft/database/Kingbase/ES/V8/data /risen/soft/database/Kingbase/ES/V8/data1</p> <h2>1、默认还原到最新时间点(三选一)</h2> <p>mkdir data sys_rman restore -B /home/kingbase/backup -D /risen/soft/database/Kingbase/ES/V8/data/ <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/6a926b388caf678ef1cdbef5b554d7c1" alt="" /> systemctl start kingbase(启动验证数据)</p> <h2>2、还原到某个备份集（可指定备份集ID）(三选一)</h2> <p>mkdir data sys_rman restore R43K2Q -B /home/kingbase/backup -D /risen/soft/database/Kingbase/ES/V8/data <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/c925380b79e72d232980cdcb75b1f9a6" alt="" /> page增量备份的还原时 ，会先还原最近的全库备份full，在还原page增量备份的备份集 systemctl start kingbase(启动验证数据)</p> <h2>3、基于时间点还原(三选一，需要企业版授权文件)</h2> <p>mkdir data sys_rman restore -B /home/kingbase/backup -D /risen/soft/database/Kingbase/ES/V8/data --time '2021-12-14 15:30:29' <img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/32a0675cb388775f8f549aaf3758d403" alt="" /> systemctl start kingbase(启动验证数据)</p>