You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@jackrabbit.apache.org by "Andrea K." <ak...@alteanet.it> on 2007/06/15 11:02:09 UTC

Cluster Journal on Oracle DB

Hi all,
I'm using JR within a clustered app in Oracle DBD 10g.
A question: the journal table is automatically archived or there's a way to
archive 'old' records?

Thanks in advance.
Bye,
Andrea - 
-- 
View this message in context: http://www.nabble.com/Cluster-Journal-on-Oracle-DB-tf3926592.html#a11135600
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: Cluster Journal on Oracle DB

Posted by "Andrea K." <ak...@alteanet.it>.

Hi Dominique,
just another question.

 If I have:
 1. A clustered app
 2. 2 servers on the cluster with indexes aligned up to revision X

 Can I do this?
 1. Stop the 2 servers
 2. Delete each revision.log
 3. Purge Cluster Journal tables
 4. Start servers 

 Indexes will be recalculated or not? I think no..

 What do you think about?

 Thanks.
 Bye.
 Andre -

-- 
View this message in context: http://www.nabble.com/Cluster-Journal-on-Oracle-DB-tf3926592.html#a13207937
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: Cluster Journal on Oracle DB

Posted by "Andrea K." <ak...@alteanet.it>.

Great, all as I supposed to be.
Thanks a lot Dominique.

BR
Andrea -


Dominique Pfister wrote:
> 
> Hi Andrea,
> 
> Indexes should be rebuilt on startup (Marcel, please correct me, if
> I'm wrong). If the cluster journal is file-based you have to delete
> the journal files AND the revision files in the repository cluster
> nodes (usually located in <rep-home>/repository/revision). If the
> journal is in a database, you can safely delete all records in the
> journal table.
> 
> Kind regards
> Dominique
> 
> On 18/09/2007, Andrea K. <ak...@alteanet.it> wrote:
>>
>> Hi Dominique,
>> just a question.
>>
>> If I have:
>> 1. A clustered app
>> 2. 2 servers on the cluster
>>
>> Can I do this?
>> 1. Stop the 2 servers
>> 2. Delete indexes
>> 3. Purge Cluster Journal
>> 4. Start servers and full reindex them
>>
>> Do you see any worries about that action?
>>
>> Thanks.
>> Bye.
>> Andre -
>> --
>> View this message in context:
>> http://www.nabble.com/Cluster-Journal-on-Oracle-DB-tf3926592.html#a12753624
>> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/Cluster-Journal-on-Oracle-DB-tf3926592.html#a12754089
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: Cluster Journal on Oracle DB

Posted by Dominique Pfister <do...@day.com>.

Hi Andrea,

Indexes should be rebuilt on startup (Marcel, please correct me, if
I'm wrong). If the cluster journal is file-based you have to delete
the journal files AND the revision files in the repository cluster
nodes (usually located in <rep-home>/repository/revision). If the
journal is in a database, you can safely delete all records in the
journal table.

Kind regards
Dominique

On 18/09/2007, Andrea K. <ak...@alteanet.it> wrote:
>
> Hi Dominique,
> just a question.
>
> If I have:
> 1. A clustered app
> 2. 2 servers on the cluster
>
> Can I do this?
> 1. Stop the 2 servers
> 2. Delete indexes
> 3. Purge Cluster Journal
> 4. Start servers and full reindex them
>
> Do you see any worries about that action?
>
> Thanks.
> Bye.
> Andre -
> --
> View this message in context: http://www.nabble.com/Cluster-Journal-on-Oracle-DB-tf3926592.html#a12753624
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>

Re: Cluster Journal on Oracle DB

Posted by "Andrea K." <ak...@alteanet.it>.

Hi Dominique,
just a question.

If I have:
1. A clustered app
2. 2 servers on the cluster

Can I do this?
1. Stop the 2 servers
2. Delete indexes
3. Purge Cluster Journal
4. Start servers and full reindex them

Do you see any worries about that action?

Thanks.
Bye.
Andre -
-- 
View this message in context: http://www.nabble.com/Cluster-Journal-on-Oracle-DB-tf3926592.html#a12753624
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: Cluster Journal on Oracle DB

Posted by Dominique Pfister <do...@day.com>.

Hi Andrea,

Currently, the journal table is not archived. This allows to add new
nodes to the cluster that process all changes found in the journal
table and in that way automatically synchronize to the other nodes'
state on startup.

Kind regards
Dominique

On 6/15/07, Andrea K. <ak...@alteanet.it> wrote:
>
> Hi all,
> I'm using JR within a clustered app in Oracle DBD 10g.
> A question: the journal table is automatically archived or there's a way to
> archive 'old' records?
>
> Thanks in advance.
> Bye,
> Andrea -
> --
> View this message in context: http://www.nabble.com/Cluster-Journal-on-Oracle-DB-tf3926592.html#a11135600
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>