How to Backup SAP HANA Database using Command Line

Login to SAP HANA Server. First we need to connect to SAP HANA server using Linux clients (eg: putty) with root user.
Switch to SAPHANA Admin User. Now we need to switch to SAP HANA admin user using following command. ...
Start HDB SQL Prompt. ...
Connect to Database instance. ...
Execute Following Command to Backup.

How do I backup my SAP HANA database?
How do I backup a database in SAP?
How do I backup configuration files in Hana?
What is Delta backup in Hana?
How do I trigger Hana backup from OS level?
What is full backup in Hana?
What is Backint in SAP HANA?
How do I check my Hana backup?
What is Backint?
How do I change the backup location in Hana studio?
How do I schedule a backup in Hana studio?
How do I backup my configuration files?

How do I backup my SAP HANA database?

To perform Backint backup with SAP HANA Studio, do the following:

In SAP HANA Studio, connect to the database as a user with DATABASE ADMIN privileges.
In the Systems view, right-click the database.
Select Backup and Recovery and then select Back Up System Database or Back Up Tenant Database.

How do I backup a database in SAP?

Solution

Install the Backup Exec Agent for Oracle on the Backup Exec server.
Install the Backup Exec Agent for Windows on the SAP database server. ...
On the Backup and Restore tab, right-click the SAP database server.
On the Backup menu, select the backup option to use.

How do I backup configuration files in Hana?

Backint backs up the database using a third-party backup tool. Each SAP HANA service starts the Backint agent and sends the backup data to the third-party backup tool. Note The Backint option is only available if a third-party backup tool is installed. Specify the destination for log backups.

What is Delta backup in Hana?

Starting with SPS 10 delta backups were introduced, this feature allows users to perform backup and recoveries quicker. Delta backups only capture the data changed since the last backup or delta backup, meaning less log backups are read for a recovery.

How do I trigger Hana backup from OS level?

How to Backup SAP HANA Database using Command Line

Login to SAP HANA Server. First we need to connect to SAP HANA server using Linux clients (eg: putty) with root user.
Switch to SAPHANA Admin User. Now we need to switch to SAP HANA admin user using following command. ...
Start HDB SQL Prompt. ...
Connect to Database instance. ...
Execute Following Command to Backup.

What is full backup in Hana?

SAP HANA full backups include all of the database volumes on each node. Before You Begin. Configure a SAP HANA pseudo client. The database must be online and all services must be running.

What is Backint in SAP HANA?

Backint for SAP HANA is an API that enables 3rd party tool vendors to directly connect their backup agents to the SAP HANA database. ... You can execute the following actions directly from SAP HANA's tools: Backup and recovery. Housekeeping (deleting old backups)

How do I check my Hana backup?

Check Individual Backups Inside an SAP HANA Installation

Identify the parts of the data backup that you want to check. In SAP HANA studio, open the Backup Console. ...
Make a note of the following information: File name (Location) ...
Call hdbbackupcheck using the appropriate values for each part of a data backup.

What is Backint?

Data Protection for SAP provides the BACKINT interface to run full online and offline backups of Oracle databases, control files, and redo log files. The BR*Tools utility BRBACKUP informs Oracle which data is to be backed up. ... It then places the database in the online or offline backup state.

How do I change the backup location in Hana studio?

To change the default destination for file-based data backups:

In SAP HANA studio, open the Backup Console for the system to be backed up.
Go to the Configuration tab.
In the File-Based Data Backup Settings area, specify the new default destination. ...
Save.

How do I schedule a backup in Hana studio?

Procedure

From SAP HANA cockpit, open the system overview of the SAP HANA database, for which you want to schedule a backup, and choose Manage database backups. ...
To display an overview of backup schedules, choose Go to Schedules. ...
To create a new backup schedule, choose Create Schedule.
Specify the backup type.

How do I backup my configuration files?

Use an FTP Server to Backup and Restore a Configuration

At the Router> prompt, issue the enable command, and provide the required password when prompted. ...
Configure the FTP username and password. ...
Copy the configuration to the FTP server. ...
Open the configuration file with a text editor.