Home » Server Options » Replication » Status of Refresh group to Broken (Oracle 10.2.0.2)
Status of Refresh group to Broken [message #336257] Fri, 25 July 2008 07:46 Go to next message
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
Re: Status of Refresh group to Broken [message #336476 is a reply to message #336257] Sun, 27 July 2008 12:35 Go to previous messageGo to next message
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
Re: Status of Refresh group to Broken [message #336678 is a reply to message #336476] Mon, 28 July 2008 12:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Status of Refresh group to Broken [message #336911 is a reply to message #336825] Tue, 29 July 2008 05:52 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

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

Babu
Re: Status of Refresh group to Broken [message #337573 is a reply to message #336257] Thu, 31 July 2008 05:12 Go to previous messageGo to next message
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
Re: Status of Refresh group to Broken [message #337584 is a reply to message #337573] Thu, 31 July 2008 05:40 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for your information.

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


Current Time: Thu Mar 28 05:21:41 CDT 2024