Chinese

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!

Scheduler not working as expected

Shoeb KhanMay 30 2018 — edited May 30 2018

Hi There,

I am facing an issue in which the scheduler is not working as expected. The scheduled jobs are not getting launched properly. While checking a few things were identified that the job status in scheduler application is "Launched" launch status =10, while the same occurances are in done status when checked in WSJ.

Due to this the next schedule of the same job does gets submitted over the server.

Also noticed that the the Next submit date appears blank in the scheduler server properties.

Have tried resetting the server, changing the schedules, creating a new scheduled job, purging the jobs, changing the sleep time , job monitor time, bouncing the scheduler server. Still the issues persists. A couple of times the scheduler did started responding normally not sure what change caused it but after purging the jobs it again caused the same issue.

Request you to kindly share your inputs to resolve the issue.

KanchDev

Hi Jumbo,

You can consider an incremental rman backup from production database and recover DR database.

This method is available from 10g. otherwise you need to recreate the Standby database.

Cheers,
Kanchana.

1 person found this helpful

CKPT

If the DR is not functioning from last 6 months, According to database size you can rebuild standby database.

if the data difference is not so huge, You can perform incremental roll forward.

For 10g, refer this below link

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIAADC

1 person found this helpful

Shivananda Rao

As said, you can recreate the standby database if the size of the production database is quite less. If not, then make use of the incremental or rollforwarding method.

Refer this MOS ID *Steps to perform for Rolling forward a standby database using RMAN incremental backup when primary and standby are in ASM filesystem [ID 836986.1]*

SITI

Hi SRP,

DB status:

1.*No ASM storage.*

2.*oracle 9i.*

3.*Archive logs deleted on both Primary and Standby.*

my question:

1.without recreate standby.*is their any method to recover the standby database?*

Regards,
Jumbo.

Shivananda Rao

Since you have lost the archives on the primary database, it is not possible for you to recover your standby database.

The only option is to recreate it fully (if the size of the primary database is small) or to go with the roll forwarding method.

1 person found this helpful

Ganadeva

Hi,

Try this for 9i

Rolling a Standby Forward using an RMAN Incremental Backup in 9i [ID 290817.1]

Please let us know if this works...

Regards,
Ganadeva

1 person found this helpful

SITI

thank you for all.

1 - 7

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2018

Added on May 30 2018

#jd-edwards-chinese, #产品, #应用软件

1 comment

298 views

Chinese

Scheduler not working as expected

Comments

Post Details