Re: Copying database to another instance possible ?

Disregard my 1st reply to this message. Found out that the 'RECOVER DATABASE' clause in the trace file didn't need to be executed. When opening the database with 'ALTER DATABASE OPEN RESETLOGS' it works!

Regards,

Simon Verzijl
Devote

In article <36E50041.BA988288_at_capgemini.co.uk>,   Alex Hudghton <alex.hudghton_at_capgemini.co.uk> wrote:
> You can recreate by moving the datafiles - when you use the 'create
controlfile'
> statement you have to use 'SET database' . Also use this if you are changing
the
> database name.
>
> Alex
>
> sverzijl_at_hotmail.com wrote:
>
> > Hi All,
> >
> > Can someone tell me what the common way is to copy/restore a database to
> > another instance ?
> >
> > (e.g. in DB2 there is the command 'RESTORE DATABASE PROD INTO TEST' to
> > accomplish this).
> >
> > In Oracle I only know of a full export/import of a database, but this is a
> > very time consuming task. I tried copying the datafiles and recreating the
> > controlfile from the 'backup to trace' (replacing the datafile paths to
point
> > to the new database location), but this doesn't work since Oracle checks the
> > header of the datafile comparing the database name.
> >
> > There must be a faster way than a full export/import to copy a database,
isn't
> > there ?
> >
> > Regards,
> >
> > Simon Verzijl
> > Devote
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 08:20:55 CST