I'd like to add vote to the paper that Mr. Pannequin recommended. To quote from the summary: ". If we had used the standard export/import' method we estimated the whole move would have taken at least 12 days, but using the techniques we developed, the move was done in 18 HOURS." They were moving 60 Gigabytes from a Pyramid to a Cray running Oracle 7.1. The RDBMS is a bit outdated but the techniques that they used seem to be version independent.
http://www.doug.org/news/doug596.html Ron Yount <ronwy To: Multiple recipients of list ORACLE-L @swbell.net> <[EMAIL PROTECTED]> Sent by: root cc: Subject: RE: database clone: 03/11/2002 09:28 PM Please respond to ORACLE-L Mitchell, I have not been following the thread, but nonetheless, I will attempt to add some information. It is accurate to state that imp/exp is your only option in 8.0.5 when you are trying to move a database from one platform (AIX) to another (Solaris). Other options all up through version 8.1.7 only apply when the platform is not changing: e.g. Transportable tablespace Standby database or RMAN Hot Backup/Recover from disk or tape. I have heard that in version 9i, you can, in fact create a standby database on a different platform because it actually converts the redo logs into SQL type DML/DDL statements and applies them, but even this is no way to re-create a 300 Meg database. Of course, your option of imp/exp would be VERY time and resource intensive. HTH, -Ron- > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of mitchell > Sent: Monday, March 11, 2002 11:09 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: database clone: > > > Hi DBAs. > > Thanks all your reply. I am still thinking it is possible to use > backup file > or cp files. It is hard to exp/imp on a large system with 300GB. > > Mitchell > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, March 11, 2002 11:53 AM > > > > [EMAIL PROTECTED] wrote: > > > > > Hi DBAs: > > > > > >What is the best way to clone large oracle database ( 8.0.5, 300g) from > aix > > >4.3 o to Sun Soloris (2.8). > > >Any idea, articles, experience? > > > > > > > > >thanks in advance. > > > > > >Mitchell > > > > > > > > exp from aix, install, create the database and the tablespaces on sun, > > then imp. > > > > > > -- > > -- > > Bill "Shrek" Thater ORACLE DBA > > [EMAIL PROTECTED] > > ------------------------------------------------------------------------ > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > ------------------------------------------------------------------------ > > "Books won't stay banned - Ideas won't go to jail." - Alfred > Whitney Griswold > > > > > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: bill thater > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: mitchell > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
