Database <SID> cannot be opened.An earlier attempt at recovery marked it 'suspect'.

[Former Member]

Hi Experts,

I have installed Solman 7.1 Support Release1 which is Running on Sybase 15.7.

I am facing this Issue "Database <SID> cannot be opened.An earlier attempt at recovery marked it 'suspect'. "

I have done updating the status using the below mentioned query Even its not coming up

update sysdatabases set status = status & ~256  where name="<SID>"

Can u pls help me.

Regards,

Jasmin

[manish_singh13]

Hi Jasmin,

Please check below SAP Note also and see if this helps:

2183109 - Error 926 database cannot be opened. An earlier attempt at recovery marked it suspect - ASE

Thanks,

Manish

[Former Member]

This message was moderated.

[kaus19d]

please be a bit more specific, by the meantime would ask you to follow,

Thanks,

Kaushik

[Former Member]

Hi Kaushik

Thank you for your Quick Reply

Because of Power failure Server got stopped. Again When I tried to work with DB (<SID>) it says

"Database <SID> cannot be opened.An earlier attempt at recovery marked it 'suspect'. "

SAP started already

Regards,

Jasmine

[kaus19d]

Hmmmm, I think till now you would have understood that now the database<SID> not opening because it can be from the below reasons:-

• Got corrupted security files due to crash, Hence recovery or repair option.
• Got locked as some other processes occupied the max login processes.
• Got totally locked, hence the OS login as database<SID> if not login taking can be resetted through the Domain Controller(Active Directory in caseof Linux/Windows). Once login through database<SID> at OS level, can be able to login to the database directly with out any issue.
• After all these, port to the database can be done pinging/telnet done to check status.

Thanks,

Kaushik

[kaus19d]

Hi ,

As you have mentioned that SAP has started already, then why do not you login @ OS level with Database<SID> & then you check, I am sure you would not be prompted for any other issues, you can run the required DB-commands in there to check also. Like,

With Isql :-

isql -U<Uname> -P<Passwd> -S<Server_Name> -D<DB Name> -X -w200

Also to start:-

startserver -f RUN_<dataserver_name>

Also you can bring online by the below command:-

online database "DBNAME"

Thanks,

Kaushik

[Former Member]

Hi

Thank u once again for your TIme and Response

Tried these too Though not coming up

Regards,

JAsmin