Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Options to duplicate database

Re: Options to duplicate database

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 06 Sep 2007 20:37:26 +0200
Message-ID: <fbphd3$p3t$1@news2.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

jackzhunj_at_gmail.com wrote:
> Hi,
>
> I need to duplicate one of our DB to the new Linux server:
>
> Original DB: 10.1.0.2 64 bit on Solaris
> Catalog DB: 10.1.0.2 64 bit on Solaris
>
> 'compatible' parameter is '9.2.0' for the above 2 db.
>
> New server and Oracle: 10.2.0.1 64 bit on RHEL 5
>
> Besides the traditional exp/imp, what are the other options? (We don't
> want original DB down or become read only)
>
> 1. Transportable tablespace. We cannot do it, because it needs to make
> tablespaces of original DB readonly.
>
> 2. RMAN Duplicate feature? Since this is cross-platform, according to
> Note 369644.1 from metalink:
>
> "With 10g, using the RMAN convert commands, you can cross
> between platforms"
> But 'convert' command does require 'compatible' parameter is at least
> 10.
>
> So, I think I will not be able to use 'duplicate' feature, right?
>
> 3. Any other suggestions?
>
> 4. Which one use less CPU and I/O: exp a large table or use 'sqlplus'
> to 'spool' to a text file?
>

  1. not if you clone on solaris first, and do the duplication from the clone. Works like a charm, provided you have the space and cpu power (the latter is needed for just a short time).
  2. Clone on Solaris, set compatible to 10, RMAN cross-platform, and reset compatible.
  3. Imp/exp, CTAS are all valid options, but at least half as fast as RMAN with transportable tablespaces.
  4. Why is that of any concern? Is the machine IO bound as well as cpu bound?
    • -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG4EjmLw8L4IAs830RAi2zAJ0crO3JloPztGwyCIMMZEpsabdO2wCfTZa5 v/q7/994WB8aUo2zyylI8fI=
=cdB4
-----END PGP SIGNATURE----- Received on Thu Sep 06 2007 - 13:37:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US