Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schedule job in physical standby database

marceloTFeb 7 2020

Hi, i'm running oracle database 11gr2 on linux x86-64

I have configured a one rac primary database with 2 nodes, and one physical standby database in rac with 2 nodes.

Physical standby is opened read only.

I have created a schedule and a job on primary, when i check dba_scheduler_schedules, i see the schedule in both primary and standby, however when i check dba_scheduler_jobs i see the scheduled jobs in primary, and in standby view is empty.

Documentation is not very clear as it states "For a physical standby database, any changes made to Scheduler objects or any database changes made by Scheduler jobs on the primary database are applied to the physical standby like any other database changes." and then it states to set attribute but for logical standby.

What am I missing? Is it possible to have a job scheduled on primary and in physical standby?

thanks

Comments
Post Details
Added on Feb 7 2020
1 comment
1,986 views