BR0252E Function fopen() failed for '/oracle/sid/sapdata1\sapbackup\.user.pas' at brtoolcall-2data1'

[Former Member]

Dear experts,

When I use  the brtools for database backup happen error:

BR0252E Function fopen() failed for 'drive:\oracle\sid\sapdata1\sapbackup\;user.pas' at location Brtoolcall-2

BRO252E ERRNO 2: No such file or directory

BR0669I canot contain due to previous warnings or errors -you can go back to repeat last action

BR0280I  BRTOOLS TIME STAMP:2014-01-21 10.20

BR0671I Enter b - back to go back,  s - stop to abort:

BEFORE MY BRTOOLS IS NOT WORKED ,AFTER ADDING  'DBMS_TYPE 'IN EVINROMENTAL VARIABLES ,BRTOOLS IS WORKING

THANKS

NANI

[Former Member]

Hi Nani

Please  let us know if the backups have ever worked fine or is it the first time that you are trying to run the DB backups.

From the error , looks like the configuration is not proper.  Can you share the location of your sapbackup folder.

Ideally , it should be under oracle\SID\sapbackup

Thanks

Rishi

[Former Member]

Dear sir,

   this is first time ,my backup location path is:oralce/sid/sapbackup

thnkas

nani

[Reagan]

BR0252E Function fopen() failed for 'drive:\oracle\sid\sapdata1\sapbackup\;user.pas' at location Brtoolcall-2
BRO252E ERRNO 2: No such file or directory

I don't understand why the system is looking for the sapbackup directory under sapdata1 location.

drive:\oracle\sid\sapdata1\sapbackup

It should be <drive>:\oracle\SID\sapbackup

Regards

RB

[Former Member]

Hi RB,

                I did one mistake ,in environmental variables i chnaged the path,but i am getting same error,this time system is looking for oralce/sid/sapbackup/sapbackup.what is the paths required in environmental variables.

thanks

nani

[Reagan]

Hello Nani

What is the value for SAPDATA_HOME environment variable.?

Regards

RB

[Former Member]

Hi sir,

• SAPDATA_HOME =D\ORACLE\SID

Thanks

nani

[Reagan]

Have you made any changes to the environment variable of the sidadm user ?

If so then restart Windows and see if that helps.

Regards

RB

[Former Member]

Hi

what is the path need for oracle_home,is it optional or mandatory,

already i did restart sir,

BR0292I execution of brbackup finished with return code 3

BR0668I WARNINGS OR ERRORS OCCURRED - YOU CAN CONTINUE TO IGNORE  THEN GOBACK TO REPEAT THE LAST ACTION

now i am getting above error..,

once send me the init<sid>.sap profiles parametere values

Thanks

nani

[Reagan]

You need to provide the complete log file.

The above provided information is not sufficient to understand the issue.

The ORACLE_HOME should be set based on the version of Oracle.

(Eg: ORACLE_HOME D:\oracle\SID\102_64)

Also provide the .sap profile used by the backup.

Regards

RB

[Former Member]

Hi sir

init<sid>.sap profile

# backup mode [all | all_data | full | incr | sap_dir | ora_dir

# | all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

# | <generic_path> | (<object_list>)]

# default: all

backup_mode = all

# restore mode [all | all_data | full | incr | incr_only | incr_full

# | incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

# | <generic_path> | (<object_list>) | partial | non_db

# redirection with '=' is not supported here - use option '-m' instead

# default: all

restore_mode = all

# backup type [offline | offline_force | offline_standby | offline_split

# | offline_mirror | offline_stop | online | online_cons | online_split

# | online_mirror | online_standby | offstby_split | offstby_mirror

# default: offline

backup_type = offline

# backup device type=0ffline_split

# [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

# | disk_copy | disk_standby | stage | stage_copy | stage_standby

# | util_file | util_file_online | rman_util | rman_disk | rman_stage

# | rman_prep]

# default: tape

backup_dev_type = disk

# backup root directory [<path_name> | (<path_name_list>)]

# default: %SAPDATA_HOME%\sapbackup

backup_root_dir = D:\oracle\DEV\sapbackup

# stage root directory [<path_name> | (<path_name_list>)]

# default: value of the backup_root_dir parameter

stage_root_dir = D:\oracle\DEV\sapbackup

backup_root_dir=D:\oracle\dev\sapbackup

# compression flag [no | yes | hardware | only]

# default: no

compress = no

# compress command

# first $-character is replaced by the source file name

# second $-character is replaced by the target file name

# <target_file_name> = <source_file_name>.Z

# for compress command the -c option must be set

# recommended setting for brbackup -k only run:

# "%SAPEXE%\mkszip -l 0 -c $ > $"

# no default

