cancel
Showing results for 
Search instead for 
Did you mean: 

Status code 6 and 199 (HELP NEEDED !!)

114
Level 4

Hi Team,

ORACLE database backup failed with error "Operation not allowed during this time period(199)"- (Child Streams) & Error Code 6(Parent Stream).

Job details :

Sep 29, 2020 12:59:10 AM - Info nbjm (pid=4849976) starting backup job (jobid=500484) for client dbRP1, policy DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1, schedule DBRP1_MON_FULL
Sep 29, 2020 12:59:10 AM - Info nbjm (pid=4849976) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=500484, request id:{E2339712-01C0-11EB-A860-033FBA4F0000})
Sep 29, 2020 12:59:10 AM - requesting resource  netback-hcart3-robot-tld-0
Sep 29, 2020 12:59:10 AM - requesting resource  netback.NBU_CLIENT.MAXJOBS.dbRP1
Sep 29, 2020 12:59:10 AM - requesting resource  netback.NBU_POLICY.MAXJOBS.DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1
Sep 29, 2020 12:59:10 AM - granted resource  netback.NBU_CLIENT.MAXJOBS.dbRP1
Sep 29, 2020 12:59:10 AM - granted resource  netback.NBU_POLICY.MAXJOBS.DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1
Sep 29, 2020 12:59:10 AM - granted resource  netback-hcart3-robot-tld-0
Sep 29, 2020 12:59:10 AM - estimated 2506473446 kbytes needed
Sep 29, 2020 12:59:10 AM - Info nbjm (pid=4849976) started backup (backupid=dbRP1_1601321350) job for client dbRP1, policy DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1, schedule DBRP1_MON_FULL on storage unit netback-hcart3-robot-tld-0
Sep 29, 2020 12:59:11 AM - started process bpbrm (pid=13566378)
Sep 29, 2020 12:59:16 AM - Info bpbrm (pid=13566378) dbRP1 is the host to backup data from
Sep 29, 2020 12:59:16 AM - Info bpbrm (pid=13566378) reading file list for client
Sep 29, 2020 12:59:17 AM - connecting
Sep 29, 2020 12:59:19 AM - Info bpbrm (pid=13566378) starting bphdb on client
Sep 29, 2020 12:59:19 AM - Info bphdb (pid=31326674) Backup started
Sep 29, 2020 12:59:19 AM - Info bphdb (pid=31326674) The script </usr/openv/netbackup/dbext/sap_oracle/sap_online_backup> has been approved to run and is stored locally.
Sep 29, 2020 12:59:19 AM - connected; connect time: 0:00:00
Sep 29, 2020 12:59:19 AM - Info bphdb (pid=31326674) Processing /usr/openv/netbackup/dbext/sap_oracle/sap_online_backup
Sep 29, 2020 12:59:19 AM - Info bphdb (pid=31326674) Waiting for the child status
Sep 29, 2020 2:47:20 AM - Error bpbrm (pid=13566378) from client dbRP1: ERR - Script exited with status = 5 <the restore failed to recover the requested files>
Sep 29, 2020 2:47:20 AM - Error bpbrm (pid=13566378) from client dbRP1: ERR - bphdb exit status = 6: the backup failed to back up the requested files
Sep 29, 2020 2:47:21 AM - Critical bpbrm (pid=13566378) unexpected termination of client dbRP1
Sep 29, 2020 2:47:23 AM - Info bphdb (pid=0) done. status: 6: the backup failed to back up the requested files
Sep 29, 2020 2:47:23 AM - end writing
the backup failed to back up the requested files  (6)

12 REPLIES 12

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified
Please refer to the netbackup documentation and other forums posts. This error is not unique and there are at least two references to it on vox (if you use the search bar above)

Hi RiaanBadenhorst,

 

Thanx for the reply. I already followed the posts but no luck.

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@114 

What does the backup policy look like?
Is this a traditional script-based backup?
How many schedules in the policy?
What are the backup windows in the schedules?

Hi

Please find the details;

What does the backup policy look like?- SAP (snapshot backup)
Is this a traditional script-based backup?- Yes
How many schedules in the policy? 10
What are the backup windows in the schedules? 22:00 - 08:00

Nicolai
Moderator
Moderator
Partner    VIP   

You need to team up with your SAP DBA, as you need to see the output from SAP's brbackup command.

For self study, this is a good place to start:

https://help.sap.com/viewer/3ef1b95cacbf4f77a066797285371bb9/118/en-US/4715f769a1ff6446e10000000a114...

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Is there an open schedule at the time the backup is running? Check which schedule is being used in the activity monitor and see if that schedule is open.

Nicolai
Moderator
Moderator
Partner    VIP   

To solve the "Operation not allowed during this time period", please ensure application backup schedules are "open" 24/7.

How is the script at the SAP host strated ?

Is the SAP server in the same timezone as the NBU environment? You will need to work with your DBA to check the script, as the below error messages are contradictory:

