Copy of an Oracle database

From: Kurt-Erich Finger <kurt-erich.finger_at_otelo-online.de>
Date: Sat, 21 Jul 2001 21:35:44 GMT
Message-ID: <de2fe149.0107130449.4aa6f1b8@posting.google.com>

Hello,

I tried to copy an existing database to a new location on the same server (Win NT, Oracle 8.0.5)

I did an "alter database backup controlfile to trace, shut down the database and copied all datafile and logfiles to the new location. In the trace file I re-set the ID and changed the path:

STARTUP NOMOUNT
CREATE CONTROLFILE set DATABASE "PLAY" RESETLOGS NOARCHIVELOG

    MAXLOGFILES 32
    MAXLOGMEMBERS 5
    MAXDATAFILES 254
    MAXINSTANCES 2
    MAXLOGHISTORY 955
LOGFILE
  GROUP 3 'D:\training\LOGORCL1B.ORA' SIZE 10M,   etc.
DATAFILE
'D:\training\SYS1ORCL.DBF',
'D:\training\RBS1ORCL.DBF',

  etc
;
ALTER DATABASE OPEN resetlogs;

When I ran the script I got:

CREATE CONTROLFILE set DATABASE "PLAY" RESETLOGS NOARCHIVELOG ORA-01503: create controlfile failed
ORA-01158: database already mounted.

The database was not mounted.
Running the script after SHUTDOWN gave the same result.

A database PLAY already existed in \training, but I deleted all files. The INITPLAY also points to the right directory.

What did I do wrong?

Thanks in advance

Kurt-Erich Finger Received on Sat Jul 21 2001 - 16:35:44 CDT