HANA logs

[Former Member]

hi all, i am trying to understand what the following naming convention means in an HANA log (2_0_9504480896_9504514880.1411655163142)

    log_backup_2_0_9504480896_9504514880.1411655163142

    log_backup_0_0_0_0.1411655163169

    log_backup_1_0_49718592_49719744.1411655345573

    log_backup_0_0_0_0.1411655345585

    log_backup_4_0_5140864_5141696.1411656036420

    log_backup_0_0_0_0.1411656036437

    log_backup_3_0_2245360640_2245488896.1411656063236

    log_backup_2_0_9504514880_9504541888.1411656063177

also after a sucessfull backup how can we determine which logs would be needed for a point in time recovery .

Thank you

Jonu Joy

[lbreddemann]

The naming scheme is explained in the SAP HANA Administration Guide: 4.2.4.2.1 Log Backup Names ...

Just look it up there, ok?

The second question is ambiguous. What point in time do you want to recover to?

- Lars

[Former Member]

Thx Lars, so my second question was if i have a backup which completed today at 8:00AM and i would like to recover the HANA DB untill 11AM, how can we verify what logs would be needed after the backup finished to sucessfully recover the db till 11AM.

Thank you

Jonu Joy