Skip to Main Content

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.

pastedImage_0.png

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.

pastedImage_1.png

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.

Comments

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.
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
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.
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
SITI
thank you for all.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 27 2018
Added on May 30 2018
1 comment
298 views