Status code 241 when taking Oracle backup using oracle agent

[HardikPatel]

Master server 6.5.6 on windows 2003 R2
Media Server 6.5 on AIX 5.3 with Oracle 10g

while taking backup using policy for oracle database i am getting error code 241 and 6
some time it Backup completed successfully and some times it gives error


Entry in bp.conf file on media server 

SERVER = Master server name
SERVER = Media server name
CLIENT_NAME = Media server name
EMMSERVER = Master server name
ALLOW_MEDIA_OVERWRITE = DBR
ALLOW_MEDIA_OVERWRITE = TAR
ALLOW_MEDIA_OVERWRITE = CPIO
ALLOW_MEDIA_OVERWRITE = ANSI
ALLOW_MEDIA_OVERWRITE = AOS/VS
ALLOW_MEDIA_OVERWRITE = MTF1
ALLOW_MEDIA_OVERWRITE = RS-MTF1
ALLOW_MEDIA_OVERWRITE = BE-MTF1
MEDIA_SERVER = Media server name
NB_ORA_POLICY = ORACLE_DB
NB_ORA_SCHED = Default-Application-Backup
NB_ORA_SERV = Master server name
NB_ORA_CLIENT = Media server name
CLIENT_READ_TIMEOUT = 1200
  

[Marianne]

# bperror -S 241 -r
The specified schedule is the wrong type for this request

Tell us more about the policy and the backup script, please.
Maybe try to hard-code policy and schedule in the script?

[HardikPatel]

Backup didnt get failed everytime. with same policy and schedule it was working ok. but some time it got failed. so where i have to check .
And how i can hard code the policy and schedule.

[Marianne]

It is impossible to even guess or try to give advice without seeing your script and policy.
Policy:
bppllist <policy-name> -U
You need logs to see which policy and schedule was selected when there's a failure.
I don't have access to any Oracle client right now, but logs that will help are: the RMAN output file, bphdb and dbclient logs on client.


To hard-code policy and schedule in the script, see this example:

run {
  allocate channel t1 type 'SBT_TAPE';
  allocate channel t2 type 'SBT_TAPE';
     send 'NB_ORA_POLICY=your_policy, NB_ORA_SCHED=your_schedule,  NB_ORA_SERV=your_server’;
  backup
  (database format 'bk_%U_%t');
}

[Prav]

In addition to what Marianne had wrote I would also use the NB_ORA_CLIENT parameter so your SEND command will look like:

run {
  allocate channel t1 type 'SBT_TAPE';
  allocate channel t2 type 'SBT_TAPE';
  send 'NB_ORA_SERV=master_server, NB_ORA_CLIENT=oracle_client_name, NB_ORA_POLICY=oracle_policy'; 
  backup
  (database format 'bk_%U_%t');
..
..
}

NB_ORA_SCHED is optional and need only to be used if you have multiple 'default application schedules' in your Oracle policy

I would say that it good practice to you the NB_ORA_SERV, NB_ORA_CLIENT and  NB_ORA_POLICY parameters in any of your rman backup scripts

I would also make sure that you set your default application schedule window to be 24 x 7

I hope the above helps...

[varunprakash]

http://seer.entsupport.symantec.com/docs/288271.htm