Re: Questions about cloning an instance

"Greg Akins" <insomnia_at_cvzoom.net> wrote in message news:3ac314f3_3_at_corp.newsfeeds.com...
> And one other question. Does this force me to have the same db_block_size
> as the old database?
>

Did you in fact read the document that I pointed you to?

If you did, you should be able to answer your own question.

But just in case not.... you've copied the datafiles, right? Datafiles are made up of Oracle blocks. The block size they contained was that specified for the primary database.

So, what do you think?

Regards
HJR
> -greg
>
> "Greg Akins" <insomnia_at_cvzoom.net> wrote in message
> news:3ac30919_4_at_corp.newsfeeds.com...
> > OK...clone a database. It looks relatively simple. I am going to a
> > different box, with one disk (It's just for testing) and Win2000. Will
 that
> > make much of a difference. It doesn't appear so.
> >
> > A couple things I'm a little wary of. First of all, I know that I can
 edit
> > the controlfile trace to a 'Create database' command. Is this what I
 want
> > to do, or am I simply editing it to create a different controlfile?
> >
> > So, walking through the startup...
> >
> > 1. Nomount - just needs a minimal init.ora
> > 2. mount - Needs a controlfile (which can be created by the 'Alter
 Database
> > Backup Controlfile to trace'
> > Use the Create Controlfile statement and edit the file locations
> > appropriately.
> > 3. open - Will work if a valid copy of the datafiles are in the
 appropriate
> > place.
> >
> > Seems simple enough. Wish me luck.
> >
> > Thanks for the the help.
> >
> > -greg
> >
> > "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> > news:3ac19f36_at_news.iprimus.com.au...
> > > You might care to peruse
> > > http://www.geocities.com/hjroz2000/clonedatabase.txt where the subject
 is
> > > documented at length. The replies I've seen posted here will have
 your
 new
> > > database sending archives into the same directory as the production
 database
> > > (assuming the source database is in archivelog mode), amongst other
 nasty
> > > gotchas.
> > >
> > > Incidentally, you don't clone an 'Instance'. You clone a database.
> > >
> > > Regards
> > > HJR
> > >
> > >
> > >
> > > "Greg Akins" <insomnia_at_cvzoom.net> wrote in message
> > > news:3ac104e6_3_at_corp.newsfeeds.com...
> > > > Hello,
> > > >
> > > > I am setting up a test server which need to mimic a production
 oracle
 8i
> > > > database.
> > > >
> > > > From a highlevel perspective I believe I have to
> > > >
> > > > 1. Create the instance with an init.ora similar to the production
> > > > (differences for SGA settings only?)
> > > > 2. Create a script to recreate the users and tablespaces?
 Tablespace
 can
> > > > be the same, but the test box only has one disk, so Datafile
 locations
 will
> > > > be different.
> > > > 3. Full Export from Production and import to Test.
> > > >
> > > > Am I missing anything? Any suggestions would be appreciated.
> > > >
> > > > -greg
> > > >
> > > >
> > > >
> > > >
> > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > > > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > > > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> > >
> > >
> >
> >
> >
> >
> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Thu Mar 29 2001 - 06:19:41 CST