Maxdb not starting after recovery - hung

[Former Member]

Hi all,

We have NW2004s and Maxdb on linux _86 system.

SP update terminated due to space requirement for db. I restored the db from back up and it went into restart mode. took a long time so cancelled it and tried starting the db using "startdb", but it gets hung at

<b>Trying to start database ...

Log file: /home/bw7adm/startdb.log</b>

the error in startdb.log is

Starting Database Instance...

OK

Opening Database...

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

20013,Admin command cannot enter critical state 'Redo'

6,Restart, Errorcode 6561 "dbm_command_not_possible"

-

---

Fri Oct 19 19:41:06 CEST 2007

Connect to the database to verify the database is now open

dbmcli check finished with return code: 0

Can anyone help me with this?

Thanks guys...

Regards

Hari

[Former Member]

Hi hari,

What's the status of your database? I hope you have fixed the problem

Thanks,

[Former Member]

Hi,

So basically when you do startsap from <sid>adm, database does not start.. even when you startdata base from ora<sid> it is not starting. The error log you sent, look like very complicated.

Create a message for SAP if you can..

Thanks,

[Former Member]

HI,

Recover your Database

Thanks,

[Former Member]

Hi

thanks for your suggestion..

now i mgetting the following error "disk not accessible"

this is the knldiag.err file text..

24976 ERR 11599 BTRACE -

---

> End of Stack Back Trace <----

2007-10-19 20:11:35 24976 ERR 7 Messages Begin of dump of registered messages

2007-10-19 20:11:35 24976 ERR 8 Messages End of the message list registry dump

2007-10-19 20:11:35 24976 ERR 11196 DBCRASH vabort:Emergency Shutdown, Task: 146

2007-10-19 20:11:52 0 ERR 12006 DBCRASH Kernel exited without core and exit status 0x200

2007-10-19 20:11:52 0 ERR 12010 DBCRASH Kernel exited exit code 2

2007-10-19 20:11:53 ___ Stopping GMT 2007-10-19 18:11:53 7.6.00 Build 028-123-126-876

2007-10-19 20:13:07 --- Starting GMT 2007-10-19 18:13:07 7.6.00 Build 028-123-126-876

2007-10-19 21:21:15 25862 ERR 11000 d0_vatta Cannot open volume, No such file or directory

2007-10-19 21:21:15 25862 ERR 11000 d0_vatta Volume name '/sapdb/BW7/saplog/DISKL001'

2007-10-19 21:21:15 25058 ERR 11000 vattach dev0_vattach returned FALSE

2007-10-19 21:21:15 25058 ERR 20027 IOMan Attach error on log volume 1: Could not open volume

2007-10-19 21:21:15 25058 ERR 3 Admin Database state: OFFLINE

2007-10-19 21:21:15 25058 ERR 6 KernelCo + Internal errorcode, Errorcode 9050 "disk_not_accessible"

2007-10-19 21:21:15 25058 ERR 20017 Admin + RestartFilesystem failed with 'I/O error'

2007-10-19 21:21:18 0 ERR 12009 DBCRASH Kernel exited due to signal 0(Killed after timeout with state SERVER_KILL)

2007-10-19 21:21:19 ___ Stopping GMT 2007-10-19 19:21:19 7.6.00 Build 028-123-126-876

2007-10-19 21:23:10 --- Starting GMT 2007-10-19 19:23:10 7.6.00 Build 028-123-126-876

2007-10-19 21:23:24 25999 ERR 11000 d0_vatta Cannot open volume, No such file or directory

2007-10-19 21:23:24 25999 ERR 11000 d0_vatta Volume name '/sapdb/BW7/saplog/DISKL001'

2007-10-19 21:23:24 25978 ERR 11000 vattach dev0_vattach returned FALSE

2007-10-19 21:23:24 25978 ERR 20027 IOMan Attach error on log volume 1: Could not open volume

2007-10-19 21:23:24 25978 ERR 3 Admin Database state: OFFLINE

2007-10-19 21:23:24 25978 ERR 6 KernelCo + Internal errorcode, Errorcode 9050 "disk_not_accessible"

2007-10-19 21:23:24 25978 ERR 20017 Admin + RestartFilesystem failed with 'I/O error'

2007-10-19 21:23:25 0 ERR 12009 DBCRASH Kernel exited due to signal 0(Killed after timeout with state SERVER_KILL)

Please let me know any options as i need to complete this in another one days time.

Thanks

Regards

Hari

[Former Member]

I think you have to activate db before recovery

Thanks

Prince Jose