Issue when executing ora_br_copy.bat

[Former Member]

Hi All,

When i tried to execute ora_br_copy.bat u2013generateFiles u2013forceLogSwitches u2014targetSid SID u2014password pwd -listenerPort 1527

we are getting a error saying that

D:\Export for SID\orabrcopy>"C:\j2sdk1.4.2_12\bin\java.exe" -showversion -cp ".\

.;.\orabrcopy.jar;D:\ORACLE\Sourcesid\102\jdbc\lib\classes12.jar" com.sap.inst.lib.app

.SecureStartup "" com.sap.inst.orabrcopy.OraBRCopy -oracleHome "D:\ORACLE\sourcesid\10

2" -sourceSid "sourcesid" -generateFiles -forceLogSwitches -targetSid <targetsid> -password pwd -listenerPort 1527

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

Incorrect application options:

At least one from 'generateFiles' or 'forceLogSwitches' options is required.

Have already referred the thread but still its not working .

[Former Member · Accepted solution]

Try below syntax

ora_br_copy.bat u2013generateFiles u2013forceLogSwitches u2014targetSid <TARGET_DBSID> u2014password <system's password> u2014listenerPort <listener port>

[Former Member · Accepted solution]

Hi Sunil,

The above syntax looks same to me which i have used.Am i missing somthing,Thanks.

[Former Member · Accepted solution]

The syntax looks OK.

>>ora_br_copy.bat -generateFiles -forceLogSwitches -targetSid <TARGET_DBSID> -password <system's password> -listenerPort <listener port>

Can you please pasate the logs from ora.brcopy.log.

[former_member524429 · Accepted solution]

Hi,

Have you tried to execute the command as mentioned below? :

ora_br_copy.bat -generateFiles -targetSid <TARGET_DBSID> -password <system's password> -listenerPort 1527

Do not use -forceLogSwitches option and execute ora_br_copy as mentioned above.

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi,

Thanks all for your responses.Should i then force log switches manually?

[Former Member · Accepted solution]

Hi Sunil,

Pasted below the log.

os.name = Windows 2003

os.arch = x86

os.version = 5.2

cpu.count = 2

sun.cpu.endian = little

sun.arch.data.model = 32

sun.cpu.isalist = pentium i486 i386

file.encoding = Cp1252

file.separator = \

path.separator = ;

line.separator = CR/LF

user.name = ql2adm

user.home = C:\Documents and Settings\ql2adm

user.dir = D:\Export for DL0\orabrcopy

user.language = en

user.country = AU

java.version = 1.4.2_12

java.vendor = Sun Microsystems Inc.

java.vendor.url = http://java.sun.com/

java.vm.version = 1.4.2_12-b03

java.vm.vendor = Sun Microsystems Inc.

java.vm.name = Java HotSpot(TM) Client VM

java.vm.info = mixed mode

java.compiler =

java.class.version = 48.0

java.home = C:\j2sdk1.4.2_12\jre

java.ext.dirs = C:\j2sdk1.4.2_12\jre\lib\ext

java.class.path = .\.;.\orabrcopy.jar;D:\ORACLE\QL2\102\jdbc\lib\classes12.jar

java.library.path = C:\j2sdk1.4.2_12\bin;.;C:\WINDOWS\system32;C:\WINDOWS;D:\ORACLE\QL2\102\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA_1\BMCSOF1\common\globalc\bin\Windows-x86;C:\PROGRA_1\BMCSOF1\Patrol3\bin;C:\Program Files\BMC Software\Patrol3\BEST1\7.3.00\bgs\bin;D:\ORACLE\QL2\102\OPatch;D:\usr\sap\QL2\SYS\exe\uc\NTI386

java.io.tmpdir = C:\WINDOWS\TEMP\1\

Incorrect application options:

At least one from 'generateFiles' or 'forceLogSwitches' options is required.

[former_member524429 · Accepted solution]

Hi,

Should i then force log switches manually?

Before Executing ora_br_copy.bat , you can manually do log switch using alter system switch logfile; in SQLPLUS as sysdba.

ora_br_copy.bat -generateFiles -targetSid <TARGET_DBSID> -password <system's password> -listenerPort 1527

That above command worked ?

The last thread contains the OLD log of ora.brcopy.log. ?

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi Bhavik,

I am still skeptical since we copy the database files including the online redo logs.Will it serve the purpose by using the command before.Thanks.

[Former Member · Accepted solution]

If you use orabrcopy tool then no need to modify your tracefile and create control file, this will do all for you.

I think the thread should clear your doubt.

[Former Member · Accepted solution]

Hi Sunil,

Thanks for the reply.

Had one doubt.We have done the export since we are unable to execute brcopy shall we manually create the controlfile and then shutdown the db and copy the files will it work.Thanks.

[Former Member · Accepted solution]

>Had one doubt.We have done the export since we are unable to execute brcopy

What type of export you have take? is that DB and SAP?

>shall we manually create the controlfile and then shutdown the db and copy the files will it work.

You can create the control file no issues.

but why you want to shutdown your database? you mean you want to copy the database to target system?

[Former Member · Accepted solution]

We are doing a system copy for EP.Windows oracle.

We are not using jload one.We are exporting and then running the command and then shutting down the db and coping the files and import.But in order to proceed we need ora_br_copy.bat to work.

[Former Member · Accepted solution]

I don't find any issues with the syntax.

when you execute the ora_br_copy.bat there will be a ora.brcopy.log file, can you please paste the contents?

[Former Member · Accepted solution]

Hi Sunil,

Had already posted the log in the earlier logs.Thanks.

[Former Member · Accepted solution]

Hi All,

Will the above batch file do the same task as .Is it the same.

alter database backup controlfile to trace as '/oracle/<Target SID/SIDChange_<Target SID>.sql' noresetlogs ;

[Former Member · Accepted solution]

Hi All,

I wanted to know what exactly this batch does.

ora_br_copy.bat

[Former Member · Accepted solution]

the ora_br_copy.bat generates

control.sql

control.trc

init<targetSID>.ora

[Former Member · Accepted solution]

Hi Sunil,

When checked in the batch file i didnt come to know that it generates the following files.How did you come to know about the same.Thanks.

[Former Member · Accepted solution]

Hi,

Did a control file backup to trace and log switch and it worked.Thanks.