Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

restoring database but need user jobs stopped

1 view
Skip to first unread message

pradeep

unread,
Dec 20, 2009, 10:34:05 AM12/20/09
to
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

Michel Cadot

unread,
Dec 20, 2009, 10:40:44 AM12/20/09
to

"pradeep" <pkn...@gmail.com> a �crit dans le message de news: 037a2e01-8dd0-410b...@b2g2000yqi.googlegroups.com...

set job_queue_processes to 0

Regards
Michel


pradeep

unread,
Dec 20, 2009, 12:39:40 PM12/20/09
to
On Dec 20, 10:40 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "pradeep" <pkna...@gmail.com> a écrit dans le message de news: 037a2e01-8dd0-410b-b8f8-5fde26701...@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

Thanks Michel.

pradeep

unread,
Dec 20, 2009, 1:07:25 PM12/20/09
to
On Dec 20, 10:40 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "pradeep" <pkna...@gmail.com> a écrit dans le message de news: 037a2e01-8dd0-410b-b8f8-5fde26701...@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

Thanks Michel.

Mark D Powell

unread,
Dec 20, 2009, 7:04:09 PM12/20/09
to
On Dec 20, 10:40 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "pradeep" <pkna...@gmail.com> a écrit dans le message de news: 037a2e01-8dd0-410b-b8f8-5fde26701...@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 --

pradeep

unread,
Dec 21, 2009, 2:16:10 PM12/21/09
to

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

0 new messages