管理和监视已备份的 SAP HANA 数据库Manage and monitor backed up SAP HANA databases

本文介绍了对在 Azure 虚拟机 (VM) 上运行且通过 Azure 备份服务备份到 Azure 备份恢复服务保管库的 SAP HANA 数据库进行管理和监视时的常见任务。This article describes common tasks for managing and monitoring SAP HANA databases that are running on an Azure virtual machine (VM) and that are backed up to an Azure Backup Recovery Services vault by the Azure Backup service. 你将了解如何监视作业和警报、触发按需备份、编辑策略、停止和恢复数据库保护,以及从备份中取消注册 VM。You'll learn how to monitor jobs and alerts, trigger an on-demand backup, edit policies, stop and resume database protection and unregister a VM from backups.

如果尚未为 SAP HANA 数据库配置备份,请参阅备份 Azure VM 上的 SAP HANA 数据库If you haven't configured backups yet for your SAP HANA databases, see Back up SAP HANA databases on Azure VMs.

在门户中监视手动备份作业Monitor manual backup jobs in the portal

Azure 备份在 Azure 门户的“备份作业”部分中显示所有手动触发的作业。Azure Backup shows all manually triggered jobs in the Backup jobs section on Azure portal.

“备份作业”部分

你在此门户中看到的作业包括数据库发现和注册,以及备份和还原操作。The jobs you see in this portal include database discovery and registering, and backup and restore operations. 计划作业(包括日志备份)不会显示在此部分中。Scheduled jobs, including log backups aren't shown in this section. 从 SAP HANA 本机客户端 (Studio/Cockpit/DBA Cockpit) 手动触发的备份也不会显示在此处。Manually triggered backups from the SAP HANA native clients (Studio/ Cockpit/ DBA Cockpit) also don't show up here.

“备份作业”列表

若要了解有关监视的详细信息,请转到在 Azure 门户中监视使用 Azure Monitor 进行监视To learn more about monitoring, go to Monitoring in the Azure portal and Monitoring using Azure Monitor.

查看备份警报View backup alerts

警报是监视 SAP HANA 数据库的备份的一种简单方法。Alerts are an easy means of monitoring backups of SAP HANA databases. 警报可帮助你专注于你最关注的事件,而不会迷失在备份生成的多个事件中。Alerts help you focus on the events you care about the most without getting lost in the multitude of events that a backup generates. Azure 备份允许你设置警报,并且可以按如下所示进行监视:Azure Backup allows you to set alerts, and they can be monitored as follows:

  • 登录 Azure 门户Sign in to the Azure portal.

  • 在保管库仪表板中,选择“备份警报”。On the vault dashboard, select Backup Alerts.

    保管库仪表板上的备份警报

  • 你将能够看到警报:You will be able to see the alerts:

    备份警报列表

  • 单击警报以查看更多详细信息:Click on the alerts to see more details:

    警报详细信息

如今,Azure 备份允许通过电子邮件发送警报。Today, Azure Backup allows the sending of alerts through email. 这些警报包括:These alerts are:

  • 针对所有备份失败触发的警报。Triggered for all backup failures.
  • 按错误代码在数据库级别合并的警报。Consolidated at the database level by error code.
  • 仅针对数据库首次备份失败发送的警报。Sent only for a database's first backup failure.

若要详细了解监视,请转到在 Azure 门户中监视使用 Azure Monitor 进行监视ToTo learn more about monitoring, go to Monitoring in the Azure portal and Monitoring using Azure Monitor.

管理操作Management Operations

借助 Azure 备份,可以通过大量支持的管理操作轻松地管理已备份的 SAP HANA 数据库。Azure Backup makes management of a backed-up SAP HANA database easy with an abundance of management operations that it supports. 以下部分更详细地讨论了这些操作。These operations are discussed in more detail in the following sections.

运行按需备份Run an on-demand backup

备份根据策略计划运行。Backups run in accordance with the policy schedule. 可以按需运行备份,如下所示:You can run a backup on-demand as follows:

  1. 在保管库菜单中,单击“备份项”。In the vault menu, click Backup items.
  2. 在“备份项”中,选择运行 SAP HANA 数据库的 VM,然后单击“立即备份”。In Backup Items, select the VM running the SAP HANA database, and then click Backup now.
  3. 在“立即备份”中,使用日历控件选择应当保留恢复点的最后一天。In Backup Now, use the calendar control to select the last day that the recovery point should be retained. 然后单击“确定”。Then click OK.
  4. 监视门户通知。Monitor the portal notifications. 可以在保管库仪表板 >“备份作业” > “进行中”监视作业进度。 You can monitor the job progress in the vault dashboard > Backup Jobs > In progress. 创建初始备份可能需要一些时间,具体取决于数据库的大小。Depending on the size of your database, creating the initial backup may take a while.

HANA 本机客户端集成HANA native client integration

备份Backup

从任何 HANA 本机客户端触发(到 Backint)的按需备份将显示在“备份项”页上的备份列表中 。On-demand backups triggered from any of the HANA native clients (to Backint) will show up in the backup list on the Backup Items page.

