on 09-20-2016 8:14 AM
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
Hi Jasmin,
Please check below SAP Note also and see if this helps:
Thanks,
Manish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hmmmm, I think till now you would have understood that now the database<SID> not opening because it can be from the below reasons:-
Thanks,
Kaushik
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
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.