Homogeneous System copy for Netweaver 2004S SR1 ABAP+JAVA- Oracle/windows

[Former Member]

Hi All,

I am planning to do Homogeneous System copy of our production system to New Test system which SID is different from production system. I don't want to do system copy through SAPinst(R3load) because I cannot down our production server. I want to create the New test system from the offline back.

I have already installed our new system. I want to do system copy through Oracle-Specific Procedure as mentioned in the system copy documents.

Could you please tell me how to do sytem copy step by step and how to change the SID.

Thanks in advance.

Harish

[Former Member]

Hi Harish ,

I did Homogeneous Copy through Oracle Procedure thrice...tell me on which phase you are ???

Is all the steps are already finished??

Regards,

Rohit

[Former Member]

Hi Rohit,

When I am trying to create the control files then I am getting following errors :

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file

'%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified

As per the oracle procedure I have deleted all three control files from the target system. after copied the sapdata files,origlogA,mirorlogB. I have also copied the control.sql and init<target_SID>.ora file which I created on the source system with the compand ora_br_copy.

I have copied control.sql. in the install_dir of the and init<target_SID>.ora in \oracle\SID\102\database directory.

could you please let me know why this error is coming or you could send me document if you have.

Thanks in advance.

Harish

[Former Member]

You can use DB restore, but you need to use JLoad (via SAPinst) for the Java stack. This can be done at the target server, which means you do not have to interrupt the production system.

[Former Member]

Thanks Mauric for the prompt reply.

Could you please send me some document or steps to do the DB restore.

Thanks,

Harish

[markus_doehr2]

This is all in the systemcopy documentation under

http://service.sap.com/systemcopy

what is unclear to you?

--

Markus

[Former Member]

Hi Markus,

I have copied all the data files,origlogs,mirrorlogs in the target server and kept control.sql file which I generated from the source system in the install directory and init<targetSID>.ora in accordingly in datbase directory. But when I started it's not up despatcher is in gray. I just want to know shell I do some more steps to keep the system up.

Thanks in advance.

Harish.

[markus_doehr2]

you started sapinst after you copied the data as described in the guide? Just copying over the files is not enough...

--

Markus

[Former Member]

No, I have not started the sapinst after copied.

Could you please let me know the step.

Thanks,

Harish

[markus_doehr2]

As described in the guide:

- start sapinst on the target system and install your instance

- your then prompted to copy the data over as well as the control.sql that was created using R3COPY/ORABRCOPY

- after that you continue with sapinst

That´s the normal procedure...

If you know what you´re doing from a database point of view you can use the control file and create the control files manually and issue an "alter database open resetlogs;" after the database has been recreated. SAPINST will do that for you.

--

Markus

[Former Member]

Markus,

Actually,

1.I have install the target system with different SID (as a fresh installation, with sapinst).

2.create the CONTROL.SQL and init<TARGET_SID> files in source system as mentioned in the system copy guide with ora_br_copy command.

3.Remove all the datafiles, controlfiles, orriglogs,mirrlogs, and control files from target system.

4.Copied all sapdata files,origlogs,mirrlogs, and CONTROL.SQL and init<TARGET_SID>.ora from source system to target systems in the relevant directories.

5.then started SAP it's not working.

Could the please confirm that these steps are correct or I have to do some more things.

Thanks in advance.

Harish

[andreas_herzog]

> 5.then started SAP it's not working.

-> what is not working?

-> are you able to start and open the database?

-> how did you start/open the db? using open resetlogs?

plz be more specific...thx!

GreetZ, AH

[markus_doehr2]

No, this can´t work.

sapinst prompts you to restore the database (if you selected "Additional Lifecylcle - target system).

The system does not "know" as of now, that it has a database.

--

Markus

[Former Member]

Hi Andreas,

I am trying to create control files after "startup nomount" with the restlogs and getting following errors

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file

'%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'

ORA-27041: unable to open file

OSD-04002: unable to open file

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

could you please help.

Thanks

Harish

[markus_doehr2]

If you use ORABRCOPY you need to use sapinst, it will substitute variables, that are not known if you execute that manually.

The other possibility is to manually adapt the CONTROL.SQL and insert the correct paths.

--

Markus

[Former Member]

Hi ,

In the case of a Oracle specific procedure for ABAP+JAVA copy , on the source system , how do we export the J2EE os dependent files to be imported on target system.

do we need to specifically run Jload on source system .

Regards