Re: [ADMIN] Index error on recovery

2011-12-22 Thread K P Manoj
Hi Could any one else give any pointers, or is there something obviously missing in this request / thread ?. Index "IND_tbl_1_ObjId" and "IND_tbl_1_Act_ObjId" are B-Tree Index. Thanks Manoj 2011/12/19 K P Manoj > No, all my index B-Tree Index > > Thanks > Manoj K P > > > 2011/12/18 杨晓青 > >>

Re: [ADMIN] Index error on recovery

2011-12-19 Thread K P Manoj
No, all my index B-Tree Index Thanks Manoj K P 2011/12/18 杨晓青 > is your index a hash index? xlog does not include the changes on hash > index,your must rebuild hash index after recovery from xlog. > > > 2011/12/16 K P Manoj > >> Hi >> >> The details given below is for a test server, that I br

Re: [ADMIN] Index error on recovery

2011-12-18 Thread 杨晓青
is your index a hash index? xlog does not include the changes on hash index,your must rebuild hash index after recovery from xlog. 2011/12/16 K P Manoj > Hi > > The details given below is for a test server, that I brought back up from > the base (after running a day worth wals and by giving re

[ADMIN] Index error on recovery

2011-12-16 Thread K P Manoj
Hi The details given below is for a test server, that I brought back up from the base (after running a day worth wals and by giving recovery_target_time before starting the recovery). The recovery went fine and the DB came online as expected. But I see that although trivial select queries seem to