Skip to Content
0
Jul 03, 2020 at 04:36 AM

How to recovery database logs only with the source backup logs ?

612 Views

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=>