Re: Copying database to another instance possible ?

Alex,

When I do this I get the message that I have to recover the database using backup controlfile. What to do about this ?

This is the scenario I followed :

1. ALTER DATABASE BACKUP CONTROLFILE TO TRACE (of the database to be copied)
2. SHUTDOWN DATABASE 3) create a new instance using oradim and a copy of the source database initfile 5) copy all datafiles of the database to a new location 6) change the CREATE CONTROLFILE from the trace using the new path to the copy of the datafiles 7) add 'SET DATABASE <newdbname> RESETLOGS' to the CREATE CONTROLFILE STATEMENT 8) STARTUP NOMOUNT of the new instance 9) execute the CREATE CONTROLFILE statement 10) RECOVER DATABASE

at point 10 I get the above mentioned error.

If anyone knows a suitable sollution to this, I'd be very happy

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 - 07:50:21 CST