Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Copy of an Oracle database

Re: Copy of an Oracle database

From: Chris Weiss <weisschr_at_tcimet.net>
Date: Sat, 21 Jul 2001 21:37:29 GMT
Message-ID: <9inhkq$23u1$1@msunews.cl.msu.edu>

In NT, copying a db is not trivial thing because of the registry and other annoying quirks. It is almost trivial in Unix or Linux. A more reliable technique is to create an empty database with similar storage to your original and then export and import the base database.

Good Luck,
Chris Weiss

"Kurt-Erich Finger" <kurt-erich.finger_at_otelo-online.de> wrote in message news:de2fe149.0107130449.4aa6f1b8_at_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:37:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US