Hello and welcome to the SAP HANA
Academy. My name is Denys van Kempen and
in this video tutorial series we will
discuss what's new with SAP HANA SPS 12.
The topic of this video tutorial is
Backup and Recovery. So what's new. We
have two major new features and two
enhancements. Major new feature is that
you can now scheduled backups using the
SAP HANA cockpit. Also new is that you
can resume a recovery that has been
interrupted. And then there are some
enhancements to the SAP HANA Cockpit
into the recovery process as a whole.
Brief overview of scheduling. To create
schedule in the SAP HANA Cockpit you
need the role SAP HANA backup roles
scheduler. Scheduling leverages the
XS job architecture. So you need to
have set this up first. For this you
would use the XS job dashboard which
is accessible from the SAP HANA XS
administration tool and to work with
this you need the SAP HANA XS admin
roles, job administrator. The job
administrator has to activate the XS
job scheduler and assign a user to the
job. We’ll take a look at that in a
moment. Resume recovery will speed up the
recovery process. If you have a full
backup and a number of Delta backups you
no longer need to restore this as a
whole. That should anything go wrong
during the recovery process you can
resume it in the intermediate faces. The
way it works is that during recovery SAP
HANA sets fallback point and so you can
resume a recovery from a certain
fallback point. For lock recovery this is
configurable in the global that ini file
with the lock recovery resume point
interval parameter. To visualize here we
have the difference between SPS 11,
previous release of SAP HANA and SPS
12. In 11 we did the data recovery in
the lock replay in one block using the
fallback points. In SPS 12 you can now
separate the delta backup recovery part
from the full backup recovery part and
do the lock replay at intervals. If
everything is working properly of course
probably won't benefit much from this
feature. But should
anything go wrong the fallback points
can significantly reduce the time to
recovery. Now you can recover a
database using the SAP HANA Studio or
on the console using SQL and you flag
the trigger a resume of the recovery is
the using region keywords in the recover
database statement. Below an excerpt of
the backup log and here we can see the
fallback points written to the log with
the timestamp. Let's take a look at a
live system to see how this works. I'm
connected here to the SAP HANA Cockpit
as a backup admin which has the
privileges to perform backups. Here we
have the backup tile indicating the last
successful backup selecting it will open
the backup catalog a minor enhancement
is that we can now select the prefix to
be displayed and if we create a new
backup. The estimated backup size is
displayed so if you switch between
incremental and complete you can see how
much space you need in your backup
destination. This was already available
on SAP HANA Studio and with SPS 12
this has been added to the Cockpit. You
can create a schedule using the create
schedule button here and view current
schedules in the go to schedules link.
When the XS job scheduler is not
active backups cannot be scheduled. So we
need to activate this first. As mentioned
for this we have the XS admin tool
and the XS job dashboard and here
you will need to enable the scheduler
for all jobs and assign a user to this
backup job. Set a password and save job.
Now I'm using here the same backup admin
as I'm connected to in production
system. Of course this would not make a
lot of sense. You would have a lower
privileged user to perform this task. If
I return out to my Cockpit and refresh
the message will have disappeared. So I
can create a schedule. In the backup
settings area I can select the backup
type complete, incremental, differential.
The destination type. If backupint would
have been configured I could have
selected this as well. Plus any
additional backup in parameter. The
prefix and a destination and then in the
backup schedule settings area
need to provide a unique scheduler name.
I will use Academy here. The start time
of the schedule and the recurrence. So
this could be weekly or monthly and you
can let the week start on Sunday or on
Monday. I will select here Monday. I want
to weekly backup on Monday, Tuesday,
Wednesday, Thursday and Friday. For
example hit midnight and I can then save
my schedule. Note that once I’ve created the
schedule I can either pause it or delete
it but it's no longer possible to modify
it. Okay concerning the recovery
enhancements there's not much to show
you except dimension parameter. Lock
recovery resume point interval which
defaults to 1800 and here you can set it
to a different value between 0 and
18,000. What's new for SAP HANA SPS 12
backup and recovery is documented in the
release note how to create backups and
how to perform a recovery and work with
the SAP HANA Cockpit is documented in
HANA administration guide. You can read
or download both guides free of charge
from the help portal on help.SAP
.com. Thank you for watching this SAP
HANA Academy video.