System copy for ABAP+JAVA system using SAPINST method

[#1]

Dear support,

We have recently upgraded to ECC 6.0 system and we have been still doing system copy by using backup and restore method. I know its<b> wrong</b>.

which involves below steps , this old methos works fine for ABAP engine and evreything looks ok.But java engine will not work.

So we need to use SAPINST method as described in note 785848 and system copy guide available on OSS. But i am really not able to understand sequence

for tasks to be carried out in this SAPINST method.

<b>Can anybody list few sequence along with step by step procedure as i mentioned below for old system copy procedure.</b>

Is it really difficult to make that for <b>SAPINST</b> as everybody says refer to standard guide and note ?

Anybody if possible can make the same way as i did below , i think it would rather be small as far as my understanding after reading those docs.

Simple old system copy procedure works for ABAP is as:

Run the following command on source system.

a. Login as <sid>adm

b. svrmgrl

c. connect internal

d. alter database backup controlfile to trace;

e. exit;

f. Above command will generate a .trc file in /oracle/P01/saptrance/usertrace directory.

g. Copy the text from CREATE CONTROLFILE until the ( and paste it in to any new .sql or controlfile.sql file.

h. Copy the controlfile.sql to target system.

i. Edit the file and replace the entire source SID to target SID.

j. Edit the reuse database command with the set database command

Copy the aft generated during the backup file from the source system to target system. (/oracle/<SID>/sapbackup)

a. Change all the source <SID> to target <SID>.

b. Only don't change the backup volume name it must be target system <SID>.

c. Copy the above aft file name line from the source back<SID>.log to target<SID>.log file.

5. Shutdown the target server instance.

6. From this onwards all the command on the target system only.

a. Login as <SID>adm

b. run the SAPDBA

c. select J (Restore/Recovery)

d. select B (Full restore and recovery)

e. select A (Select backup of type)

f. Select the offline backup which you want to restore.

g. It will take some time to restore.

h. Once the database is restored login as <SID>adm and run the

i. svrmgrl

j. connect internal;

k. startup nomount (if the database is already mounted shutdown it using the shutdown command)

l. run the following command

m. @controlfile.sql (file name of the control file contains the CREATE CONTROLFILE statement)

n. After the run the above command it should give the "Statement Processed)

o. alter database open resetlogs.

I am really looking forward to see anybody take some time out to prepare this kind of step by step procedure.

It would be of greate help for all of us for performing system copy with sapinst method.

Looking forward for your support.

Best Regards,

AjitR

[Former Member]

Hi Ajju

I have exactly the same problem you descibe in your log file, and would also be interested to see the advice on how to proceed.

Thanks

Bill Dedman