Sep 29, 2020 2:47:20 AM - Error bpbrm (pid=13566378) from client dbRP1: ERR - Script exited with status = 5 <the restore failed to recover the requested files>

Sep 29, 2020 2:47:23 AM - Info bphdb (pid=0) done. status: 6: the backup failed to back up the requested files

NetBackup is queueing up a backup job, but the logs indicate a failed restore. You need to review the bphdb logs from the client, and the bpbrm logs on the media server to have more insight to what's going on.

Also curious that you say it's an Oracle database, but the logs show SAP policy. Why not use the SAP policy type for a SAP database? Can you please provide the output of bppllist -policy DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1 -U?

Hi,

Thank you the responses.
But in my case backup will fail status code 199 on Tuesday Schedule (most of the time).

@ RiaanBadenhorst & Nicolai: application backup schedules is "open" from 22:00 to 08:00.

bppllist - DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1 -U


Schedule: DBRP1_FRI_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Friday, Week 1
Friday, Week 2
Friday, Week 3
Friday, Week 4
Friday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Friday 22:00:00 --> Saturday 08:00:00

Schedule: DBRP1_MON_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Monday, Week 1
Monday, Week 2
Monday, Week 3
Monday, Week 4
Monday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Monday 22:00:00 --> Tuesday 08:00:00

Schedule: DBRP1_SAT_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Saturday, Week 1
Saturday, Week 2
Saturday, Week 3
Saturday, Week 4
Saturday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Saturday 22:00:00 --> Sunday 08:00:00

Schedule: DBRP1_THU_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Thursday, Week 1
Thursday, Week 2
Thursday, Week 3
Thursday, Week 4
Thursday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Thursday 22:00:00 --> Friday 08:00:00

Schedule: DBRP1_TUE_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Tuesday, Week 1
Tuesday, Week 2
Tuesday, Week 3
Tuesday, Week 4
Tuesday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Tuesday 22:00:00 --> Wednesday 08:00:00

Schedule: DBRP1_WED_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Wednesday, Week 1
Wednesday, Week 2
Wednesday, Week 3
Wednesday, Week 4
Wednesday, Week 5
Excluded Dates----------
EXCLUDE DATE 0 - 04/01/2020
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Wednesday 22:00:00 --> Thursday 08:00:00

Schedule: DBRP1_FRI_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: FRI_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Friday 22:00:00 --> Saturday 08:00:00

Schedule: DBRP1_MON_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: MON_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Monday 22:00:00 --> Tuesday 08:00:00

Schedule: DBRP1_SAT_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: SAT_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Saturday 22:00:00 --> Sunday 08:00:00

Schedule: DBRP1_THU_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: THU_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Thursday 22:00:00 --> Friday 08:00:00

Schedule: DBRP1_TUE_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: TUE_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Tuesday 22:00:00 --> Wednesday 08:00:00

Schedule: DBRP1_WED_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: WED_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Wednesday 22:00:00 --> Thursday 08:00:00

 

Can't find the whats wrong in the Tuesday schedule.?

Hi,

Thank yoy for the responses...!!

In my case most of the time backup failed with status code 199 on Tuesday Schedule.

Application Backup Windows: 22:00:00 --> 08:00:00

 

netback2# bppllist DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1 -U
------------------------------------------------------------

Policy Name: DBRP1_SAP_ONLINE_SMB_FULL_BACKUP_1

Policy Type: SAP
Active: yes
Effective date: 05/13/2016 16:22:34
Mult. Data Streams: no
Client Encrypt: no
Checkpoint: no
Policy Priority: 0
Max Jobs/Policy: Unlimited
Disaster Recovery: 0
Collect BMR info: no
Residence: netback-hcart3-robot-tld-0
Volume Pool: DataStore
Server Group: *ANY*
Keyword: (none specified)
Data Classification: Platinum
Residence is Storage Lifecycle Policy: no
Application Discovery: no
Discovery Lifetime: 0 seconds
ASC Application and attributes: (none defined)

Granular Restore Info: no
Ignore Client Direct: no
Use Accelerator: no
HW/OS/Client: RS6000 AIX6 dbRP1

Include: /usr/openv/netbackup/dbext/sap_oracle/sap_online_backup

Schedule: DBRP1_YEARLY_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
SPECIFIC DATE 0 - 07/01/2020
No days of week entered
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 9 (infinity)
Residence is Storage Lifecycle Policy: 0
Daily Windows:

Schedule: DBRP1_YEARLY_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 9 (infinity)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: YEARLY_FULL_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:

Schedule: DBRP1_QUAT_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
SPECIFIC DATE 0 - 04/01/2020
SPECIFIC DATE 1 - 10/01/2020
No days of week entered
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 8 (1 year)
Residence is Storage Lifecycle Policy: 0
Daily Windows:

Schedule: DBRP1_QUAT_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 8 (1 year)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: QUARTERLY_FULL_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:

