Oracle Database Discussions

Hi all,

I am having the difficulty after clone the database from a hot backup from server. Both server & PC running at W2k OS and Oracle 8.1.7. Below are the steps what i am doing.

1)Take a hot backup from the server.

2)Create a folder \oracle\oradata\CLONE. Stored all the datafiles there.

3)Copy the init.ora from the server and paste to \oracle\admin\CLONE\pfile. Amended all the location, instance name, db name, etc.

4)log in to server and run the command, ALTER SYSTEM BACKUP CONTROLFILE TO TRACE RESETLOGS.

5)Copy the trace file and amend to the create control file script. Alter the script like

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "CLONE" RESETLOGS ARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
....

6)Also created the service using the command ORADIM.

7)Under OS command line, SET ORACLE_SID=CLONE and then log in the SQL*PLUS. Once i executed the create control script. I hv encounter error like ORA-27100: shared memory realm already exists.

Could anyone tell me why this error occurs and how to solve the problem.

TQ,
Alfred