Reconnect broken chain

From: <eng_sok_peng_at_my-dejanews.com>
Date: Mon, 17 Aug 1998 03:59:58 GMT
Message-ID: <6r89ru$9u6$1@nnrp1.dejanews.com>

Hi,

I have a replicate(backup)server that needs to shutdown the database to do the backup.
So, whenever the server is shutdown, the chain between the two servers will be broken and i need to run this command below to reconnect the chain:

SQL> exec dbms_job.broken(84,false);

I need to write a script in the cron to automatically reconnect the chain after the database is startup. How should i do it??Will the value "..broken(84,false)" increase by one 'cos the current value is '85' when i do the command below:

SQL> select job,broken from dba_jobs;

JOB B
---------- -

        85 N
        84 N

Thanks,
Sok Peng

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Aug 16 1998 - 22:59:58 CDT