上次备份运行时间

还可以从“备份作业”页监视这些备份You can also monitor these backups from the Backup jobs page.

这些按需备份还将显示在用于还原的还原点列表中。These on-demand backups will also show up in the list of restore points for restore.

还原点列表

还原Restore

可以从“备份作业”页监视从 HANA 本机客户端(使用 Backint)触发以还原到同一台计算机的还原 。Restores triggered from HANA native clients (using Backint) to restore to the same machine can be monitored from the Backup jobs page.

在启用了 Azure 备份的数据库上运行 SAP HANA 本机客户端备份Run SAP HANA native client backup on a database with Azure backup enabled

如果要对正在使用 Azure 备份备份的数据库执行本地备份(使用 HANA Studio/Cockpit),请执行以下操作:If you want to take a local backup (using HANA Studio / Cockpit) of a database that's being backed up with Azure Backup, do the following:

  1. 等待数据库的所有完整备份或日志备份完成。Wait for any full or log backups for the database to finish. 检查 SAP HANA Studio/Cockpit 中的状态。Check the status in SAP HANA Studio/ Cockpit.
  2. 禁用日志备份,并将备份目录设置为相关数据库的文件系统。Disable log backups, and set the backup catalog to the file system for relevant database.
  3. 为此,请双击“systemdb” > “配置” > “选择数据库” > “筛选器(日志)” 。To do this, double-click systemdb > Configuration > Select Database > Filter (Log).
  4. 将 enable_auto_log_backup 设置为“否” 。Set enable_auto_log_backup to No.
  5. 将 log_backup_using_backint 设置为 False 。Set log_backup_using_backint to False.
  6. 对数据库执行按需完整备份。Take an on-demand full backup of the database.
  7. 等待完整备份和目录备份完成。Wait for the full backup and catalog backup to finish.
  8. 将以前的设置还原为适用于 Azure 的设置:Revert the previous settings back to those for Azure:
    • 将 enable_auto_log_backup 设置为“是” 。Set enable_auto_log_backup to Yes.
    • 将 log_backup_using_backint 设置为 True 。Set log_backup_using_backint to True.

更改策略Change policy

可以更改 SAP HANA 备份项的基础策略。You can change the underlying policy for an SAP HANA backup item.

  • 在保管库仪表板中,转到“备份项”:In the vault dashboard, go to Backup items:

    选择备份项

  • 选择“Azure VM 中的 SAP HANA”Choose SAP HANA in Azure VM

    选择 Azure VM 中的 SAP HANA

  • 选择要更改其基础策略的备份项Choose the backup item whose underlying policy you want to change

  • 单击现有备份策略Click on the existing Backup policy

    选择现有备份策略

  • 更改策略,从列表中进行选择。Change the policy, choosing from the list. 创建新备份策略(如果需要)。Create a new backup policy if needed.

    从下拉列表中选择策略

  • 保存更改Save the changes

    保存更改

  • 策略修改将影响所有关联的备份项,并触发相应的配置保护作业。Policy modification will impact all the associated Backup Items and trigger corresponding configure protection jobs.

备注

保留期内的所有更改都将以回溯方式应用于除新恢复点以外的所有旧恢复点。Any change in the retention period will be applied retrospectively to all the older recovery points besides the new ones.

增量备份策略不能用于 SAP HANA 数据库。Incremental backup policies cannot be used for SAP HANA databases. 这些数据库目前不支持增量备份。Incremental backup is not currently supported for these databases.

修改策略Modify Policy

修改策略以更改备份类型、频率和保持期。Modify policy to change backup types, frequencies and retention range.

备注

保留期内的所有更改都将以追溯方式应用于所有除新恢复点以外的旧恢复点。Any change in the retention period will be applied retroactively to all the older recovery points, in addition to the new ones.

  1. 在保管库仪表板中,转到“管理”>“备份策略”,然后选择要编辑的策略。In the vault dashboard, go to Manage > Backup Policies and choose the policy you want to edit.

    选择要编辑的策略

  2. 选择“修改”。Select Modify.

    选择“修改”

  3. 选择备份类型的频率。Choose the frequency for the backup types.

    选择备份频率

策略修改将影响所有关联的备份项,并触发相应的配置保护作业。Policy modification will impact all the associated backup items and trigger corresponding configure protection jobs.

策略不一致Inconsistent policy

有时,修改策略操作可能导致某些备份项的策略版本不一致。Occasionally a modify policy operation can lead to an inconsistent policy version for some backup items. 如果在触发修改策略操作后,备份项的相应配置保护作业失败,则会发生这种情况。This happens when the corresponding configure protection job fails for the backup item after a modify policy operation is triggered. 它在备份项视图中显示如下:It appears as follows in the backup item view:

策略不一致

单击一下即可修复所有受影响的项的策略版本:You can fix the policy version for all the impacted items in one click:

修复策略版本

停止对 SAP HANA 数据库的保护Stop protection for an SAP HANA database

