Skip to Content
0

How can I force log backup

Feb 13 at 03:11 PM

115

avatar image
Former Member

Hi

Question:

How can I force HANA to backup the log file with committed transactions now?

.

.

More info:

I can see in an old post someone asking why you need this. Here's one reason why.

In our environment, log backup destination path is a NAS filesystem. This file system is replicated at DR site. HANA configuration global.ini->Persistence: log_backup_timeout_s is set to 900 seconds (15 minutes). This mean that my recovery point objective (RPO) is 15 minutes. This represent the maximum data loss in a DR situation.

We are doing recovery test at our DR site. The application is executing transactions. I need to recover the HANA database with these transactions (no data loss). Waiting for the log_backup_timeout_s to occur is not acceptable. I would like for force log backup right after the application completed is last transaction.

Note: I am skipping some details, I understand that we can have replication for DR. I also understand that we can change the value of log_backup_timeout_s to a low value.

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Feb 15 at 11:20 PM
0

You can trigger a log backup via

hdbcons "log backup"

Not sure though how that helps you with a recovery scenario, where the application can continue to run transactions.

Also, since this relies on manual activity, you won't lower the RPO in case the first data centre goes dark.

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Lars

hdbcons seem to work only for SYSTEMDB. Is there a way to do this on a Tenant database?

My HANA version is 2.00.021.

Thanks

Sylvain

0

Why don’t you check the help for hdbcons a bit and connect to the indexserver process of the tenant DB?

0
Former Member

Hi

Thanks, you gave me a good hint on how to do this.

.

I was able to force the log backup on one of my systems. I am having issue with hdbcons command line on my second system. I think it is related to database_isolation set to high. But this is another issue...

.

Sylvain

0

Great! In that case don't hold back and close the question by selecting the best answer.

0