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"