SChema ID problem during system copy

[Former Member]

I'm in the middle of system copy of XI based on SAPWeb AS server 6.40. I'm system copying the Quality server (XQA) from Production server (XPD) using offline backup of production server.

In Production server, schema ID name is SAPXPD. After copy the prodcution server data, tablespaces in quality server look like SAPXPD, SAPXPD640, SAPXPDDB etc.

and in operating system file system, it look like xpd_1,xpd640_1 etc.

I think, i should first change the schema ID and it should change the tablespace name, operating system file system etc.

Pls let me know how to change the schema ID in this case. If there is any documentation, pls copy it to me ar <email address deleted by moderator>.

Thanks in advance

Amar

[Former Member]

Hi Amarjit,

You could change SID by executing sql statement, below;

CREATE CONTROLFILE SET DATABASE "XXX" RESETLOGS ARCHIVELOG

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 4537

LOGFILE

GROUP 11 (

'D:\ORACLE\XXX\ORIGLOGA\LOG_G11M1.DBF',

'E:\ORACLE\XXX\MIRRLOGA\LOG_G11M2.DBF'

) SIZE 75M,

GROUP 12 (

'D:\ORACLE\XXX\ORIGLOGB\LOG_G12M1.DBF',

'E:\ORACLE\XXX\MIRRLOGB\LOG_G12M2.DBF'

) SIZE 75M,

GROUP 13 (

'D:\ORACLE\XXX\ORIGLOGA\LOG_G13M1.DBF',

'E:\ORACLE\XXX\MIRRLOGA\LOG_G13M2.DBF'

) SIZE 75M,

GROUP 14 (

'D:\ORACLE\XXX\ORIGLOGB\LOG_G14M1.DBF',

'E:\ORACLE\XXX\MIRRLOGB\LOG_G14M2.DBF'

) SIZE 75M,

GROUP 15 (

'D:\ORACLE\XXX\ORIGLOGA\LOG_G15M1.DBF',

'E:\ORACLE\XXX\MIRRLOGA\LOG_G15M2.DBF'

) SIZE 75M,

GROUP 16 (

'D:\ORACLE\XXX\ORIGLOGB\LOG_G16M1.DBF',

'E:\ORACLE\XXX\MIRRLOGB\LOG_G16M2.DBF'

) SIZE 75M,

GROUP 17 (

'D:\ORACLE\XXX\ORIGLOGA\LOG_G17M1.DBF',

'E:\ORACLE\XXX\MIRRLOGA\LOG_G17M2.DBF'

) SIZE 75M,

GROUP 18 (

'D:\ORACLE\XXX\ORIGLOGB\LOG_G18M1.DBF',

'E:\ORACLE\XXX\MIRRLOGB\LOG_G18M2.DBF'

) SIZE 75M

-- STANDBY LOGFILE

DATAFILE

'E:\ORACLE\XXX\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

.

.

.

CHARACTER SET US7ASCII

;

Since, create this sql statement perform following command on your productive system;

startup nomount

alter database backup controlfile to trace resetlogs;

Then go to \usertrace directory and open newly created log file. So, you can see the sql statement as same as above. Copy the statement and change SID regarding your requirement. For example CREATE CONTROLFILE SET DATABASE "XQA" and execute it on your QA system.

Before the operation, do not forget to delete existing control files on your QA system.

At the end of the respective execution, perform following statements;

>shutdown

>startup mount

>alter database open resetlogs;

>shutdown

I hope that it helps to you.

Best regards,

Orkun Gedik

[Former Member]

Thanks Orkun

but this process only change the SID name from XPD to XQA. Our problem is related to Schema ID.

Thanks Again

Amar

[Former Member]

What is the value of the environment variable dbs_ora_schema?

Alsoo see SAP note 617444.

It is advisable to keep the schema id same in both QUA and PRD...for ex SAPDAT..

[Former Member]

Thanks Bidwan

We installed our XPD server around 4 year back. At that time, we had not think about this schema ID problem. I already checked the 617444 note.

We can change the schema ID with R3load tool. Do you have experience to run r3load?

Regards

Amar