Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Sybase > help!!! db cannot be opened :(

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-25-03, 00:24
CuckooLai CuckooLai is offline
Registered User
 
Join Date: Feb 2003
Posts: 1
Question help!!! db cannot be opened :(

hi,all. I've encountered a problem of ASE12.0. If anyone knows how to resolve it ,give me a hand please! Detail info. is seen below.
Thank you very much.

Sincerely yours
CuckooLai


Running environment as following
AIX4.3.3, 2 server IBM M80 ,sharing a disk array and
there was HACMP installed to manage this cluster system. I've installed ASE12.0 both on those 2servers,every server has it's own
master db. But user database 'db_user' was installed on disk array.

Error description as following
On Feb 18,2003,we added memory to those M80,so cluster must be used. (Nomally,ASE is running on Server1,and the other applications are runnning on Serve2) When stopping Server1 and switching to Server2,
database 'db_user' could not be opened. (error log is following). However, when Server1 is staring and switching back to Server1,ASE was running ok and database 'db_user' was normal too.

Error log as following:

Error: 926, Severity: 14, State: 1
00:00000:00001:2003/02/18 02:59:18.42 server Database 'user_db' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.

00:00000:00001:2003/02/18 02:40:48.74 server Error: 806, Severity: 21, State: 1
00:00000:00001:2003/02/18 02:40:48.75 server Could not find virtual page for logical
page 3307563 in database 'user_db'.
00:00000:00001:2003/02/18 02:40:48.82 server Error: 3414, Severity: 21, State: 1
00:00000:00001:2003/02/18 02:40:48.82 server Database 'user_db' (dbid 4): Recovery
failed. Check the SQL Server errorlog for further information as to the cause.
__________________
Cuckoo
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On