Re: Moving entire 8.1.7 database b/t machines

"Robert Banniza" <robert_at_rootprompt.net> wrote in message news:aldh71$4j8$1_at_news.laserlink.net...
> I have an Oracle instance I'm running on a Sun 3800. I'm wanting to make
 an
> exact replica of this database on a 420R for testing and general trashing
 to
> try to some new things. I thought using exp to export the entire database
> (COMPLETE) and then using imp on the 420 to import the database would do
> the trick. However, I'm getting all kinds of errors about users not
 existing
> and such. Therefore, how can I move the entire database without taking the
> prod database offline? If I am on the right track with exp/imp, can you
 tell
> me what flags I need to do this? I have looked everywhere and nothing
 seems
> to be working. I want to bring users over as well. Any help appreciated.
>
> Robert
>
>

Two basic methods
1 make a clone. Source database needs to be down briefly to copy all files. After that issue
alter database backup controlfile to trace; You'll get a tracefile which contains the CREATE CONTROLFILE command. Copy the tracefile over, edit it when necessary, startup nomount of the target database, run the tracefile and presto. Note: O/Ses must be *exactly* the same for this (so no 32/64-bit mixes) 2
exp/imp. Contrary to what you say this *does* work. You'll need to have a FULL export. Any other export type doesn't contain CREATE USER statements as you already discovered. You may need to *precreate* your tablespaces. In your case also the CREATE USER statements might have failed because the default and temporary tablespace don't exist. As you don't post your import log one must guess what has actually happened. Generally I would run with the exp with
FULL=Y COMPRESS=N BUFFER=<something big in bytes> LOG=<any filename> and imp with
FULL=Y COMMIT=Y IGNORE=Y LOG=<any , different, filename> BUFFER=<the same big number as above>

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address