Redo log backup failing with BR253E errno 2:

[Former Member]

Hi all,

I am able to take online as well as offline backup through sapdba , but unfortunately from last 7 days my redo log backup is failing after online backup is complete with below mentioned error. I also tried to start redo log backup seperately but failed as below...

BR002I BRARCHIVE 6.20 (18)

BR006I Start of offline redo log processing: adwpawsw.sve 2007-11-13 21.33.22

BR280I Time stamp 2007-11-13 21.33.25

BR008I Offline redo log processing for database instance: PRD

BR009I BRARCHIVE action ID: adwpawsw

BR010I BRARCHIVE function ID: sve

BR048I Archive function: save

BR011I 195 offline redo log files found for processing, total size 9469.831 MB

BR112I Files will not be compressed

BR130I Backup device type: disk

BR106I Files will be saved on disk in directory: F:\oracle\PRD\sapbackup

BR126I Unattended mode active - no operator confirmation required

BR202I Saving init_ora

BR203I to F:\oracle\PRD\sapbackup\PRD ...

BR202I Saving o:\orcle\prd\920\DATABASE\initPRD.sap

BR203I to F:\oracle\PRD\sapbackup\PRD ...

BR280I Time stamp 2007-11-13 21.33.26

BR198I Profiles saved successfully

BR252E Function fopen() failed for 'F:\oracle\PRD\sapbackup\.PRD/oraarch/PRDarch

ARC10479.001' at location arch_process-4

BR253E errno 2: No such file or directory

BR121E Processing log file F:\oracle\PRD\sapbackup\.PRD/oraarch/PRDarchARC10479.

001 failed

BR016I 0 offline redo log files processed, total size 0.000 MB

BR007I End of offline redo log processing: adwpawsw.sve 2007-11-13 21.33.26

BR280I Time stamp 2007-11-13 21.33.26

BR005I BRARCHIVE terminated with errors

-

---

-

---

End of output from program 'BRARCHIVE' -

---

SAPDBA: Execution of BRARCHIVE failed.

(2007-11-13 21.33.27)

Press <return> to continue ...

SAPDBA: Last line from BRARCHIVE summary log:

'#* PRD disk adwpawsw sve 2007-11-13 21.33.22 2007-11-13 21.33.26

5 ........... -

---

c 6.20 (18)'

Press <return> to continue ...

Appreciate your quick replies.

Best Regards,

AjitR

[Former Member]

can you provide us with the active db parameter log_archive_dest

sqlplus "/ as sysdba"

SQL> show parameter archive

regards

Peter

[Former Member]

I cant think dbs_ora_schema is an issue because this normally happens with backup-restore system copy procedure.

SQL> show parameter archive;

NAME TYPE VALUE

-

---

-

---

-

---

archive_lag_target integer 0

log_archive_dest string D:\oracle\PRD/oraarch/PRDarch

log_archive_dest_1 string

log_archive_dest_10 string

log_archive_dest_2 string

log_archive_dest_3 string

log_archive_dest_4 string

log_archive_dest_5 string

log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

NAME TYPE VALUE

-

---

-

---

-

---

log_archive_dest_9 string

log_archive_dest_state_1 string enable

log_archive_dest_state_10 string enable

log_archive_dest_state_2 string enable

log_archive_dest_state_3 string enable

log_archive_dest_state_4 string enable

log_archive_dest_state_5 string enable

log_archive_dest_state_6 string enable

log_archive_dest_state_7 string enable

log_archive_dest_state_8 string enable

log_archive_dest_state_9 string enable

NAME TYPE VALUE

-

---

-

---

-

---

log_archive_duplex_dest string

log_archive_format string ARC%S.%T

log_archive_max_processes integer 2

log_archive_min_succeed_dest integer 1

log_archive_start boolean TRUE

log_archive_trace integer 0

remote_archive_enable string true

standby_archive_dest string %ORACLE_HOME%\RDBMS

SQL>

[Former Member]

i think D:\oracle\PRD/oraarch/PRDarch this line must be an issue because it should be D:\oracle\PRD\oraarch

i will change the same and take restart

[Former Member]

I have changed parameter but NO gail .

still backup fails

[Former Member]

Appreciate if anybody could provide way out of this issue.

[former_member204746]

sqlplus "/ as sysdba"

show parameter spfile.

<b>if value is empty:</b>

you must adapt init[SID].ora

change log_archive_dest to F:\oracle\PRD\oraarch

save file

restart instance;

try again

<b>if you find an SPFILE:</b>

sqlplus "/ as sysdba"

alter system set parameter log_archive_dest to F:\oracle\PRD\oraarch scope=both;

restart shoudl not be necessary.

[Former Member]

Hi Pl check the following

Make sure that the following variables are set in the environment of the failed process:

dbms_type=ora

PATH=<oracle_home>\bin;... (<oracle_home>\bin in first position)

dbs_ora_tnsname=<sid>

dbs_ora_schema=SAPR3 or dbs_ora_schema=SAP<sid> (depending on which user the R/3 tables belong to)

NLS_LANG=AMERICAN_AMERICA.<characterset> (see Note 381674)

ORACLE_HOME=<oracle_home> (optional)

SAPDATA_HOME=<drive>:\oracle\<sid>

TNS_ADMIN=<pfad_zu_tns_files> (only required for R/3 below 3.1I or Oracle 10g and Instant Client)

ORACLE_SID=<sid> (normal Oracle installation) or unique instance name, for example <sid>001 (RAC installation)

USER=<sid>adm

This is what Note 556232 - Environment settings for R/3/Oracle on Windows says.

