cancel
Showing results for 
Search instead for 
Did you mean: 

System Copy-Erorr in Generating CONTROL.SQL file

Former Member
0 Kudos

Hi All,

I tried to start DB specific system copy and when try to generate CONTROL.SQL files following error appear,

I added generateFiles option, but still error state that i need to enter it, Any expert idea on why this happen ?

Regards.

============================================================

C:\Documents and Settings\pidadm\Desktop\BrCopy>*ora_br_copy.bat -generateFiles -targetSid DRQ -password Basis12345-listenerPort 1527*

C:\Documents and Settings\pidadm\Desktop\BrCopy>"C:\j2sdk1.4.2_17-x64\bin\java.exe" -showversion -cp ".\.;.\orabrco

py.jar;D:\oracle\product\10.2.0\db_2\jdbc\lib\classes12.jar" com.sap.inst.lib.app.SecureStartup "" com.sap.inst.ora

brcopy.OraBRCopy -oracleHome "D:\oracle\product\10.2.0\db_2" -sourceSid "PID" -generateFiles -targetSid DRQ -passwo

rd Basis12345 -listenerPort 1527

java version "1.4.2_17"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_17-b06)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_17-b06, mixed mode)

Incorrect application options:

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

C:\Documents and Settings\pidadm\Desktop\BrCopy>

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

now its working.

Former Member
0 Kudos

Hi,

I have the same problem.

You can edit ora_br_copy.bat file.

Add " u2013generateFiles u2013password xxx u2013targetSid xxx u2013listenerPort 1527 "in the line:

"%_JAVA_CMD%" -showversion -cp "%MIG_HOME%\.;%MIG_HOME%\orabrcopy.jar;%ORACLE_HOME%\jdbc\lib\classes12.jar" com.sap.inst.lib.app.SecureStartup "" com.sap.inst.orabrcopy.OraBRCopy -oracleHome "%ORACLE_HOME%" -sourceSid "%ORACLE_SID%" %*

Then execute ora_br_copy.bat file.

Best regards

Former Member
0 Kudos

Hi,

Thanks much, now it working.

Regs.

Former Member
0 Kudos

Hi!

If you keep having problems you can recover the DB manually and use a CONTROL.SQL file that just contains the line 'STARTUP'. Should work fine.

Kind regards,

Jörg

Ayax
Participant
0 Kudos

Did you update your brtools?

Regards,

Ayax

Former Member
0 Kudos

BrTool version is 7000.146.14.42943, Im using below commnd on windows 2003,

ora_br_copy.bat u2013generateFiles u2013forceLogSwitches u2014targetSid PID u2014password <system's password> u2014listenerPort 1527

Regards.

Ayax
Participant
0 Kudos

Have you tried with forceLogSwitches option?

Regards,

AM

Former Member
0 Kudos

Hi,

Yes, same error apper.

Regs.