[HANA] HANA 2.0 SPS04 - Backup & Recovery

What's New in Backup & recovery

• Store snapshot backups with Multi-Tenant Setups
  • 다중 Tenant DB의 snapshot을 지원함
  • SAP HANA cockpit과 storage system tool을 통해서 백업과 복구가 가능
• Automatic tuncation of BnR Log Files
  • 백업 및 복구용 log 파일이 자동으로 정리 죔
    • backup.log, backint.log 와 같은 trace 파일
• Additional Option to Back up and Restore SSFS
  • BACKUP ENCRYPTION ROOT KEY
  • RECOVER ENCRYPTION ROOT KEY
  • System Database에서 수행 - DATABASE ADMIN 권한이 있어야 함
• New System Privileges for BnR Operation
  • New fine-grained privileges
  • DATABASE BACKUP OPERATOR
    • Back up a tenant database through the system database
    • Schedule a data backup of a tenant database
  • DATABASE BACKUP ADMIN
    • Back up a tenant database through the system database.
    • Schedule a data backup of a tenant database.
    • Perform housekeeping operations on backups.
    • Change the backup configuration settings.
  • DATABASE RECOVERY OPERATOR
    • Recover a tenant database through the system database.
• Changeable Backup Schedules
  • 더이상 스케줄을 지우고 생성할 필요가 없음