Pl refer it.

Regards

[Former Member]

Below are my env settings i have marked in bold all required variables in place.

One more thing i would like to add before 7 days it was working fine and redolog backups were successfull , only problem is why my bracrhive taking <b>.PRD</b> folder if it does not exist in init.sap

C:\Documents and Settings\prdadm.NYCGTSPRD>set

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\prdadm.NYCGTSPRD\Application Data

CLIENTNAME=LPT-AJITR

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=NYCGTSPRD

ComSpec=C:\WINDOWS\system32\cmd.exe

<b>dbms_type=ora

dbs_ora_schema=SAPDEV

dbs_ora_tnsname=PRD</b>FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\prdadm.NYCGTSPRD

JAVA_HOME=C:\j2sdk1.4.2_13

LOGONSERVER=
NYCGTSPRD

<b>NLS_LANG=AMERICAN_AMERICA.WE8DEC</b>NUMBER_OF_PROCESSORS=4

OMPATH=C:\Program Files\Dell\OpenManage\oma\bin;C:\Program Files\Dell\OpenManage

\LU\bin;C:\Program Files\Dell\OpenManage\oldiags\bin

ORAARCH=D:\oracle\PRD\oraarch

<b>ORACLE_HOME=o:\orcle\prd\920

ORACLE_SID=PRD</b>OS=Windows_NT

Path=C:\jdk1.3.1_15\bin;o:\orcle\prd\920\jre\1.4.2\bin\client;o:\orcle\prd\920\j

re\1.4.2\bin;<b>o:\orcle\prd\920\bin</b>;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Progr

am Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32

\Wbem;C:\Program Files\Dell\OpenManage\oma\bin;C:\Program Files\Dell\OpenManage\

LU\bin;C:\Program Files\Dell\OpenManage\oldiags\bin;C:\Program Files\Dell\OpenMa

nage\RAC\MN;C:\Program Files\Dell\OpenManage\Array Manager;K:\usr\sap\PRD\SYS\ex

e\run

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 15 Model 4 Stepping 1, GenuineIntel

PROCESSOR_LEVEL=15

PROCESSOR_REVISION=0401

ProgramFiles=C:\Program Files

PROMPT=$P$G

SAPARCH=D:\oracle\PRD\saparch

SAPBACKUP=D:\oracle\PRD\sapbackup

SAPCHECK=D:\oracle\PRD\sapcheck

<b>SAPDATA_HOME=D:\oracle\PRD</b>SAPLOCALHOST=nycgtsprd

SAPREORG=D:\oracle\PRD\sapreorg

SAPTRACE=D:\oracle\PRD\saptrace

SESSIONNAME=RDP-Tcp#73

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP\1

TMP=C:\WINDOWS\TEMP\1

<b>USER=prdadm</b>USERDOMAIN=NYCGTSPRD

USERNAME=prdadm

USERPROFILE=C:\Documents and Settings\prdadm.NYCGTSPRD

windir=C:\WINDOWS

[Former Member]

Hi,

How come the

dbs_ora_schema is SAP<u>DEV</u> while the

dbs_ora_tnsname=<u>PRD</u>

ORACLE_HOME=o:\orcle\<u><b>prd</b></u>\920

ORACLE_SID=<u>PRD</u>

Pls Check the dbs_ora_schema

Pl check if it is SAPPRD

Regards

[Former Member]

that may happen, if you are doing a homogenious system copy using backup / restore.

the dbs_ora_schema can't be changed during system copy.

peter

[Former Member]

Unfortunately backlogs point to directory

<b>'F:\oracle\PRD\sapbackup\.PRD</b>

But i have my logfiles getting archived at D:\oracle\PRD\oraarch

and they are supposed to be backed up at F:\oracle\PRD\sapbackup

Below is my init.sap file for your ref, i cant find where this <b>.PRD</b> folder came from

1. backup mode [all | all_data | full | incr | sap_dir | ora_dir

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

3. | <generic_path> | (<object_list>)]

4. default: all

backup_mode = all

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

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

3. | <generic_path> | (<object_list>)]

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

5. default: all

restore_mode = all

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

2. | offline_stop | online | online_cons | online_split]

3. default: offline

backup_type = offline

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 = tape

backup_dev_type = disk

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

2. default: %SAPDATA_HOME%\sapbackup

#backup_root_dir = D:\oracle\PRD\sapbackup

backup_root_dir = F:\oracle\PRD\sapbackup

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

2. default: value of the backup_root_dir parameter

#stage_root_dir = D:\oracle\PRD/sapbackup

stage_root_dir = F:\oracle\PRD\sapbackup

1. compression flag [yes | no | 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 = "@SAPEXE@\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 = "@SAPEXE@\uncompress -c $ > $"

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

2. default: value of the backup_root_dir parameter

#compress_dir = D:\oracle\PRD/sapreorg

compress_dir = F:\oracle\PRD\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 = D:\oracle\PRD/sapbackup

archive_copy_dir = F:\oracle\PRD\sapbackup

1. directory for archive log copies to stage

2. should contain <SID> subdirectory

3. default: first value of the stage_root_dir parameter

#archive_stage_dir = D:\oracle\PRD/sapbackup

archive_stage_dir = f:\oracle\PRD\sapbackup

1. new database home directory for disk_copy | disk_standby

2. no default

3. new_db_home = X:\oracle\C11

1. stage database home directory for stage_copy | stage_standby

2. default: value Cof the new_db_home parameter

3. stage_db_home = /oracle/C11

1. original database home directory for split mirror disk backup

2. no default

3. orig_db_home = /oracle/C11