Re: Options to duplicate database

On Sep 5, 12:42 pm, 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?

CTAS over a link. Assuming you have a fast link, of course. Turning off archiving on the receiving end may help, too (then turn it on and backup when done!).

>
> 4. Which one use less CPU and I/O: exp a large table or use 'sqlplus'
> to 'spool' to a text file?
>

Direct option of exp. See http://www.oracledba.co.uk/tips/import_speed.htm

> Thanks a lot!

Whatever you do, watch undo space and retention settings. If you can discourage connections to the db, that could help.

If you have transactions happening, you'll have to deal with those one way or another to switch over.

jg

--
@home.com is bogus.
http://www.itnews.com.au/News/60642,mozilla-quietly-resurrects-eudora.aspx