Schedule: DBRP1_MONTHLY_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
SPECIFIC DATE 0 - 03/01/2020
SPECIFIC DATE 1 - 05/01/2020
SPECIFIC DATE 2 - 09/01/2020
No days of week entered
Day 1 of month
Excluded Dates----------
EXCLUDE DATE 0 - 04/01/2020
EXCLUDE DATE 1 - 10/01/2020
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 5 (3 months)
Residence is Storage Lifecycle Policy: 0
Daily Windows:

Schedule: DBRP1_MONTHLY_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 5 (3 months)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: MONTHLY_FULL_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:

Schedule: DBRP1_SUN_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Sunday, Week 1
Sunday, Week 2
Sunday, Week 3
Sunday, Week 4
Sunday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 3 (1 month)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Sunday 22:00:00 --> Monday 08:00:00

Schedule: DBRP1_SUN_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 3 (1 month)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: SUN_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Sunday 22:00:00 --> Monday 08:00:00

Schedule: DBRP1_FRI_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Friday, Week 1
Friday, Week 2
Friday, Week 3
Friday, Week 4
Friday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Friday 22:00:00 --> Saturday 08:00:00

Schedule: DBRP1_MON_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Monday, Week 1
Monday, Week 2
Monday, Week 3
Monday, Week 4
Monday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Monday 22:00:00 --> Tuesday 08:00:00

Schedule: DBRP1_SAT_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Saturday, Week 1
Saturday, Week 2
Saturday, Week 3
Saturday, Week 4
Saturday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Saturday 22:00:00 --> Sunday 08:00:00

Schedule: DBRP1_THU_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Thursday, Week 1
Thursday, Week 2
Thursday, Week 3
Thursday, Week 4
Thursday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Thursday 22:00:00 --> Friday 08:00:00

Schedule: DBRP1_TUE_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Tuesday, Week 1
Tuesday, Week 2
Tuesday, Week 3
Tuesday, Week 4
Tuesday, Week 5
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
Day 1 of month excluded
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Tuesday 22:00:00 --> Wednesday 08:00:00

Schedule: DBRP1_WED_FULL
Type: Automatic Full Backup
Calendar sched: Enabled
Included Dates-----------
Wednesday, Week 1
Wednesday, Week 2
Wednesday, Week 3
Wednesday, Week 4
Wednesday, Week 5
Excluded Dates----------
EXCLUDE DATE 0 - 04/01/2020
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Wednesday 22:00:00 --> Thursday 08:00:00

Schedule: DBRP1_FRI_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: FRI_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Friday 22:00:00 --> Saturday 08:00:00

Schedule: DBRP1_MON_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: MON_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Monday 22:00:00 --> Tuesday 08:00:00

Schedule: DBRP1_SAT_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: SAT_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Saturday 22:00:00 --> Sunday 08:00:00

Schedule: DBRP1_THU_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: THU_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Thursday 22:00:00 --> Friday 08:00:00

Schedule: DBRP1_TUE_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: TUE_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Tuesday 22:00:00 --> Wednesday 08:00:00

Schedule: DBRP1_WED_FULL_DEF
Type: Application Backup
Excluded Dates----------
No specific exclude dates entered
No exclude days of week entered
PFI Recovery: 0
Maximum MPX: 1
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: WED_PRD
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Wednesday 22:00:00 --> Thursday 08:00:00

 

Can;t find anything wrong..!! 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@114 

Why are you trying to micro-manage to this level?

I can see that you have a different pool for each day of the week, and therefore schedules for each day of the week, but why do you feel that this is necessary?
If a backup is started after midnight on a Tuesday, should it use the Monday pool (when the backup window opened) or the Tuesday pool?
Does it really matter if all backups with the same retention go to the same pool?

Things get confusing when you try to micro-manage.

How do the SAP backup scrips know which schedules to use?
Is it hard-coded?

The backup failure that you showed us ran early hours (12:49) on Tuesday morning 29 Sept.
However, the Tuesday schedules only have open backup window from Tuesday 22:00:00 --> Wednesday 08:00:00

On Tuesday morning, only Monday schedules have open window:
Monday 22:00:00 --> Tuesday 08:00:00

So, if the backup runs early hours on a Tuesday morning and need to use the Tuesday schedule, then the status 199 makes perfect sense. The backup window is closed.

@Marianne hits the nail on the head, as usual!

I think the primary culprit is that you're using Calendar-based schedules. Even though your backup window spans from 2200-0800, the schedule is specified to only run on Mondays. Since the backup kicked off at 12:59, it was Tuesday morning and outside of the policies specified days to run.

You most likely run full backups throughout the weekend, and have some slow or long-running jobs that are using resources. When Monday starts, not all of those jobs are finished, and you have to wait for them to conclude. This means when your primary backup window starts (most likely off-hours after 5-6 PM), there aren't as many resources available as there are later in the week. Your Monday policy doesn't kick off right at 2200, and has to wait for its turn to start. Since it starts a few hours into its backup window, you've now entered Tuesday, and the schedule is only allowed to run on Mondays, and now you have a status 199.