Error Log for startup

[Private_Member_19084]

Hi experts

I try some restore tests.
I've now deleted data files while ASE was running.

ASE was still up&running, was interessting.

I did restart and ASE was not any longer starting...for sure.

As I want to write down some scenarios, I tried to find the error why it is not starting.

I know it is the missing data file, but i want to to know how to get this knowledge in real case.

However, in startup log there is no helpful message.

In /install dir <SID>.log there is no entry while doing startsap/startdb.

Only in startdb.log I get an update, but really not helpful (see below).

So how can i analyze a startup-problem of ASE?

------------------------------ Fri Mar 27 12:41:08 CET 2015
LOGFILE FOR STARTING SYBASE ASE

starting database <SID> ...

------------------------------ Fri Mar 27 12:41:08 CET 2015
checking required environment variables

------------------------------ Fri Mar 27 12:41:08 CET 2015
check if Sybase ASE processes are running

ASE instance already running (pid of engine #0 is:  3123  )

------------------------------ Fri Mar 27 12:41:08 CET 2015
check if Sybase Backupserver is running

Backupserver instance already running (pid of backupserver is:  3123  )

[former_member187136 · Accepted solution]

Christian,

Good Day...!!!

It is really simple question, startdb or startsap are the SAP utilities hence there will be no entry in the Install/SID.log file.

If you really need to check the log entries do this exercise

a) Login to isql and run the below command

   1> shutdown with nowait

   2> go

b) Go to $SYBASE/ASE-15_0/install and run the below command in the UNIX prompt

    % startserver -f RUN_<SID> file

This will make entry in the install/SID log as this is correct DB level restart process

PS: While you are giving shutdown command make sure there are no application processes that are initatied from SAPSR3 is running else it becomes longgg time to bring server UP

Happy Testing

Regards

Kiran K Adharapuram

[former_member187136 · Accepted solution]

Christian,

Above same exercise for backup server as well

To Shutdown:

A) in isql should run the below command

1>shutdown SYB_BACKUP

2>go

To Start

Go to $SYBASE/ASE-15_0/install and run the below command @ Unix level

% startserver -f RUN_SID_BS

Cheers

Kiran K Adharapuram

[Private_Member_19084 · Accepted solution]

Thank you very much for your help.

I did also see, if I make an "online database" it gives me very useful information about the problem, why the db is not starting.

[former_member187136 · Accepted solution]

Christian,

There are lot of option which you can play around, for an example if you would wish to depricate(Supress) some of your messages which database is generating which you can do it from the error log by setting some customised option, also for any database troubleshooting mechanisms we always wish to see the information or message under database server error log and backup server log which is very useful.

Also if you run the backup or tran dump from cockpit/DB13 or from isql there will be entries in the backup server log with the % of completion(ex: Database <SID backed up 20% Complete,Database <SID backed up 40% Complete,Database <SID backed up 60% Complete.....)

Kindly have a look at Backup Server log as well, same path File Name: SID_BS.log

Regards

Kiran K Adharapuram