Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Options to duplicate database
-----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?
>
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