cancel
Showing results for 
Search instead for 
Did you mean: 

DB startup failed

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)