no offline redo logs found for processing

[Former Member]

Hi!

I have very simple question/problem.

I have installed two Oracle systems on the same host on Windows.

I have installed the oracle software only once

If I try to execute a full online backup + redo logs, only the online redo logs will be back up. After this I get the error <b>BR0017E Offline redo log file 'C:\oracle\DEV\102\RDBMS\ARC01435_0627659303.001' not found</b>.

If I try only to back up redo logs I receive the warning "no offline redo logs found for processing".

I tried to implement some helpful SAP notes such as 490976.

E.g. I have changed the file arch<sid>.log, but I have still the same warning.

The environment seems to be ok.

It would be great, if some one have experience dealing with this problem...

Thank's

[former_member204746]

please post your environment variables:

start -> run -> CMD

set

you must use 2 different user ID, one for each DB and adapt your environment variables accordingly.

[Former Member]

Hello Eric!

Many thanks for your response.

Here the ENV-comando from SM49:

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

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

CPIC_MAX_CONV=10

DBMS_TYPE=ora

dbs_ora_schema=SAPSR3

dbs_ora_tnsname=DEV

FP_NO_HOST_CHECK=NO

JAVA_HOME=C:\j2sdk1.4.2_15-x64

NLS_LANG=AMERICAN_AMERICA.UTF8

NUMBER_OF_PROCESSORS=8

ORACLE_HOME=C:\oracle\SSM\102

ORACLE_SID=DEV

OS=Windows_NT

Path=C:\oracle\SSM\102\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\DMIX;C:\j2sdk1.4.2_15-

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

PERL5LIB=C:\oracle\SSM\102\perl\5.8.3\lib\MSWin32-X64-multi-thread;C:\oracle\SSM\102\perl\5.8.3\lib;C:\oracle\SSM\102\perl\5.8.3

PPID=1952

PROCESSOR_ARCHITECTURE=AMD64

PROCESSOR_IDENTIFIER=EM64T Family 6 Model 15 Stepping 7, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=0f07

PROMPT=$P$G

SAPDATA_HOME=H:\oracle\DEV SAPEXE=F:\usr\sap\DEV\SYS\exe\uc\NTAMD64 SAPLOCALHOST=sapdev

SAPSYSTEMNAME=DEV

SIDE_INFO=F:\usr\sap\DEV\DVEBMGS02\data\sideinfo.DAT

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP

TMP=C:\WINDOWS\TEMP

TNS_ADMIN=F:\usr\sap\DEV\SYS\profile\oracle

windir=C:\WINDOWS

kind regards

Thom

[former_member204746]

also supply initSSM.ora and your other init[SID].ora

I believe that both files are referring to the same archive directory

[Former Member]

Hi Eric,

thank your for your response.

I have checked over ST04 --> "active parameters" the parameter LOG_ARCHIVE_DEST. This is set to right value H:\oracle\DEV\oraarch\DEVarch.

Which other settings in initDEV.ora do you mean?

Many thank's

Regards

Thom

[former_member204746]

you say you have 2 Oracle systems... So I guess you have 2 Oracle databases?

If so, supply both initSID.ora files

[Former Member]

Hi!

Of course I have installed two database instances: SSM and DEV.

But I have installed the DB-ssoftware onyl once under C:\oracle\102\SSM

On the OS-level I have two separate folders for redo logs:

H:\oracle\SSM\oraarch\SSMarch and

H:\oracle\DEV\oraarch\DEVarch.

What exactly, which parameters do you mean with supply both initSID.ora files?

Thank you!

Regards

Thom

[former_member204746]

supply LOG_ARCHIVE_DEST for both systems

[former_member204746]

and are you using the proper [SID]ADM user? do not log with ADMIN, log with SMSADM or DEVADM

also read

<b>I find it strange that you have the exact SID as Axel Henke , P. Gollman and your other Henke brother.</b>

[Former Member]

Hi Eric,

I am using ssmadm for SSM and devadm for DEV system for this tasks.

LOG_ARCHIVE_DEST shoul be set right.

Have you experience with impelementing the notes:

490976

10170

29321

113747

What is about to set BR_TRACE to 15 and/or try to edit the archDEV.log as described in NOTE 10170?

What very strange is, I can execute Offline redo logs for SSM system, but not for DEV system.

Thank you

Thom