on 09-05-2014 2:34 AM
Hello experts,
I want to know that if there is any method to manually trigger HANA log backup (not just wait it full and time out to let it backup)
Thanks & Best Regards,
Tong Ning
Why would you want to do this?
And yes, technically possible but not supported through any documented interface.
There's no use case for that.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And there is your error ... right there ... "... like Oracle database ..."
Seriously: even on Oracle there hadn't been a need to manually trigger log backups in order to be able to fully recover since RMAN had been introduced many, many years ago.
But that's a different story.
For SAP HANA in order to be able to recover you don't need log backups.
Whenever you take a data backup, it will contain the consistent snapshot of the database like it was when the backup started.
- Lars
Hey Joydeep,
who's 'us'?
The 'us' that doesn't read the admin. guide?
Or the 'us' that reads more into my replies than what's really in them?
I wrote that no manual triggering of the log backup is required.
Nothing more, nothing less.
The typical use case for triggering log backups on Oracle was to perform what the BRTOOLS called a 'consistent backup'. If you just copied the Oracle data files away, the contents was inconsistent and a recovery was absolutely required to use this backup.
And this exact use case is simply not given with SAP HANA.
SAP HANA (just like MaxDB) always creates data backups that could be used without any log backups.
- Lars
Lars,
I would suggest to check your own thread once more..
What you have written: For SAP HANA in order to be able to recover you don't need log backups..
Do you think your above statement is correct?If so then please let ME know how I will perform the point in time recovery?Also recovery just before the database crashed without a log backup?
Regards,
Joydeep.
Seriously?
You want to pick a single sentence out of a complete reply and discuss this?
Well, go ahead as I won't.
Can you recover a SAP database backup without additional log backups? Yes, absolutely.
That's the point.
Did I write anything about all the different recovery scenarios that may apply? Nope.
Did I imply that generally SAP HANA doesn't use log backups to be enable inter-data-backup recovery? Nope, again.
Besides that: recovery to "just before the database crashed" is typically not done based on log backups but instead based on the most recent snapshot in the data volumes and the log information in the log volumes - the log backups are not required for that.
- Lars
Lars,
I picked up your sentence as the statement is contardiction to HA-200 Certification Guide-Section(Recovery)..
(A) Recover the database to its most recent state:
This option recovers the database to as close as possible to the current time.
This recovery option uses the following data:
• The most recent data backup
• Log backups made since the most recent data backup
• Log area
If Log backups are not required for Recovering the database to its most recent state:
then why SAP is saying that in certification guide?
Regards,
Joydeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tong,
I think we are really lucky that log backup can be taken automatically .
Make the log_backup_timeout_s--Less than 300 seconds..It will force the log backup at a fixed time interval before the log segment is full.
Regards,
Joydeep.
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 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.