Re: IBM RO and Dataguard

Greetings Chris -

   Sorry, I haven't used IBM RO...but I have used similar products.

  I am just updating here, for reference purposes.

   My OTM import & invalid objects were resolved, mostly with a re-initialization of XDB using the xdbreload.sql post import.

   After reloading XDB, utlrp.sql was able, for the most part, to clean up the remaining. (A close comparison of privileges was also conducted, to ensure everything from SOURCE was successfully propagated to target.)

   Not sure of anyone else, but it often bugs me, when I see someone had the issue I am experiencing, but they didn't take the time to share their solution.

  So future headscratchers, this worked for me ...LOL....

Oh, and on the other topic, thanks to this list's host(s) - If there is a manner in which to share a monetary thank you, and hopefully perpetuate the good works here, please do advise.

Thanks to all and remember to

Have a Great Day !!

D

On Tue, Apr 16, 2024 at 8:59 AM Chris Grabowy <cgrabowy_at_gmail.com> wrote:

> Any DBA out there using IBM RO with Oracle Dataguard?
>
> I just have a configuration question or two
>
> TIA
>
> Chris
>
> On Fri, Apr 12, 2024, 12:59 Douglas Dunyan <dmdunyan_at_gmail.com> wrote:
>
>> Greetings Oracle Deities !
>>
>> So I am inheriting an OTM 6.4.2 implementation, and I'm trying to
>> satisfy a request for a new 'TEST' environment.
>>
>> After completing scheme level datapump exports/imports of the relevant
>> schemas (GLOGOWNER, GLOGDBA, etc) and importing them, I am facing invalid
>> objects in OTHER schemas - that I would have thought to be unrelated --
>> and UTLRP won't resolve. Here are the post impdp/utlrp invalid counts...
>>
>> SYS 159 (mostly types)
>> XDB 79
>> MDSYS 10
>> CTXSYS 11
>> GLOGOWNER 5
>> GSMADMIN_INTERAL 1
>>
>> I'm not finding a lot of details regarding OTM available, and
>> unfortunately, I cannot access any MOS documents, either.
>>
>> I am wondering if this type of refresh is even possible. If so, do we
>> need to execute some specific OTM scripts to re-initialize?
>> I am hoping to develop a process to refresh PRODUCTION via this
>> manner, Or will we be stuck just building a new environment from scratch,
>> and calling it test ? Then painfully use the application tools to migrate
>> configurations, definitions, and then data...
>>
>> ( I am a DBA guy...an APP guy not so much...)
>>
>> TIA=Thanks in Advance
>> HAGD = Have a Great Day !
>>
>> D
>>
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l