Trying to restore a backup to a different host (both host SPS9 97)

[former_member221487]

RECOVER DATA finished with error:

recovery could not be completed, volume 0, reached log position 0,

Cannot open file ""<root>/COMPLETE_DATA_BACKUP_POST_SFIN2_databackup__databackup_0_1" ((mode= R, access= rw-r-----, flags= DIRECT|MUST_EXIST|MULTI_WRITERS|UNALIGNED_SIZE), factory= (root= "/tmp/backup/" (access= rw-r-----, flags= <none>, usage= DATA_BACKUP, fs= ext3, config= (async_write_submit_active=auto,async_write_submit_blocks=new,async_read_submit=off,num_submit_queues=1,num_completion_queues=1,size_kernel_io_queue=512,max_parallel_io_requests=64))", rc=2: No such file or directory

Copied the contents of the ‘log’ dir across (this contains the catalogfile /hana/shared/DEV/HDB00/backup/log/log_backup_0_0_0_0.1437813250295) even though we shouldn’t really need this!

Size of indexserver backup files is not the same

host2

-rw-r----- 1 devadm sapsys 67646439424 Jul 28 07:11 COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_3_1

Host1

-rw-r----- 1 devadm sapsys 78189035520 Jul 25 09:34 COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_3_1

Hdbbackupdiag (from log dir on host1)

host1:/usr/sap/DEV/HDB00/backup/log> hdbbackupdiag

found backup catalog 1437813250295 from file /hana/shared/DEV/HDB00/backup/log/log_backup_0_0_0_0.1437813250295

using backup catalog 1437813250295 from file /hana/shared/DEV/HDB00/backup/log/log_backup_0_0_0_0.1437813250295

Data backup file: COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_0_1

RedoLogPosition: 0

Backup time: 2015-07-25T08:57:46+01:00

Data backup file: COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_1_1

RedoLogPosition: 790466

Backup time: 2015-07-25T08:57:46+01:00

Data backup file: COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_2_1

RedoLogPosition: 18332355

Backup time: 2015-07-25T08:57:46+01:00

Data backup file: COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_3_1

RedoLogPosition: 2318704130

Backup time: 2015-07-25T08:57:46+01:00

Checked backup on host2 and hdbbackupcheck failed

ERROR: [110061] The backup /hana/shared/DEV/HDB00/backup/data/COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_3_1 is corrupt, read 67646439424 bytes, expected at least 78189035520 bytes

ERROR: Backup '/hana/shared/DEV/HDB00/backup/data/COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_3_1' check failed.

Backup file is too small!

Scp’d index server backup across to host2 and the size of the backups is now the same - -rw-r----- 1 devadm sapsys 78189035520 Jul 25 09:34 COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_3_1

However, hdbbackupdiag still fails on host2, that is why it’s not being found in the studio I think

Hdbbackupcheck –v comes back good now:

Check backup content '[DATABASE_SNAPSHOT]@node[3]'.

Backup content '[DATABASE_SNAPSHOT]@node[3]' successfully checked.

Backup '/hana/shared/DEV/HDB00/backup/data/COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_3_1' successfully checked.

Hdbbackupcheck (from log dir on ehs59) returns the following though:

host2:/usr/sap/DEV/HDB00/backup/log> hdbbackupdiag

found backup catalog 1438098625240 from file /hana/shared/DEV/HDB00/backup/log/log_backup_0_0_0_0.1438098625108

using backup catalog 1438098625240 from file /hana/shared/DEV/HDB00/backup/log/log_backup_0_0_0_0.1438098625108

ERROR: [111013] No valid data backup has been found

Even when you tell it to look in the ~/data dir it still doesn’t find a ‘valid’ data backup

[Former Member · Accepted solution]

Cannot open file ""<root>/COMPLETE_DATA_BACKUP_POST_SFIN2_databackup__databackup_0_1"

From that I gather the entries you made in the HANA studio for recovery were wrong.

Instead of "<root>/COMPLETE_DATA_BACKUP_POST_SFIN2_databackup__databackup_0_1" you should see path and name of an actually existing backup file.

The double _databackup_ means you entered too much for the prefix. Try with COMPLETE_DATA_BACKUP_POST_SFIN2 only, instead of COMPLETE_DATA_BACKUP_POST_SFIN2_databackup_ .

Also make sure you enter the correct location. Is it really / ?

hope this helps

[former_member221487 · Accepted solution]

Thanks Josef...realised this last night when I refreshed the system using the system copy procedure via SWPM. Many thanks for your help!

[robert_camangon]

Hi Neil,

Can you please check if you have done the following?

1) mounted the location of the backup directories (data and log) you are trying to restore on the target system

2) checked permissions on the backup location to make sure that the target system's <sid>adm can access the folder and files

Those are the two most common steps missed when doing this and causes these types of errors.

Hope this helps.

Regards,

Robert