on 12-06-2010 6:30 PM
Dear SAP colleagues,
I do have a problem to restart my MaxDB database (version 7.7.06.10).
I wanted to deactivated the "redo log management".
I did it, then, I have stopped my database and when I wanted to restart, I get this error :
SQL error 9407, System error: unexpected error 3,
Database state : OFFLINE
Internal errorcode, Error code 6433 "system error"
Log - and data area are not compatible because 'Restart position not found'.
IOSequence 12092997 not in interval of 11503142 - 12091086 on the Log_Partition 1.
20028, Initialization of log for 'restart' failed with 'LogAndDataIncompatible'
It seems to miss one redo log file in my /sapdb/SID/saplog filesystem.
Do you have any idea how to fix this issue ?
I just want to restart my database, I do not want to restore or recover it.
It should be possible to restart it - now, the redo logs management is de-activated.
Thanks in advance for you input.
Best regards
SAP NetWeaverAdmin
Hello SAP NetWeaverAdmin,
1. If you are SAP customer =>
u2022 I recommend you to create the SAP message so we could check the database logs
before to give you solution steps for the reported problem.
u2022 Please review the SAP note:
869267 FAQ: SAP MaxDB LOG area
2. To fix the issue you could try the following steps:
Create the complete databackup in admin state first!
Connect to the database as dbm user, default u2013 control for SAP installations.
dbmcli -d <SID> -u control,<PWD>
dbmcli on <SID>>db_admin
dbmcli on <SID>>db_connect
dbmcli on <SID>>db_execute clear log
( when it will be done -> please run)
>exit
Try to restart the database online after that.
Thank you and best regards, Natalia Khlopina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sir,
Thank you very much for this solution. It solved my problem instantly.
But I just wanted to know the logic behind clearing log. Can you please update.
Thanks,
Sarang.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.