cancel
Showing results for 
Search instead for 
Did you mean: 

MAXDB Recover

Former Member
0 Kudos

Hello.

I'm posting this because I ran out of ideas and google searches.

So my current problem is, I got a MaxDB server that was already in production because the person that was doing maintenance had to leave so I got it. So now I'm trying to clone a database instance (let's call it MAXDB1) to another machine that is going to be a test server.

I've tried doing a complete backup of MAXDB1 in the production machine and recover it on the test server, but sadly it always gives an error when I try to make it go online. I was wondering if I could get any pointers to any kind of documentation that shows me how to make this work or any other solution that could get the same result I currently need.

Production OS : Red Hat

Test OS : Kubuntu

MaxDB kerner Version : 7.7 on both machines.

Thank you

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

maybe documentation is what you looking for

http://maxdb.sap.com/doc/7_7/default.htm

Regards

Ivan

markus_doehr2
Active Contributor
0 Kudos

> I've tried doing a complete backup of MAXDB1 in the production machine and recover it on the test server, but sadly it always gives an error when I try to make it go online.

well - we would maybe be able to help you but how should we if you don't give us any information what kind of error you get? Unfortunately the Crystal Ball to look into is not yet invented (no offense)

Markus

Former Member
0 Kudos

Regarding the error, this is what I'm getting on the database manager GUI:

-24988 SQL error [db_online -f]; -31001, (no error text available from database kernel)

This is what I get on the database errors file:

Thread 0x29D Task 108 2010-03-25 15:00:09 AdminMsg 0: 4BAB7A790052 0000 RST RESTART

Thread 0x29D Task 108 2010-03-25 15:00:10 AdminMsg 0: 4BAB7A7A0054 0000 RST RETURNCODE *1001;RESTART

Thread 0x29D Task 108 2010-03-25 15:00:12 ERR DBCRASH 11196: vabort:Emergency Shutdown, Kernel_Administration.cpp: 704

Thread 0x29D Task 108 2010-03-25 15:00:12 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=704

2010-03-25 15:00:12 ERR Admin 2: A fatal error caused EMERGENCY SHUTDOWN. core is written,_FILE=vgg999.cpp,_LINE=62

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


> Emergency stack backtrace <----

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Using 'x86 GCC frame trace' for stack tracing

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (0):0x091c1c60 [F0xa9838b18](0xa9838b40,0x0,0x9413e3a,0x9000389)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (1):0x0909bfc6 [F0xa9838c28](0x0,0x9728840,0xa9838c58,0x96b4b18)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (2):0x0909c01c [F0xa9838c48](0x9728840,0x1,0x1,0x16b4b18)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (3):0x09093e8d [F0xa9838c68](0x97290a0,0xa983ce60,0x1,0x9401de8)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (4):0x08fb95fe [F0xa9838c98](0xa983ce60,0xa9838d30,0x93fb248,0x93fae28)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (5):0x08f538ee [F0xa9838d98](0xb738aa70,0xa9838e60,0x1,0x1)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (6):0x08a4a899 [F0xa9838ec8](0x1,0x2,0x48,0xa9838f30)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (7):0x085e9f18 [F0xa9839178](0xa98391ff,0x18d6,0x3,0xa98391f8)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (8):0x085ead25 [F0xa983b328](0xa983b8c0,0xa983b7f6,0xa983b34f,0x906de10)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (9):0x08f69b36 [F0xa983b778](0xa983b7f6,0x1,0xb736e360,0xa42362c8)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (10):0x08f69f88 [F0xa983cec8](0xb7518b40,0x2,0xa983cee8,0x9008bed)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (11):0x090498da [F0xa983cf98](0xb7518b40,0xb736e1e0,0xa983cfb8,0x0)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (12):0x09049c78 [F0xa983cfb8](0xb7518b40,0x942293f,0x0,0x96b4b18)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: (13):0x09158ae6 [F0xa983cfe8](0x0,0x0,0x307da,0x190004)

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


