Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB startup failed

Dear Friends,

I was changed LOGARCHMETH1 from OFF to DISK:/db2/<SID>/archlog & tried to restart the SAP instance by stopsap.

While running STARTSAP getting the below error

mmcprod:mmpadm 1> startsap

Checking db6 db Database

-


Database is not available via R3trans

Running /usr/sap/MMP/SYS/exe/run/startdb

05/30/2011 12:47:07 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

Activate database failed

R3trans connect failed

DB startup failed

Then I checked with db22start command

mmcprod:mmpadm 9> db2start

05/30/2011 12:53:20 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

mmcprod:mmpadm 10>

Then again tried to run startsap

mmcprod:mmpadm 10> startsap

Checking db6 db Database

-


Database is not available via R3trans

Running /usr/sap/MMP/SYS/exe/run/startdb

05/30/2011 12:53:53 0 0 SQL1026N The database manager is already active.

SQL1026N The database manager is already active.

Activate database failed

R3trans connect failed

DB startup failed

Kindly help me out on this.

Where I found the parameter file to reset the LOGARCHMETH1 again to OFF. Is it problem because of changing the parameter LOGARCHMETH1 in my case.

Thanks in advance.

Former Member
Former Member replied

Hello,

after setting the loging mode from circular to archiving the database is in backup pending.

Take a backup from your database, or change the state with db2dart.

best regards

Joachim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question