Not able to bring livecache instance into online state

[former_member330338]

Hi Folks,

I am trying to do a livecache copy for our scm 4.0 ,from our production system into our dev.. I am following note 457425.

I have successfully restored the database using DB gui, and now the instance is in "ADMIN" mode, while bringing it up into "ONLINE" mode, it gives me the following error;

dbmcli on LCA>db_online

ERR

-24895,ERR_SHUTDOWN: shutdown of database occured

-71,connection broken server state 6

This is what the knldiag file contains,I have truncated most part of the file and showing only the last 30 lines or so..

2008-08-27 19:31:35 89 53000 OBJECT Restarted Garbage coll: 0

2008-08-27 19:31:35 89 54003 dynpool DYNP_K51_LOCK_LIST : 75531152

2008-08-27 19:31:35 89 54003 dynpool LOCK maxlocks : 300000

2008-08-27 19:31:35 89 54003 dynpool LOCK items : 902400

2008-08-27 19:31:35 89 54003 dynpool LOCK Regions : 24

2008-08-27 19:31:35 89 54003 dynpool LOCK TransRegions : 8

2008-08-27 19:31:35 89 54003 dynpool LOCK RegionGlob+Space : 3456

2008-08-27 19:31:35 89 54003 dynpool LOCK TransGlob : 768

2008-08-27 19:31:35 89 54003 dynpool LOCK SupplyItemsPerRgn : 100

2008-08-27 19:31:35 89 54003 dynpool LOCK SupplySize : 192000

2008-08-27 19:31:35 89 54003 dynpool LOCK RowHash entries : 300000

2008-08-27 19:31:35 89 54003 dynpool LOCK TabHash entries : 60000

2008-08-27 19:31:35 89 54003 dynpool LOCK Row+Tab hash size :2880000

2008-08-27 19:31:35 89 54003 dynpool LOCK Trans entries : 328

2008-08-27 19:31:35 89 54003 dynpool LOCK trans_list size : 73472

2008-08-27 19:31:35 89 54003 dynpool LOCK TransPtrList : 2624

2008-08-27 19:31:35 89 54003 dynpool LOCK TransHash entries : 328

2008-08-27 19:31:35 89 54003 dynpool LOCK TransHash size : 2688

2008-08-27 19:31:35 89 54003 dynpool LOCK SupplyPoolSegments: 9000

2008-08-27 19:31:35 89 54003 dynpool LOCK SupplyPoolSize : 72216000

2008-08-27 19:31:35 89 54003 dynpool LOCK ObjColl_list size : 10496

2008-08-27 19:31:35 89 54003 dynpool LOCK ObjReq_list size : 5248

2008-08-27 19:31:35 89 ERR 20028 Log DBIdentifier of DataVolume (tpcscmpd:LCA_20061019_161059) and LogVolume (TPCSCMD

D:LCA_20060613_163702) does not mat

2008-08-27 19:31:35 89 ERR 20028 Log ch

2008-08-27 19:31:35 89 11000 vdetach '/sapdb/LCA/saplog/DISKL001' devno 3 T77

2008-08-27 19:31:35 11 12822 TASKING Thread 149 joining

2008-08-27 19:31:35 149 11566 stop DEVi stopped

2008-08-27 19:31:35 11 12822 TASKING Thread 150 joining

2008-08-27 19:31:35 150 11566 stop DEVi stopped

2008-08-27 19:31:35 89 WNG 20026 Admin Initialization of log for 'restart' failed with 'LogAndDataIncompatible'

2008-08-27 19:31:35 89 20040 Admin Kernel state: 'OFFLINE' reached

2008-08-27 19:31:35 89 12696 DBSTATE Change DbState to 'SHUTDOWN'(25)

+++++++++++++++++++++++++++++++++++++++ Kernel Exit ++++++++++++++++++++++++++++

2008-08-27 19:31:35 0 12845 DBSTATE Kernel exited normal

2008-08-27 19:31:35 0 12808 DBSTATE Flushing knltrace pages

2008-08-27 19:31:36 0 11560 COMMUNIC Releasing T77

2008-08-27 19:31:36 0 12696 DBSTATE Change DbState to 'OFFLINE '(29)

Kindly help.

[markus_doehr2]

Did you do the system copy using

db_activate recover...

instead of

recover_start...

The first is needed to format the log before the restore.

Markus

[former_member330338]

Hi Markus,

Thanks for your reply.

I have done the recovery using database manager gui 7.5 by using recovery option. Infact the log area was empty.

Regards

Vidyarthi

Edited by: Basis Support HP E-Services on Aug 27, 2008 2:35 PM

[markus_doehr2]

> I have done the recovery using database manager gui 7.5 by using recovery option. Infact the log area was empty.

Yes - it may have been empty but it was not formatted - thus the error message.

You can try (on command line/shell):

dbmcli -U c -uUTL util_execute clear log

and after that try to bring the DB online again.

Markus

[former_member330338]

Hi Markus,

Bingo!!!..it worked man!!. Thanks a ton!!

Regards

Vid