SAP HANA数据库备份方式与工具
来源:互联网 发布:lol国服mac版本 编辑:程序博客网 时间:2024/06/05 10:43
SAP HANA studio
HANA studio - 右键SID - Backup and Recovery - Back Up system 备份完整数据库或者打开Open Backup Console选择备份类型
这里的备份文件命名自动生成,如果是同样的备份路径,上一次备份将会被覆盖
SAP HANA cockpit
从studio进入或者打开链接
https://eccqas:4300/sap/hana/admin/cockpit/
http://eccqas:8000/sap/hana/admin/cockpit/
SAP HANA Backup - Create Backup创建一个backup马上备份
或者创建一个schedule周期调度,注意Backup Prefix,调度名字,周期
1
2
3
#su - sidadm
hdbsql
\c -i 00 -n eccqas:30015 -u system -p Bm2015
##
1
2
3
4
5
6
7
8
9
10
#!/bin/sh
#/* Backup script */
source
$HOME/.bashrc
date
=
"$(date +"
%Y-%m-%d
")"
time
=
"$(date +"
%Y-%m-%d %H:%M:%S
")"
backup=
"backup data using file ('$date')"
echo
"daily backup :"
$
time
"Start"
>> $DIR_INSTANCE
/backup
.log
$DIR_EXECUTABLE
/hdbsql
-U USER4BACKUP -x $backup
time
=
"$(date +"
%Y-%m-%d %H:%M:%S
")"
echo
"daily backup :"
$
time
"End"
>> $DIR_INSTANCE
/backup
.log
1
2
3
4
5
6
7
8
9
10
#!/bin/sh
#/* Complete Backup script_completebackup.sh*/
source
$HOME/.bashrc
date
=
"$(date +"
%Y-%m-%d
")"
time
=
"$(date +"
%Y-%m-%d %H:%M:%S
")"
backup=
"backup data using file ('$date.complete')"
echo
"daily backup :"
$
time
"Start"
>> $DIR_INSTANCE
/backup
.log
$DIR_EXECUTABLE
/hdbsql
-U USER4BACKUP -x $backup
time
=
"$(date +"
%Y-%m-%d %H:%M:%S
")"
echo
"daily backup :"
$
time
"End"
>> $DIR_INSTANCE
/backup
.log
1
2
3
4
5
6
7
8
9
10
#!/bin/sh
#/* Incremental Backup script_incrementbackup.sh */
source
$HOME/.bashrc
date
=
"$(date +"
%Y-%m-%d
")"
time
=
"$(date +"
%Y-%m-%d %H:%M:%S
")"
backup=
"backup data INCREMENTAL using file ('$date')"
echo
"daily backup :"
$
time
"Start"
>> $DIR_INSTANCE
/backup
.log
$DIR_EXECUTABLE
/hdbsql
-U USER4BACKUP -x $backup
time
=
"$(date +"
%Y-%m-%d %H:%M:%S
")"
echo
"daily backup :"
$
time
"End"
>> $DIR_INSTANCE
/backup
.log
阅读全文
0 0
- SAP HANA数据库备份方式与工具
- SAP HANA 备份与恢复(SAP HANA Backup and Recovery)
- SAP HANA数据恢复技术:数据库备份
- Linux下定时备份SAP HANA数据库(SAP HANA Data Backup Using Cron)
- SAP HANA数据恢复技术(二):数据库备份
- SAP HANA数据库安装
- SAP HANA内存数据库
- SAP HANA数据库安装
- SAP HANA数据库安装
- SAP HANA BACKUP系统备份
- SAP HANA常用sql备份
- SAP HANA内存数据库与oracle数据库的性能比较
- PHP访问SAP HANA数据库
- SAP Hana 数据库编程接口
- SAP HANA 数据库性能优化(SAP HANA DataBase Performance Tuning)
- 内存技术与SAP HANA
- SAP HANA: 列式内存数据库评测
- SAP HANA: 列式内存数据库评测
- react项目实战(权限模块开发五) 系统首页开发
- 利用自己的人脸数据集对人脸识别模型进行精度评测
- 主机共享文件到ESP8266_lubuntu虚拟机上
- ImportError: cannot import name downsample
- 浅谈CDQ分治 BZOJ
- SAP HANA数据库备份方式与工具
- 【C++】【入门学习】理解复杂的数组声明
- (一)简单工厂模式
- ACM基础题:素数求和问题
- 基于ZooKeeper的服务注册中心
- android 判断网络是否可用
- Redis 学习笔记(二):数据类型与相关命令
- 一、环境搭建
- nginx讲解之request_time 和upstream_response_time差别