on 01-21-2014 6:38 AM
Dear experts,
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
# 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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.