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)
- 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]