可以通过以下几种方式停止保护 SAP HANA 数据库:You can stop protecting an SAP HANA database in a couple of ways:

  • 停止所有将来的备份作业并删除所有恢复点。Stop all future backup jobs and delete all recovery points.
  • 停止所有将来的备份作业,且恢复点保留不变。Stop all future backup jobs and leave the recovery points intact.

如果选择保留恢复点,请记住以下详细内容:If you choose to leave recovery points, keep these details in mind:

  • 所有恢复点都将永久保持不变,所有删除操作都应在停止保护时停止,并保留数据。All recovery points will remain intact forever, all pruning shall stop at stop protection with retain data.
  • 你将为受保护的实例和使用的存储付费。You will be charged for the protected instance and the consumed storage. 有关详细信息,请参阅 Azure 备份定价For more information, see Azure Backup pricing.
  • 如果在不停止备份的情况下删除数据源,则新备份会失败。If you delete a data source without stopping backups, new backups will fail.

停止数据库的保护:To stop protection for a database:

  • 在保管库仪表板中,选择“备份项”。On the vault dashboard, select Backup Items.

  • 在“备份管理类型”下,选择“Azure VM 中的 SAP HANA” Under Backup Management Type, select SAP HANA in Azure VM

    选择“Azure VM 中的 SAP HANA”

  • 选择要停止保护的数据库:Select the database for which you want to stop protection on:

    选择要停止保护的数据库

  • 在数据库菜单中,选择“停止备份”。On the database menu, select Stop backup.

    选择“停止备份”

  • 在“停止备份”菜单中,选择是保留还是删除数据。On the Stop Backup menu, select whether to retain or delete data. 如果需要,请提供原因和注释。If you want, provide a reason and comment.

    选择是保留还是删除数据

  • 选择“停止备份”。Select Stop backup.

恢复对 SAP HANA 数据库的保护Resume protection for an SAP HANA database

如果停止对 SAP HANA 数据库的保护且选择“保留备份数据”选项,可在稍后恢复保护。When you stop protection for the SAP HANA database, if you select the Retain Backup Data option, you can later resume protection. 如果不保留备份的数据,则无法恢复保护。If you don't retain the backed-up data, you will not be able to resume protection.

若要恢复对 SAP HANA 数据库的保护,请执行以下操作:To resume protection for an SAP HANA database:

  • 打开备份项,然后选择“恢复备份”。Open the backup item and select Resume backup.

    选择恢复备份

  • 在“备份策略”菜单中选择策略,然后选择“保存”。 On the Backup policy menu, select a policy, and then select Save.

从 SDC 升级到 MDCUpgrading from SDC to MDC

了解从 SDC 升级到 MDC 后如何继续执行 SAP HANA 数据库的备份。Learn how to continue backup for an SAP HANA database after upgrading from SDC to MDC.

从 SDC 升级到 MDC 而未更改 SIDUpgrading from SDC to MDC without a SID change

了解从 SDC 升级到 MDC 而未更改 SID 时如何继续执行 SAP HANA 数据库的备份。Learn how to continue backup of an SAP HANA database whose SID has not changed after upgrade from SDC to MDC.

取消注册 SAP HANA 实例Unregister an SAP HANA instance

在禁用保护之后但删除保管库之前取消注册 SAP HANA 实例:Unregister an SAP HANA instance after you disable protection but before you delete the vault:

  • 在保管库仪表板上,在“管理”下,选择“备份基础结构”。 On the vault dashboard, under Manage, select Backup Infrastructure.

    选择“备份基础结构”。

  • 将“备份管理类型”选择为“Azure VM 中的工作负载” Select the Backup Management type as Workload in Azure VM

    将“备份管理类型”选择为“Azure VM 中的工作负载”

  • 在“受保护的服务器”中,选择要取消注册的实例。In Protected Servers, select the instance to unregister. 若要删除保管库,必须取消注册所有服务器/实例。To delete the vault, you must unregister all servers/ instances.

  • 右键单击受保护的实例,然后选择“取消注册”。Right-click the protected instance and select Unregister.

    选择“取消注册”

在 SAP HANA 服务器 VM 上重新注册扩展Re-register extension on the SAP HANA server VM

有时,VM 上的工作负载扩展可能会由于某种原因而受到影响。Sometimes the workload extension on the VM may get impacted for one reason or another. 在这些情况下,在 VM 上触发的所有操作都将开始失败。In such cases, all the operations triggered on the VM will begin to fail. 然后,你可能需要在 VM 上重新注册该扩展。You may then need to re-register the extension on the VM. 重新注册操作会重新安装 VM 上的工作负载备份扩展,以便继续操作。Re-register operation reinstalls the workload backup extension on the VM for operations to continue.

请谨慎使用此选项:当在具有正常扩展的 VM 上触发时,此操作将导致扩展重新启动。Use this option with caution: when triggered on a VM with an already healthy extension, this operation will cause the extension to get restarted. 这可能会导致所有正在进行的作业失败。This may cause all the in-progress jobs to fail. 在触发重新注册操作之前,请检查是否存在一种或多种症状Check for one or more of the symptoms before triggering the re-register operation.

后续步骤Next steps