Kurt-Erich Finger wrote:
>
> 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
Hi,
Did you create an instance before you did it?
If not create it using oradim.
please check if your controlfiles already exist in the loaction you specify
in the initCOPY.ora, if they do, create controlfile REUSE.
I've copy database serveral times and it's OK.
HTH,
Tho Nguyen
--
Posted via CNET Help.com
http://www.help.com/
Received on Sun Jul 15 2001 - 21:30:14 CDT
