Eduardo Tortosa : > > Thanks again (completing information): > > - When i recover and i start i get: > > -24988 Sql erro [info STATE -d]; -4004; Unknown table name : > INFO_STATE > > - When i load system tables i get the following: > > > <Local>:BGESTA3> load_systab -u dba,supercau -ud supercau > ERR > -24964,ERR_EXECUTE: error in program execution > 3,""c:\sdb\7600\bin\x_python" "c:\sdb\7600\env\lsystab.py" -R > "c:\sdb\7600" -d BGESTA3 -u dba,*" > Removing obsolete objects > Installing Loader tables > Installing messages and help > Installing SYSDBA tables > Installing comments for SYSDBA tables > Installing precompiler tables > Installing system tables for R3 backup information > Installing ODBC tables > Installing system tables for ORACLE (V7) mode > Installing data dictionary tables and views > Installing synonyms for oracle system tables > Installing comments on oracle sytem tables > Installing tables for WebAgent > Installing tables for Repository > Installing DOMAIN tables > ---------Traceback--------------- > File "c:\sdb\7600\env\installib.py", line 410, in connectAndInstall > installRoutine (session, options) > File "c:\sdb\7600\env\lsystab.py", line 198, in install > "TRIGGER" > File "c:\sdb\7600\env\installib.py", line 172, in include > install (session, options) > File "c:\sdb\7600\env\XDD.py", line 1216, in install > createPubSynonym (session, 'ROLES') > File "c:\sdb\7600\env\XDD.py", line 165, in createPubSynonym > stopIfSqlNotOK (session, 'create public synonym "%s" for domain."%s"' > ---------Command----------------- > create public synonym "ROLES" for domain."ROLES" > ---------Error------------------- > loader.LoaderError: [-25010] SQL [-6000] Duplicate table name (error > position: 1) > >
Before trying to load systemtables, please do a Select * from synonyms where sysnonymname = 'ROLES' I think there is one, perhaps created by a user who is neither your sysdba nor DOMAIN. Please drop this public synonym and retry the load_systab. Elke SAP Labs Berlin > - The knldiag file contains : > > -------------------------------------------------------------------------- > ------ > Date Time TID(hex) Typ MsgID Label Message-Text > -------------------------------------------------------------------------- > ------ > 2006-03-10 18:57:43 0x1268 3 RunTime State changed from > STARTING to ADMIN > 2006-03-10 18:57:43 0x1268 19601 DBSTATE SERVERDB is ready > > ============================================ begin of write cycle > ================== > > > 2006-03-10 19:02:27 0x1260 19633 CONNECT Connect req. (T15, > Node:'', PID:5104) > 2006-03-10 19:02:27 0x1260 19615 VOLUMEIO Attaching volume > 'DAT_0001' > 2006-03-10 19:02:27 0xFFC 19613 DBSTATE I/O thread for > 'DAT_0001' started > 2006-03-10 19:02:27 0x1260 19617 VOLUMEIO Single I/O attach, > 'DAT_0001', UKT:7 > 2006-03-10 19:02:27 0x1260 19615 VOLUMEIO Attaching volume > 'DAT_0002' > 2006-03-10 19:02:27 0xD0C 19613 DBSTATE I/O thread for > 'DAT_0002' started > 2006-03-10 19:02:27 0x1260 19617 VOLUMEIO Single I/O attach, > 'DAT_0002', UKT:7 > 2006-03-10 19:02:27 0x1260 19615 VOLUMEIO Attaching volume > 'LOG_001' > 2006-03-10 19:02:27 0x124C 19613 DBSTATE I/O thread for > 'LOG_001' started > 2006-03-10 19:02:27 0x1260 19617 VOLUMEIO Single I/O attach, > 'LOG_001', UKT:7 > 2006-03-10 19:02:27 0x1260 20017 Pager Start Read Converter > 2006-03-10 19:02:27 0x1260 20018 Pager Stop Read Converter, > Pages: 8 IO: 8 > 2006-03-10 19:02:27 0x1260 53000 DATACACH Begin data cache restart > 2006-03-10 19:02:27 0x1260 54003 dynpool DATA_CACHE_REGIONS > : 8 > 2006-03-10 19:02:27 0x1260 54003 dynpool B20_DATACACHE_HEAD > : 79784 > 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE head num > item: 9973 > 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE head item > siz: 8 > 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE task queue > : 2272 > 2006-03-10 19:02:27 0x1260 54003 dynpool US + SV + DW + 8 > : 142 > 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE taskq elem > : 16 > 2006-03-10 19:02:27 0x1260 54003 dynpool B20_DATACACHE_TASKQ > : 82056 > 2006-03-10 19:02:27 0x1260 54003 dynDATA DATA_CACHE_PAGES > : 639 > 2006-03-10 19:02:27 0x1260 54003 dynpool B20_DATACACHE_CB > : 46008 > 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE num cblocks > : 639 > 2006-03-10 19:02:27 0x1260 54003 dynpool DATACACHE cblock size > : 72 > 2006-03-10 19:02:27 0x1260 54003 dynpool DYNP_B20_DATACACHE > :1024512 > 2006-03-10 19:02:27 0x1260 54003 dynDATA DYND_B20_DATACACHE > : 5112 > 2006-03-10 19:02:27 0x1260 53000 DATACACH Finish data cache > restart > 2006-03-10 19:02:27 0x1260 53000 B*TREE Blob file directory > restart successful > 2006-03-10 19:02:27 0x1260 7 FileDir File directory > restarting > 2006-03-10 19:02:27 0x1260 8 FileDir File directory restart > completed > 2006-03-10 19:02:27 0x1260 20061 Log History: 50 (50) files > existing > 2006-03-10 19:02:27 0x1260 20064 Log History: all history > files registered, GC is ready > 2006-03-10 19:02:27 0x1260 54003 dynpool DYNP_K51_LOCK_LIST > : 943376 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK maxlocks > : 3080 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK items > : 11700 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK Regions > : 24 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransRegions > : 8 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK RegionGlob+Space > : 3072 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransGlob > : 640 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK SupplyItemsPerRgn > : 100 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK SupplySize > : 172800 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK RowHash entries > : 3080 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TabHash entries > : 616 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK Row+Tab hash size > : 14976 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK Trans entries > : 312 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK trans_list size > : 59904 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransPtrList > : 1248 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransHash entries > : 312 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK TransHash size > : 1280 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK > SupplyPoolSegments: 93 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK SupplyPoolSize > : 671472 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK ObjColl_list size > : 9984 > 2006-03-10 19:02:27 0x1260 54003 dynpool LOCK ObjReq_list size > : 6240 > 2006-03-10 19:02:27 0x1260 20006 Log 1 queues, flushmode is > 'MaximizeSafety', devstate is 'HistoryLost' > 2006-03-10 19:02:27 0x1260 20007 Log Oldest not saved is > ioseq NIL @ off 1 > 2006-03-10 19:02:27 0x1260 20008 Log First known on > LogVolume is ioseq 0 @ off 1 > 2006-03-10 19:02:27 0x1260 20005 Log Restart from ioseq > 1191 @ off 535 to ioseq 1191 @ off 535 > 2006-03-10 19:02:27 0x1260 20010 Log Result after checking > the log device: 'Ok' > 2006-03-10 19:02:27 0x184 9 Log The number of active > logging-queues has been increased to 1 > 2006-03-10 19:02:27 0x1260 53000 OBJECT Restarted Garbage coll: > 0 > 2006-03-10 19:02:27 0xE30 7 Restart recovering log from > log_volume from IOSeq: '1191' > 2006-03-10 19:02:28 0xE30 20044 Log normal end of log > found at off 535 lastseq 1191. > 2006-03-10 19:02:28 0xE30 20012 Log > last-redo- > read#1:TR4294967295(525)[EMAIL PROTECTED]'SavepointEntry':20060310:185725 > 2006-03-10 19:02:28 0x1260 1 Savepoin Savepoint (Restart) > started by T15 > 2006-03-10 19:02:28 0x1260 31 SrvTasks Permanently reserved 1 > servertasks for 'Savepoint'. > 2006-03-10 19:02:28 0xE30 53000 OBJECT Stop active garbage > coll: 0 > 2006-03-10 19:02:28 0xE30 53000 OBJECT Garbage coll stopped: 0 > 2006-03-10 19:02:28 0xE30 20005 Pager SVP(1) Start Write Data > 2006-03-10 19:02:28 0xE30 20006 Pager SVP(1) Stop Data IO, > Pages: 50 IO: 22 > 2006-03-10 19:02:28 0xE30 20007 Pager SVP(2) Wait for last > task: 82 > 2006-03-10 19:02:28 0xE30 20008 Pager SVP(2) Stop Wait for > last task, Pages: 0 IO: 0 > 2006-03-10 19:02:28 0xE30 53070 SAVPOINT B20PREPARE_SVP: 527 > 2006-03-10 19:02:28 0xE30 53000 OBJECT Restarted Garbage coll: > 1 > 2006-03-10 19:02:28 0xE30 20009 Pager SVP(3) Start Write Data > 2006-03-10 19:02:29 0xE30 20010 Pager SVP(3) Stop Data IO, > Pages: 2 IO: 1 > 2006-03-10 19:02:29 0xE30 20011 Pager SVP(3) Start Write > Converter > 2006-03-10 19:02:29 0xE30 20012 Pager SVP(3) Stop Converter > IO, Pages: 8 IO: 8 > 2006-03-10 19:02:29 0xE30 53071 SAVPOINT B20SVP_COMPLETED: 527 > 2006-03-10 19:02:29 0x1260 20037 Admin Kernel state: 'REDO > LOG' finished > 2006-03-10 19:02:29 0x1260 54000 OBJECT c:\sdb\7600\pgm\liboms > 2006-03-10 19:02:29 0x1260 3 RunTime State changed from > ADMIN to ONLINE > 2006-03-10 19:02:29 0x1260 20217 RTE Used physical memory > 213 MByte > 2006-03-10 19:02:29 0x1260 20039 Admin Kernel state: 'ONLINE' > reached > 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T15 > 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T16, > Node:'', PID:5104) > 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T17, > Node:'', PID:5104) > 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T17 > 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T16 > 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T18, > Node:'', PID:5104) > 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T18 > 2006-03-10 19:02:29 0x1260 19633 CONNECT Connect req. (T19, > Node:'', PID:5104) > 2006-03-10 19:02:29 0x1260 19651 CONNECT Connection released, T19 > 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T20, > Node:'', PID:5104) > 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T21, > Node:'', PID:5104) > 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T21 > 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T20 > 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T22, > Node:'', PID:5104) > 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T22 > 2006-03-10 19:02:52 0x1260 19633 CONNECT Connect req. (T23, > Node:'', PID:5104) > 2006-03-10 19:02:52 0x1260 19651 CONNECT Connection released, T23 > 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T24, > Node:'', PID:5104) > 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T25, > Node:'', PID:5104) > 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T25 > 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T24 > 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T26, > Node:'', PID:5104) > 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T26 > 2006-03-10 19:03:12 0x1260 19633 CONNECT Connect req. (T27, > Node:'', PID:5104) > 2006-03-10 19:03:12 0x1260 19651 CONNECT Connection released, T27 > -------------------------------------------- current write position > ---------------- > > But i always get the message saying " .. Unknown table name: INFO_STATE > .." in dbmgui, and from SQLSTUDIO cannot access anything. > > > > > Döhr, Markus ICC-H escribió: > >> When i recover a 7.5.0.31 with initialization over a 7.6.0.16, the > >> database seems to be on-line but i always get an error > >> 'CANNOT FIND INFO_STATE' the database is unusable. > >> > > > > Did you load the system tables after the recover finished (on 7.6)? > > > > > >> If i recover without initialization i get messages saying > >> that more tasks are needed, but cannot recover neither the > >> log getting more error messages. > >> > > > > What'S the exact error message you're getting in knldiag? > > > > > > > > Greetz, > > > > SIEGENIA-AUBI KG > > Informationswesen > > > > i.A. > > > > Markus Döhr > > SAP-CC/BC, SAPDB-DBA > > > > Tel.: +49 6503 917-152 > > Fax: +49 6503 917-7152 > > E-Mail: [EMAIL PROTECTED] > > Internet: http://www.siegenia-aubi.com > > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