> Symbolic stack backtrace <----

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 0: ZN17RTEDiagCallStack18TraceStackSymbolicEPK19RTEDiag_RegisterSet + 0x43

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x091c1b53 (0x091c1b10+0x43) FP: 0xa9838b18

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa9838b40, 0x0, 0x9413e3a, 0x9000389

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 1: ZN22RTEKernelCrashHandler12AbortHandlerEP23RTEDiag_FaultDescriptorPv + 0x234

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x0909bfd4 (0x0909bda0+0x234) FP: 0xa9838c28

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x0, 0x9728840, 0xa9838c58, 0x96b4b18

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 2: ZN22RTEKernelCrashHandler5AbortEb + 0x3c

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x0909c01c (0x0909bfe0+0x3c) FP: 0xa9838c48

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x9728840, 0x1, 0x1, 0x16b4b18

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 3: ZN21RTEKernelTermination5AbortERK20SAPDBErr_MessageListb + 0x6d

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x09093e8d (0x09093e20+0x6d) FP: 0xa9838c68

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x97290a0, 0xa983ce60, 0x1, 0x9401de8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 4: Z9RTECrashRK20SAPDBErr_MessageList + 0xde

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08fb95fe (0x08fb9520+0xde) FP: 0xa9838c98

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa983ce60, 0xa9838d30, 0x93fb248, 0x93fae28

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 5: ZN21KernelAdministration7OfflineERK20SAPDBErr_MessageListbb + 0x49e

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08f538ee (0x08f53450+0x49e) FP: 0xa9838d98

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb738aa70, 0xa9838e60, 0x1, 0x1

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 6: gg999Abort + 0x269

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08a4a899 (0x08a4a630+0x269) FP: 0xa9838ec8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x1, 0x2, 0x48, 0xa9838f30

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 7: Z11ak93sendingR14SQLManContextiiR10tsp00_EnumI18tsp01_CommErr_EnumLi11EhE + 0x348

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x085e9f18 (0x085e9bd0+0x348) FP: 0xa9839178

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa98391ff, 0x18d6, 0x3, 0xa98391f8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 8: Z17a93user_commandsR14SQLMan_ContextRbS1_ + 0x405

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x085ead25 (0x085ea920+0x405) FP: 0xa983b328

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa983b8c0, 0xa983b7f6, 0xa983b34f, 0x906de10

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 9: Z7SQLTaskR14SQLManContextP22Kernel_DatabaseContextR13RTETask_ITaskRbb + 0x76

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08f69b36 (0x08f69ac0+0x76) FP: 0xa983b778

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xa983b7f6, 0x1, 0xb736e360, 0xa42362c8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 10: Z11KernelMainR13RTETask_ITask + 0x3b8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x08f69f88 (0x08f69bd0+0x3b8) FP: 0xa983cec8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb7518b40, 0x2, 0xa983cee8, 0x9008bed

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 11: ZN12RTETaskTask14KernelTaskMainEv + 0xaa

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x090498da (0x09049830+0xaa) FP: 0xa983cf98

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb7518b40, 0xb736e1e0, 0xa983cfb8, 0x0

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 12: ZN12RTETaskTask4MainERS_ + 0x68

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x09049c78 (0x09049c10+0x68) FP: 0xa983cfb8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0xb7518b40, 0x942293f, 0x0, 0x96b4b18

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: -


Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: 13: Z23en88CallKernelTaskMainv + 0xa6

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: SFrame: IP: 0x09158ae6 (0x09158a40+0xa6) FP: 0xa983cfe8

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Params: 0x0, 0x0, 0x307da, 0x190004

Thread 0x29D Task - 2010-03-25 15:00:14 ERR DIAG 0: Module: /opt/sdb/MAXDB1/pgm/kernel

Thread 0x29D Task - 2010-03-25 15:00:14 ERR Messages 7: Begin of dump of registered messages,_FILE=Msg_List.cpp,_LINE=3539

Thread 0x29D Task - 2010-03-25 15:00:12 ERR Admin 2: A fatal error caused EMERGENCY SHUTDOWN. core is written,_FILE=vgg999.cpp,_LINE=62

Thread 0x29D Task - 2010-03-25 15:00:12 ERR Admin 3: Database state: OFFLINE,_FILE=Kernel_Administration.cpp,_LINE=704

2010-03-25 15:00:12 ERR Admin 2: A fatal error caused EMERGENCY SHUTDOWN. core is written,_FILE=vgg999.cpp,_LINE=62

Thread 0x29D Task -Thread 0x29D Task - 2010-03-25 14:45:38 RTEHSS 13951: No hot standby node configured -> No HotStandby configuration

Thread 0x29D Task - 2010-03-25 15:00:14 ERR Messages 8: End of the message list registry dump,_FILE=Msg_List.cpp,_LINE=3567

Thread 0x29D Task - 2010-03-25 15:00:14 ERR AK CACHE 51105: DUMPING SESSION CATCACHE: 1

Thread 0x29B Task - 2010-03-25 15:00:15 ERR RTEKernel 102: Kernel exited without core and exit status 0x6,_FILE=RTEKernel_Termination.cpp,_LINE=634

Thread 0x29B Task - 2010-03-25 15:00:15 ERR RTEKernel 98: Kernel exited due to signal 6 (SIGABRT),_FILE=RTEKernel_Termination.cpp,_LINE=680

Thread 0x29B Task - 2010-03-25 15:00:15 MsgOutput 28: ___ Stopping GMT 2010-03-25 15:00:15 7.7.06 Build 009-121-202-944