Re: Questions about cloning an instance

You know I always hate when people post questions that have obvious answers if they had only read the documentation. Doh! I did read the pages, I just didn't think about them that hard before making that post. Sorry... Worse yet, I think I actually answered my own questions in the same post:')

OK. I am guessing that I use the 'Create Controlfile...' since I'm not creating a database, but only reusing an existing one. And if I don't use the same db_block_size, then the datafiles would be unusable.

Thanks again, sorry for being so dense.

-greg

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3ac32876_at_news.iprimus.com.au...
>
> "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! =-----
>
>

-----= 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 - 07:01:18 CST