oracle rac 停实例,停RAC两个节点中的一个实例，此实例上正在运行的JOB会不会切换到另外一个实例上继续运...

本帖最后由 java3344520 于 2012-8-18 02:28 编辑

可以的，兄弟，不好意思，看了看官方文档，有如下解释：

you can create a job at the cluster database level and the job will run on any active instance of the target Oracle RAC database. Or you can create a job at the instance level and the job will only run on the specific instance for which you created it. In the event of a failure, recurring jobs can run on a surviving instance.

Each RAC instance has its own job coordinator. The database monitoring checks that determine whether or not to start the job coordinator do take the service affinity of jobs into account. For example, if there is only one job scheduled in the near future and the job class to which this job belongs has service affinity for only two out of the four RAC instances, only the job coordinators for those two instances will be started.

官方比较清晰的解释了JOB运行的机制和失败后的调度机制处理方式。