Re: Yours on PANIC

Thanks. ART KAGEL, BLOOMBERG/ 731 LEXIN escreveu: The database is off-line and fails every time I try to restart it. Two choices left: - Restore from archive (don't back up the current log it's obviously corrupted - that's what the iserr 105 is about) - Contact tech support and ask them to truncate the logical logs after the last valid record they can find then fast recovery will complete and the server will start up. Either way you're going to lose the last couple of transactions before the server went down. Do you know why it crashed in the first place (it was obviously not a normal shutdown or the logical log recovery would be zero pages restored not 64). Art Jairo ART KAGEL, BLOOMBERG/ 731 LEXIN escreveu: You can run the recommended oncheck -cI (actually I'd make that -cDI) but if the indexes are indeed corrupted do NOT let oncheck rebuild them, it's too slow. Instead manually drop the indexes and rebuild them using the parallel sort package (set PDQPRIORITY > 1, PSORT_NPROCS = 12 <more if you have lots of CPU VPs configured> and PSORT_DBTEMP = a list of 3 to 6 FILESYSTEMS not dbspaces each of which has enough freespace to hold the keys for sorting the largest index). Art S. Kagel -- Jairo Gubler Analista de Sistemas APL - IBD (Interfaces e Banco de Dados) DMGITRO TECNOLOGIA E-mail: jairo.gubler@digitro.com.br Fone:(48) 281 7213 Fax:(48) 281 7299 Site:www.digitro.com.br