Re: restoring database but need user jobs stopped

From: pradeep <pknayar_at_gmail.com>
Date: Mon, 21 Dec 2009 11:16:10 -0800 (PST)
Message-ID: <8088c27d-22b2-4791-a51f-b2beece5507b_at_o28g2000yqh.googlegroups.com>



On Dec 20, 7:04 pm, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> 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 --

Mark,
Thanks. Didn't need to do that this time around though, since I was restoring the production backups to a test server only to extract the lost data and have since restored the test database back.

Pradeep Received on Mon Dec 21 2009 - 13:16:10 CST

Original text of this message