IDS Forum

Re: Yours on PANIC

Posted By: Jairo Gubler
Date: Friday, 9 September 2005, at 2:06 p.m.

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

IDS Forum is maintained by Administrator with WebBBS 5.12.