Re: restoring database but need user jobs stopped
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Sun, 20 Dec 2009 16:04:09 -0800 (PST)
Message-ID: <1c1f673d-4da3-4f79-8362-fe738ee4fdb4_at_a32g2000yqm.googlegroups.com>
On Dec 20, 10:40 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "pradeep" <pkna..._at_gmail.com> a écrit dans le message de news: 037a2e01-8dd0-410b-b8f8-5fde26701..._at_b2g2000yqi.googlegroups.com...
> | Hi,
> | We need to recover some data from backup. Unfortunately, the
> | application has a job that purges old data. Is there a way to restore
> | from backup but have the jobs not run.
> |
> | Thanks
>
> set job_queue_processes to 0
>
> Regards
> Michel
Date: Sun, 20 Dec 2009 16:04:09 -0800 (PST)
Message-ID: <1c1f673d-4da3-4f79-8362-fe738ee4fdb4_at_a32g2000yqm.googlegroups.com>
On Dec 20, 10:40 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "pradeep" <pkna..._at_gmail.com> a écrit dans le message de news: 037a2e01-8dd0-410b-b8f8-5fde26701..._at_b2g2000yqi.googlegroups.com...
> | Hi,
> | We need to recover some data from backup. Unfortunately, the
> | application has a job that purges old data. Is there a way to restore
> | from backup but have the jobs not run.
> |
> | Thanks
>
> set job_queue_processes to 0
>
> Regards
> Michel
That will stop all jobs. You could, depending on Oracle version, use dbms_scheduler or dmbs_job to just diaable the job in question if the other tasks need to run. Also do not forget to reset the job_queue_processes back to what it was.
HTH -- Mark D Powell -- Received on Sun Dec 20 2009 - 18:04:09 CST