Standby databases

Jobs are mostly defined in a normal primary database. There are reasons for desiring jobs to run in a standby database. Oracle 11g introduces the database roles for this purpose. In the database_role attribute of a job, we can specify when a job should run. Should it run when the database is run in the PRIMARY role, or should it run when the database runs in the LOGICAL STANDBY role? There is no option for the PHYSICAL STANDBY role. It is understandable that the PHYSICAL STANDBY role is not implemented. But at the same time there could be some valid reasons to still want jobs to run with the database in the PHYSICAL STANDBY role. That would, of course, be without the fancy logging, but what about the maintenance of the applied archives? This still has to be scheduled outside the database that needs this maintenance.

Creating jobs in a logical standby database

The job creation in DDL is not propagated to the logical standby database. However, you can create Scheduler jobs...