Re: Options to duplicate database

On Sep 6, 2:37 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>
> jackzh..._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-----
Yes, the Netapp SAN is heavily loaded already.

Can I:

Copy RMAN backup from original db to the new db server and do RMAN restore/recover there?

different OS and different Oracle version. thnx, Received on Thu Sep 06 2007 - 16:14:39 CDT