Data Backup and Recovery

missing smsap schedule

lukasz_borek
2,827 Views

Had strange problem last day.


We are using smsap 3.0.3P1 and got problem witch schedule, which are not viable through smsap gui. But still valid in smsap database :


SQL> select SCHEDULENAME, HOSTNAME, state from repomanager.SMO_30_SCHEDULEDOPERATION;


SCHEDULENAME                   HOSTNAME                       STATE
------------------------------ ------------------------------ --------------------
P02_Daily_Backup_Schedule      hostname     SUSPENDED
P02_Hourly_Backup_Schedule_1   hostname      SUSPENDED
P02_Hourly_Backup_Schedule_2   hostname      SUSPENDED


but no any of above are sean in gui? Have anyone meet with similar issue? Any advice?

3 REPLIES 3

lukasz_borek
2,827 Views

Ok fixed...

Following 'have you tried turn it off & on againg..."   : smsap_server restart  fixed problem.

What a pitty I can't mark my answare as correct

thomas_glodde
2,827 Views

repo database needs to be available before smsap/oracle starts, might not be the case if both, user database as well as repository database are on the same filer; make sm sap/oracle depended on oracle services then.

lukasz_borek
2,827 Views

Yes, I'm aware of that. Smsap database is on separete server. But from time to time we got problem with missing schedule in gui. After re-bounce smsap_server deamon all back to normal :

#smsap_server restart

Thanks!

Public