If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

ALTER SYSTEM SET job_queue_processes=0

Hi-

I am using 9.2.0.7 standard edition for primary as well as standby databases. Every time when I complete the recovery and start the standby DB I have observed something different in the alert log. Here is some part from my alert log.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

It's not managed standby. I manually recover the standby once in every day and put it in read only for users.

Thanks,

is it a scheduled job? or every day you will do it manually?
sorry why i asked is if you made some script for doing that job and by mistake it is scheduled for every minute in the place of every day...it will happen or not?

well, it's a shell script which actually runs for every 30 minutes between 2am - 4am every day. In case if the business need refresh we will kick off the same script manually (that's what i did today).

Thanks,

Vijay Tummala

Try hard to get what you like OR you will be forced to like what you get.