SAP HANA数据库手动备份、还原

Linux 系统中创建手动备份文件夹

/*在LINUX服务器目录/hana/log/backup_<db_name>下创建文件夹20200119*/ 
mkdir -m 777 /hana/log/backup_<db_name>/20200119

HANA数据库手动备份命令

/*备份账套到指定文件夹*/  
export "<db_name>"."*" as binary into 
'/hana/log/backup_<db_name>/20200119'
 with replace threads 10  

HANA数据库手动还原命令

/*导入指定文件夹账套备份,重命名账套为<db_name>test*/ 
import "<db_name>"."*" as binary from 
'/hana/log/backup_<db_name>/20200119' 
with ignore existing  threads 10 
rename SCHEMA "<db_name>" to 
"<db_name>test"

HANA数据库手动还原自动备份命令

/*导入账套自动备份,重命名账套为<db_name>test*/ 
import "<db_name>"."*" as binary from 
'/hana/log/backup_schema/20200119' 
with ignore existing  threads 10 
rename SCHEMA "<db_name>" to 
"<db_name>test"