Re: Duplicating a Database on the same machine

Scott,

I'm pretty much in the same situation as you. Small databases, can be shutdown at night. Basically, we clone from production to development and the idea is to shutdown the prod db, copy the datafiles to the dev location and then do a startup nomount, create controlfile file set database name "DEV" etc....

This takes all of about 30 to 40 minutes depending on the size of the datafiles.

Let me know if you want specfics.
hth

mkb

In article <Ekx14.118$U04.17040_at_news.uswest.net>, "W. Scott Moore" <sirws_at_hotmail.com> wrote:
> To clarify, all of the datafiles for the production instance are in
> e:\oracle\gpro and for development they are in f:\oracle\gdev, not
> in
> various directories all over the server.. :)
> Thanks,
> Scott
> W. Scott Moore <sirws_at_hotmail.com> wrote in message
> news:ufx14.114$U04.16838_at_news.uswest.net...
> > Here is what I would like to do. Currently, I have a production
> instance
> > and a development instance on the same machine, with all of the
> data files
> > on different drives and directories.
> >
> > What I would like to do is come up with a way to duplicate the
> production
> > database into the development instance, say late every night.
> (They
> aren't
> > huge databases at this point in time... full export is about
> 200MB), but
> > there are lots of tables.
> >
> > Is it possible to do a full export of the production database
> and import
> it
> > to a new location, creating datafiles in a different location
> for the dev
> > database? All of the datafiles have the same name, except for
> the control
> > files, logfiles, etc. which are named differently based on the
> Oracle SID
> > name - if that helps.
> >
> > I am able to shut down the production instance as well, if a
> solution
> would
> > require copying the datafiles. I am sure there are many ways of
> doing
> this,
> > I am just looking for something that is fairly quick, and easy to
> maintain.
> >
> > We have 8.0.5 on NT.
> >
> > Sincerely,
> > W. Scott Moore
> > GIS Data Base Analyst
> > City of Chandler, AZ
> >
> >

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!