Re: RMAN CONVERT DATABASE
Date: Wed, 30 Mar 2011 08:54:58 -0700 (PDT)
Message-ID: <4058d947-1ce2-4508-b1c6-bb7d1dbb4343_at_k3g2000prl.googlegroups.com>
On Mar 29, 8:26 pm, BillPedersen <wmapeder..._at_gmail.com> wrote:
> On Mar 29, 8:59 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
> > Bill:
>
> > # Thoughts?
>
> > How about a straight up impdp using network link?
>
> I guess the other thing is I did not see much/any discussion on it in
> the 10g2R documentation set...
>
> Found some notes online, will review.
>
> From what I can see, I would suspect I need to have "target" database
> in the destination - one which can be "blown away" and then it is a
> matter of logging into both systems, setting up the link and then
> starting the expdp and then the impdp processes on SQLplus with the
> full=y option on the expdp.
>
> Does one need to do the same sort of PL/SQL recompile on the target as
> discussed with RMAN CONVERT process? I did not yet see any discussion
> around that.
>
> Thanks,
>
> Bill.
You don't have to, since things are automatically compiled as needed, but you may want to, especially if you have complex dependencies (and you want to find any problems beforehand, such as missed object privileges). See http://www.oracle-base.com/articles/misc/RecompilingInvalidSchemaObjects.php
I don't on my systems, but they aren't all that complex. They are kind of strange for this type of operation, though, there are extra operations I have to do. It all depends on the particular app what the best thing to do is. I have to ignore a lot of "table doesn't exist" types of errors on import which get resolved on recompilation, and "user doesn't exist" errors which are informative, but useless. You have to understand all errors. Having MOS access can really help with this, especially when it is a new world. Everyone goes through the same learning curve, and that's a basic repository for solutions. Heck, I probably couldn't pass a job interview now, everything I've forgotten is on the net.
jg
-- _at_home.com is bogus. http://www.theregister.co.uk/2011/03/30/convergence_gravity/Received on Wed Mar 30 2011 - 10:54:58 CDT