We have two hana 2.0 system hosts:
1) source host for backup: BK1
2) target host for recovery: BK2
Everytime we need to use all the backup (data & logs) on BK1 to recovery on BK2 for test, thus there would be a problem on BK2 itself, that is, BK2 would also generate its own local logs....
So how to recovery database logs on BK2 only with the source BK1 logs ?
hdbsql SYSTEMDB=>
hdbsql SYSTEMDB=>
hdbsql SYSTEMDB=> RECOVER DATABASE FOR BK2 UNTIL TIMESTAMP '2020-07-02 08:26:59' USING DATA PATH ('/hana/BK1_bakdata/') USING LOG PATH ('/hana/BK1_baklog/');
* 448: recovery could not be completed: [2000004] Cannot open file ""<root>/log_backup_2_0_7992832_7992960.1593633407981" ((closed, mode= R, access= rw-r-----, flags= ASYNC|DIRECT|MUST_EXIST|UNALIGNED_SIZE), factory= (root= "/hana/BK1_baklog" (access= rw-r-----, flags= AUTOCREATE_PATH|DISKFULL_ERROR, usage= LOG_BACKUP, fs= UNSUPPORTED (btrfs), config= (async_write_submit_active=on,async_write_submit_blocks=all,async_read_submit=on,num_submit_queues=1,num_completion_queues=1, size_kernel_io_queue=512,max_parallel_io_requests=64,min_submit_batch_size=16,max_submit_batch_size=64))", rc=2: No such file or directory SQLSTATE: HY000
hdbsql SYSTEMDB=>
hdbsql SYSTEMDB=>