on 05-30-2011 8:26 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.