SAP does not start after backup complition

[vat]

Dear All,

We are facing following problem some times after backup completion.

Our Setup is : SAP ECC 6, Oracle 10g, HP-UX 11.31.

We are scheduling the whole database offline + archive log backup during night.

After completion of backup the SAP does not start. I have checked the following things.

1. Database is started : OK.
2. SAP related services at O/S level : OK
3. Listener is OK
4. No startup log generated related to SAP

But I am not able to connect to SAP thru SAP GUI.

If I tried to start SAP using startsap it will not respond for long time. Even I have tried to startsap after shutting down database, kill all SAP related services at O/S level. But startsap doesn't respond.

When I restart the server, after that I am able to start SAP.

Is there any memory fragmentation related problem ?

Before some time same thing is happened with our production server, but at that time I have deleted Archivelog files manually before tacking backup. In this case if I take backup "whole database offline + archive log " then server doesn't start. At that time also I have to restart the server. So the Problem is identified.

But in this case i.e on our Quality Server not able to trace out problem.

Thanks in Advance,

Nirav

[Duncan Eric Ogonji_1]

Hi Nirav,
Allow me understand something. Are you on a cluster? How is your architecture?
When you use DB12, what error do you get? Could you check /saptrace/background or usertrace files for the errors.

Thanks.

Regards,
Duncan Eric Ogonji.

[vat]

Hi Duncan Eric Ogonji,

Thanks for your reply.

We are using Oracle 10g. I have checked log files at saptrace. There is not error message.

I am using BRTOOLS for taking backup and for archivelog I am using -sd option.

Is there any memory fragmentation problem ?

How Can we identified after backup process, whehter allocated memory segments are freed or not from O/S leval ?

Thanking you ones again,

Nirav

[Yogesh M Puranik]

Hi Nirav,

Many times it happens,that application doesn't start despite of everything is fine.

Well,this could be some check points,

1]First check out the application port ,listener port is running properly,and should not show closed/Time_out in netstat output.

2]Secondly many times it happens that number of connections hits the database crosses the max limit.

3]Some times after shutdown and startup of database the issue might resolved but some times it won't as from OS side, the memory segment of thease process remains there though process completed, which need refresh the OS.


Rgds
Yogesh

[Mel Burslan]

You did not answer the question if this is a clustered server or not but assuming it is QA, more than likely it is not.

when you issue the 'startsap' command, something MUST be written to the sap logs. my suggestion to you, before you run startsap command, open 3 other windows on the same server and run these 3 commands on each of them (one command per window)

tail -f sap.log #you need to figure out where this sap.log is
tail -f database.log #you need to figure out where this database.log is
tail -f /var/adm/syslog/syslog.log

after launching these commands, one per terminal window, on a 4th window, run startsap command and watch the scrolling log files. You are more than likely to figure out the issue on your own. If not, post your findings (like last 20 lines from each log) where the process froze, for further help

[vat]

Sorry, not reply in last mail.

It is not in cluster environment.

I have scheduled the backup on 24th Morning i.e. on Monday.

I will check all the logfiles.

I was checking saplog and database log.
It did not show any error messages. At that time database was running fine

Thanks,

Nirav

[Yogesh M Puranik]

Hi,

Your points are highly appritiated, which will encourage us to reply you next time.

Rgds
YMP