Deactivating Automatic log backup

[Former Member]

Hello All,

I have a query.

How can we check when automatic log backup of livecache log area has been deactivated. and Why?

Any log file registring this?

Thanks.

Regards,

Tushar

[Melanie · Accepted solution]

Hello Tushar,

the autosave will be deactivated, if you switch it off - then you'll find the corresponding command in file dbm.prt.

Another reason could be an error which occured while a logbackup was created - then you'll find the error message in file knldiag.err.

Regards,

Melanie

[Former Member · Accepted solution]

Hello Melanie,

Thanks a lot.

I checked dbm.prt file which does not mention autolog_off command means it has been deactivated by error.

So checked knldiag.err file, which mentioned the error:

========================================================

2007-11-11 06:08:47 156 ERR 11000 d0_aopen Cannot open device, Permission denied

2007-11-11 06:08:47 156 ERR 11000 d0_aopen Device name '/sapdb/OEM/lcbackup/log/<b>autolog.003'</b>

2007-11-11 06:08:47 83 ERR 1 Backup Backupmedium #1 (/sapdb/OEM/lcbackup/log/autolog.003) Could not open volume

2007-11-11 06:08:47 83 ERR 6 KernelCo + Backup error occured, Errorcode 3700 "hostfile_error"

2007-11-19 08:42:52 189 ERR 11000 d0_aopen Cannot open device, Permission denied

===========================================================

-rw-rw---- 1 oemadm sapsys 349765632 Jun 26 2006 autolog.002

-rw-rw---- 1 oemadm sapsys 57540608 Jul 21 10:58 <b>autolog.003</b>

===========================================================

I checked <b>autolog.003</b> file which has permission as owner (<livecache_sid>adm) and group sapsys.

It also has overwrite option as NO:

Corrosponding entries in the KNLDIAG file are :

=========================================================2007-11-11 06:08:43 28 12929 TASKING Task T5 started

2007-11-11 06:08:43 28 20018 Pager Start TaskId: 5

2007-11-11 06:08:43 28 20019 Pager First DataCacheSegment:31

2007-11-11 06:08:44 12 3 RunTime State changed from STARTING to ADMIN

2007-11-11 06:08:44 24 31 SrvTasks Permanently reserved 10 servertasks for <b>'Backup / Restore'</b>.

======================================= end of startup part ====================

2007-11-20 23:23:17 14 11561 COMMUNIC Connecting T95 local 29873

2007-11-20 23:23:17 118 12929 TASKING Task T95 started

2007-11-20 23:23:17 118 11007 COMMUNIC wait for connection T95

=========================================================

<b>So it owner:group is wrong or is it due to overwrite option?

What should be owner and group sdb:sdba for backup medium of file type?</b>

Thanks for your help.

Regards,

Tushar

Message was edited by:

Tushar Chavan

Message was edited by:

Tushar Chavan

[former_member229109 · Accepted solution]

Hello Tushar,

Security concept for the owner of the liveCache instance, it could be sdb by default,

is changed as of liveCache version 7.5 & it is described in the liveCache upgrade/installation guides.

< for SAP liveCache documentation see the SAP note 767598 >

< See info at "Special Operating System Users and Groups (UNIX/Linux)" link

http://maxdb.sap.com/currentdoc/23/cb4440eff00272e10000000a155106/content.htm >

-> Please update with additional information:

• What is the version of the database?

• Please run the following commands on the database server & update with outputs:

sdbregview -l

xinstinfo OEM

more /etc/opt/sdb

dbmcli -d OEM -u control,<pwd> medium_getall

-> The target directory of the log backups, /sapdb/OEM/lcbackup/log, should get a new user & group as of version 7.5 on Unix platforms.

As I wrote you, a new security concept was implemented, where the user 'sdb' and its group 'sdba' where introduced. The instance OEM may be using these as owner and group by default, check in /etc/opt/sdb file, and the backup directory should reflect

this, please change the owner:group to SdbOwner:SdbGroup < sdb:sdba by default >.

• "So it owner:group is wrong or is it due to overwrite option?"

You could not create the logbackup medium with overwrite option.

• When the /sapdb/OEM/lcbackup/log/autolog.003 was created?

Check the backup history.

• "What should be owner and group sdb:sdba for backup medium of file type?"

If the logbackup was created by liveCache the correct ownership should be setup.

As of liveCache version 7.5 or higher it should be owner:group as sdb:sdba by default.

If it was created before you upgraded the liveCache to the version 7.5 or higher, you don't need this log backup. During the version upgrade from the liveCache upgrade CD the liveCache is initialized & the backup history is lost.

See the SAP note :: 869267 FAQ: MaxDB LOG area

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello Natalia,

Thanks a lot. We created a new backup medium and it has owner as sdb and group as sdba.After this we activated the automatic log backup.

<b>Your reply is always helpful</b>.

Regards,

Tushar