compress_cmd = "D:\usr\sap\DEV\SYS\exe\uc\NTI386\mkszip -c $ > $"

# uncompress command

# first $-character is replaced by the source file name

# second $-character is replaced by the target file name

# <source_file_name> = <target_file_name>.Z

# for uncompress command the -c option must be set

# no default

uncompress_cmd = "D:\usr\sap\DEV\SYS\exe\uc\NTI386\uncompress -c $ > $"

# directory for compression [<path_name> | (<path_name_list>)]

# default: value of the backup_root_dir parameter

compress_dir = D:\oracle\DEV\sapreorg

# brarchive function [save | second_copy | double_save | save_delete

# | second_copy_delete | double_save_delete | copy_save

# | copy_delete_save | delete_saved | delete_copied]

# default: save

archive_function = save

# directory for archive log copies to disk

# default: first value of the backup_root_dir parameter

archive_copy_dir = D:\oracle\DEV\sapbackup

# directory for archive log copies to stage

# default: first value of the stage_root_dir parameter

archive_stage_dir = D:\oracle\DEV\sapbackup

# delete archive logs from duplex destination [only | no | yes | check]

# default: only

# archive_dupl_del = only

# new sapdata home directory for disk_copy | disk_standby

# no default

# new_db_home = X:\oracle\C11

# stage sapdata home directory for stage_copy | stage_standby

# default: value of the new_db_home parameter

# stage_db_home = /oracle/C11

# original sapdata home directory for split mirror disk backup

# no default

# orig_db_home = /oracle/C11

# remote host name

# no default

# remote_host = <host_name>

brtool cmd error:

BR0280I BRBACKUP time stamp:2014-01-22

BR0308I shutdown of database instance sid successful

BR0056I end of database backup:benapqfu.afd 2014-01-22

BR0280I BRBACKUP timestamp:2014-01-22

BR0054I BRBACKUP terminated with errors

##################################################################

BR0292I execution of brbackup finished with return code 3

BR0668I WARNINGS OR ERRORS OCCURRED - YOU CAN CONTINUE TO IGNORE  THEN GOBACK TO REPEAT THE LAST ACTION

thanks

nani

[Reagan]

# default: %SAPDATA_HOME%\sapbackup
backup_root_dir = D:\oracle\DEV\sapbackup
# stage root directory [<path_name> | (<path_name_list>)]
# default: value of the backup_root_dir parameter
stage_root_dir = D:\oracle\DEV\sapbackup
backup_root_dir=D:\oracle\dev\sapbackup

I am not sure whether this could be the reason.

I see the backup_root_dir is specified twice.

remove this : backup_root_dir=D:\oracle\dev\sapbackup

Save and retry.

Also the backup log is still not showing the correct information.

How are you starting the backing ?

Regards

RB

[Former Member]

Hi,

I remove it ,still same error...

BRBACKUP Action Log for Database SID

From: 23.01.2014 10:27:34 LogFile: benasxfq.afd Return Code: 0003 Error during initialization Database Host: sapecc6 No action log for this action found in the database Check the detail log

Thanks

nani

[Former Member]

Hi Nani

Can you please share the options which you are using for running the backup.  Also the log file.  It looks like there is some incorrect parameter in your environment or profile which is causing the problem.

Also when you trigger an online backup , you should see a file getting created under SAPBACKUP location with extension .anf.

Are you seeing that file , if yes please share it

Thanks

Rishi

[former_member182657]

Hi Nani,

First this is issue with permissions,try to check permission & existent of required directories on your system.Also please follow SAP Notes

113747 - Permissions for DBA tools BR*Tools and

651351 - BR tools on UNIX: Error due to executable permissions

Give 755 permissions to sapbackup dir with command example as below:

#chmod -R 755 ../SID/sapbackup

Thanks,

Gaurav

[Former Member]

Hi sir,

my os is windows

[Former Member]

Hi sir,

  afte entering ur command my output is:SP2_0103: NOTHING IN SQL BUFFER TO RUN

THANKS

NANI

[former_member182657]

Hi Nani,

Is sapbackup directory exists on your system.just check once and also share what are the permissions on brspace,brtools,brrecover etc.

One thing more please check permissions and owner for oracle folder on your system and are you able to run brtools from cmd ?

Also fyi linux based commands will not work on windows system.

Thanks,

Gaurav

[Former Member]

hi sir

all permessions is fine,i am able to run brtools on cmd

thanks

nani

[Former Member]

hii

    now i am getting new error,i am taking  offline backup.

BR0292I execution of brbackup finished with return code 3

BR0668I WARNINGS OR ERRORS OCCURRED - YOU CAN CONTINUE TO IGNORE  THEN GOBACK TO REPEAT THE LAST ACTION

THANKS

NANI