We are going to discuss important topics in this blog that restoration of the HANA database. While restoring QAS, Sandbox, or training system with production system backup we need to take care of few but important points. That we will discuss in this blog.
Error :
we may get different error like
1: No Such file or directory
2: Missing authorization
3: unable to start name server.
Resolution:
We need to follow one few steps to restore database correctly
1: We copy file from Production server
a: By WinSCP tool
b: By by OS command SCP
We have to take care permission of copying files from Source to Target database server.
Basically, for the execution of the file, we need 755 permission of the file.
I suggest provide full permission to backup file, use below command
chmod 777 COMPLETE_DATA_BACKUP* --> to change permission of backup files.
or
we can see in below snap permission is 6-4-0, its default permission of backup files.
Note: giving full permission is worked in most case.
2: All take for the naming of backup files. Please refer below snap for your reference.
When we plan your restore or backup, we need to be familiar with the naming conventions and recommendations for data backups.
Each data backup name is comprised of the following elements
:<path><prefix>_<suffix>
During backup, each service backs up its data to the specified backup destination.
/backup/data/COMPLETE_DATA_BACKUP_databackup_0_1
/backup/data/COMPLETE_DATA_BACKUP_databackup_1_1
/backup/data/COMPLETE_DATA_BACKUP_databackup_2_1...
we can see
the <path> --- /backup/data/,
the <prefix> --- COMPLETE_DATA_BACKUP
the <suffix> --- databackup_0_1 and In the suffix, 0 is the volume ID, and 1 is the partition ID
which is automatically added by the system.
Note
The naming conventions apply to data backups created in the file system and data backups created using third-party tools. With third-party tools, you cannot change the backup path.
I will suggest to Rename backup files. as per recommendations for data backups. as shown below
if you meeting all the above pre-requisite then you can start to restore. It will run successfully
Rupesh Chavan