on 07-29-2015 12:20 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.