OraFAQ Forum: Replication » Status of Refresh group to Broken

Home » Server Options » Replication » Status of Refresh group to Broken (Oracle 10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Status of Refresh group to Broken [message #336257]

Fri, 25 July 2008 07:46

harshkumar
Messages: 34
Registered: February 2008
Location: Delhi

Member

Hi All,

Can you please tell me, How to reset the status of Refresh Group?

In our database, it is showing the status of Refresh group to 'Broken'.

Thanks
Harsh

Report message to a moderator

Re: Status of Refresh group to Broken [message #336476 is a reply to message #336257]

Sun, 27 July 2008 12:35

harshkumar
Messages: 34
Registered: February 2008
Location: Delhi

Member

Hi Michel,

Can you please help me out?

Earlier the all the members of Refresh Group refresh automatically. But since the last one week it is not refreshing automatically and i have to refresh it manually. I checked and found the status of Refresh group 'Broken'. Now the issue is that, How to reset the flag so that it should refresh automatically.

Thanks
Harsh

Report message to a moderator

Re: Status of Refresh group to Broken [message #336678 is a reply to message #336476]

Mon, 28 July 2008 12:08

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

>>In our database, it is showing the status of Refresh group to 'Broken'.

1. Connect system user.
2. Find your JOB Id using DBA_JOBS.
3. Try this

Exec DBMS_JOB.BROKEN ( JOB-ID, False );

Commit;

Or,

Launch; Toad enable your jobs and then run.

Babu

[Updated on: Mon, 28 July 2008 12:23]

Report message to a moderator

Re: Status of Refresh group to Broken [message #336825 is a reply to message #336678]

Tue, 29 July 2008 02:53

harshkumar
Messages: 34
Registered: February 2008
Location: Delhi

Member

Hi Babu,

I run the command suggested by you and it changed the status back to Normal.

Thanks for your support.

Harsh

Report message to a moderator

Re: Status of Refresh group to Broken [message #336911 is a reply to message #336825]

Tue, 29 July 2008 05:52

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

Now replication working well; I mean data transfer going on ?

Babu

Report message to a moderator

Re: Status of Refresh group to Broken [message #337573 is a reply to message #336257]

Thu, 31 July 2008 05:12

harshkumar
Messages: 34
Registered: February 2008
Location: Delhi

Member

HiBabu,

Yes, Now the replication is working fine and data transfer is going on automatically.

Thanks for support.
Harsh

Report message to a moderator

Re: Status of Refresh group to Broken [message #337584 is a reply to message #337573]

Thu, 31 July 2008 05:40

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thanks for your information.

Babu

Report message to a moderator

Previous Topic:	ORA-00942: table or view does not exist
Next Topic:	ORA-00001: unique constraint violated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 23:18:10 CST 2025