IBM RO and Dataguard

From: Chris Grabowy <cgrabowy_at_gmail.com>
Date: Tue, 16 Apr 2024 11:58:25 -0400
Message-ID: <CAF2_96C47vRNPJh21f0GKaWcLv4StZh913g9xS8osX4ghju+_Q_at_mail.gmail.com>



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
Received on Tue Apr 16 2024 - 17:58:25 CEST

Original text of this message