RE: database clone:

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>         <ORACLE-L_at_fatcity.com>                            
                    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: root_at_fatcity.com [mailto:root_at_fatcity.com]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" <ORACLE-L_at_fatcity.com>
> Sent: Monday, March 11, 2002 11:53 AM
>
>
> > mitchell_at_comnet.ca 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
> > bthater2_at_netscape.net
> >

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron  Yount
  INET: ronwy_at_swbell.net

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: ListGuru_at_fatcity.com (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: tday6_at_csc.com

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: ListGuru_at_fatcity.com (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).