Livecache backup failuar

[Former Member]

Hi experts,

I am trying to take a complete backup of one of my livecache database from DBA planning calender. It is failing with below error.

MEDIANAME 'Pre_index_rebuild'
*** SAVE/RESTORE request accepted:
OK 

*** SAVE/RESTORE result:
ERR
-24988,ERR_SQL: SQL error
-903,Host file I/O error
3,Data backup failed
113,Open medium on /sapdb/LCA/sapdata/DISKD0006 for READ failed
1,Open file /sapdb/LCA/sapdata/DISKD0006 failed, open(READ,EXISTING) returned 'Too many open files' (24)

*** SAVE/RESTORE request:
SAVE DATA CANCEL
*** SAVE/RESTORE request accepted:
OK

*** SAVE/RESTORE result:
ERR
-24988,ERR_SQL: SQL error
-104,DBM command impossible at this time

*** DBA Action ends:
Timestamp: 20150829225656   State

I have tried by creating new media template but the result is same. I am not able to find much useful logs in livecache log files. Please suggest.

Thanks

Amar.

[Former Member]

Backup started running normally after system restart.

Thanks

Amar.

[former_member229109]

Hello Amar,

as you saw in the first your post:

"1,Open file /sapdb/LCA/sapdata/DISKD0006 failed, open(READ,EXISTING) returned 'Too many open files' (24)"

There were too many files opened by liveCache processes and the limit is reached, so after you restarted the liveCache the resources were released & you was able to create the backup.

- Need to check the xserver prt and dbmsrv prt of the liveCache

- Review the SAP note:628131 - SAP MaxDB/liveCache operating system parameters on UNIX

there is information/explain/recommendations on the parameters settings for "Maximum number of open files (maxfiles, nofiles)".

And SAP note, if liveCache is rinning on Solaris 10 and above:

724713

Parameter Settings for Oracle Solaris 10 and above

Regards, Natalia Khlopina

[former_member229109]

Hello,

- Review the hints in the SAP notes:

1879507 - MaxDB: shmat error, Too many open files

1659328 - Various problems with X server that is incorrectly started

- What is the version of the liveCache & OS platform of the liveCache server?

Best regards, Natalia Khlopina

[former_member188883]

Hi Amar,

Could you check the file limit configuration under /etc/security/limits.conf

You are experiencing error as the max limit for open files is reached.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Amar,

Can you paste the dbm.ebp & dbm.ebl files here too see exact error you can find those in your /sapdb/<SID>/data/wrk or /sapdb/data/wrk directory directory.

Regards,

Ram