backup error

[Former Member]

hi all,

i am trying to make a backup using brbackup and i am receiving this error:

BR0051I BRBACKUP 7.00 (39)

BR0055I Start of database backup: bdzyeghq.fnd 2009-02-17 00.35.10

BR0484I BRBACKUP log file: K:\backup\bdzyeghq.fnd

BR0477I Oracle pfile C:\oracle\product\10.2.0\db_1\database\initRMD.ora created from spfile C:\oracle\product\10.2.0\db_1\database\spfileRMD.ora

BR0280I BRBACKUP time stamp: 2009-02-17 00.35.12

BR0301E SQL error -1580 at location BrCtlCopy-1, SQL statement:

'/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO 'K:\backup\CNTRLRMD.DBF''

ORA-01580: error creating control backup file K:\backup\CNTRLRMD.DBF

ORA-27040: file create error, unable to create file

OSD-04002: unable to open file

O/S-Error: (OS 3) The system cannot find the path specified.

BR0320E Copying of control file to K:\backup\CNTRLRMD.DBF failed

BR0314E Collection of information on database files failed

BR0056I End of database backup: bdzyeghq.fnd 2009-02-17 00.35.12

BR0280I BRBACKUP time stamp: 2009-02-17 00.35.12

BR0054I BRBACKUP terminated with errors

any ideeas what might be wrong?

i am using the user <sid>adm.

thx

p.s.: any helpfull answers will be rewarded

Edited by: Galan Irina on Feb 17, 2009 11:00 AM

[Former Member]

Hi,

Please upgrade your SAP kernel.

Also implement SAP note 323332. This will resolve your problem.

Regards,

Sachin Rane.

[Former Member]

Please create the user ID orasid on the remote server ( Where the K Drive is originally resides) & give administrative rights to this user.

[former_member220071]

Hi ,

Please check whether you can currently access the directory that contains the

file. Also, check whether the file in question exists.

>CNTRLRMD.DBF

In some cases, a file system overflow can also cause this error.

Also see Note 491160.

[former_member204746]

try these COMMANDS:

K:

cd backup

dir

reply with results.

one more thing, you have not install Oracle the proper way. you have used setup.exe and not sapserver.cmd.

your ORACLE_HOME should look like c:\oracle\SID\102 and not like C:\oracle\product\10.2.0\db_1

[Former Member]

Hello Galan,

does ur SAP run on Linux platform?

if yes check the required permissions from the note 113747

Rohit

[Former Member]

hi Rohit,

my sap runs on windows

[Former Member]

have u configured initSID.sap file for backups

Rohit

[Former Member]

yes...

this is the first part of my config file

backup_mode = full

1. restore mode [all | all_data | full | incr | incr_only | incr_full

2. | incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>) | partial | non_db

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

5. default: all

restore_mode = full

1. backup type [offline | offline_force | offline_standby | offline_split

2. | offline_mirror | offline_stop | online | online_cons | online_split

3. | online_mirror | online_standby | offstby_split | offstby_mirror

4. default: offline

backup_type = online

1. backup device type

2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

5. | rman_prep]

6. default: tape

backup_dev_type = disk

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

2. default: %SAPDATA_HOME%\sapbackup

backup_root_dir = K:\backup

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

2. default: value of the backup_root_dir parameter

stage_root_dir = K:\backup

1. compression flag [no | yes | hardware | only]

2. default: no

compress = no

1. compress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <target_file_name> = <source_file_name>.Z

5. for compress command the -c option must be set

6. recommended setting for brbackup -k only run:

7. "%SAPEXE%\mkszip -l 0 -c $ > $"

8. no default

compress_cmd = "C:\usr\sap\RMD\SYS\exe\uc\NTAMD64\mkszip -c $ > $"

1. uncompress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <source_file_name> = <target_file_name>.Z

5. for uncompress command the -c option must be set

6. no default

uncompress_cmd = "C:\usr\sap\RMD\SYS\exe\uc\NTAMD64\uncompress -c $ > $"

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

2. default: value of the backup_root_dir parameter

compress_dir = C:\oracle\RMD\sapreorg

1. brarchive function [save | second_copy | double_save | save_delete

2. | second_copy_delete | double_save_delete | copy_save

3. | copy_delete_save | delete_saved | delete_copied]

4. default: save

archive_function = save

1. directory for archive log copies to disk

2. default: first value of the backup_root_dir parameter

archive_copy_dir = C:\oracle\RMD\sapbackup

1. directory for archive log copies to stage

2. default: first value of the stage_root_dir parameter

archive_stage_dir = C:\oracle\RMD\sapbackup

[Former Member]

give orasid and sidadm full permissions to K directory and K:\backup and then try running the backup

Let me know if it helps

Rohit

[former_member185031]

ORA-01580: error creating control backup file K:\backup\CNTRLRMD.DBF
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

It looks like read write permission error or may be you dont have space at this drive.

Regards,

Subhash

[Former Member]

thx for reply

i have full control on k:\backup and more than enough space...

any other ideeas?

[Former Member]

Hello Galan,

Where are you trying to take backup

Rohit

[Former Member]

Orasid whould have read-write permission to K:\backup

[Former Member]

i am trying to take the backup on a mounted device

[Former Member]

if i am starting the backup with <sid>adm i also need permissions for ora<sid> ?

[Former Member]

Hi,

You need make an entry in the initSID.sap file. In that the parameter is backup_dev_type = disk & backup_root_dir = <backu dir>.

Mahesh

[Former Member]

hi Mahesh,

been there ...done that...

any other ideeas?

thx

irina