This discussion is archived
1 Reply Latest reply: Oct 18, 2012 8:09 AM by Sunthar Tharmalingam RSS

Restoring a 'noisy' database?

962811 Newbie
Currently Being Moderated
Hi, i'm fairly new to oracle and i need to restore a production database for testing in my development environnement. This database has jobs running, fax and emails are sent frequently and reports are running. I only have access to the backup. What should i consider when restoring? Is there a way to shut down everything during the restore? Can i set the JOB_QUEUE_PROCESSES to 0 and wait for the running jobs to stop?

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points