Re: Schema duplication on the same database.
- From: Dhimant Patel <drp4kri@xxxxxxxxx>
- To: Andy Klock <andy@xxxxxxxxxxxxxxx>
- Date: Fri, 28 May 2010 09:06:18 -0400
Right,
That was my proposal to our team to replicate only tables of concern and
with the condition that production performance may get hindered by such
arrangements. We are still away from implementations and weighing our
options.
Thanks everyone for their input.
-DP.
On Thu, May 27, 2010 at 4:05 PM, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote:
> Out of the three options you listed, it seems that number 2 (Oracle
> Replication) is your best option. I support several Oracle Replication
> environments and it is what it is. With the disclaimer that I don't know all
> the details of your environment or the needs (or volume) of your data, I
> would still be concerned about "testing changes" on your production
> database. You also have to weigh the overhead in replicating your data to
> another schema (or location). With Oracle Streams (11g Standard Edition) you
> have the benefit of applying the changes downstream (off of prod) or
> applying redo to a "standby" until you are ready to run your tests both
> sound like safer/better options.
>
>
> On Thu, May 27, 2010 at 2:55 PM, Dhimant Patel <drp4kri@xxxxxxxxx> wrote:
>
>> Sorry about missing Oracle version. Its' 10g standard.
>>
>> The purpose of the copy schema is to be able to accommodate new changes
>> for future application code release, so they would be used for testing these
>> changes. These code changes depend on external data feeds and so we couldn't
>> rely on datapump refreshes.
>>
>> As you pointed out, server side code changes could be put to freeze and/or
>> manage accordingly but we would rather have a guaranteed complete sync of
>> schemas than do such things.
>>
>>
>> Thanks,
>> DP.
>>
>>
>> On Thu, May 27, 2010 at 2:09 PM, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote:
>>
>>> You didn't mention your version. Oracle Streams is available in 11g
>>> Standard Edition. ( a fine reason to upgrade ) And though Oracle
>>> Replication doesn't copy packages, procedures, etc is that really a problem?
>>> Can you control schema changes, and just apply them across the "copy"
>>> schemas?
>>>
>>> Out of curiosity, what are these "copy" schemas going to be used for?
>>>
>>> On Thu, May 27, 2010 at 1:09 PM, Dhimant Patel <drp4kri@xxxxxxxxx>wrote:
>>>
>>>> Yes,
>>>> but we need to have it on the same database and not on the standby. In
>>>> fact our standby would be our next option if this is not possible on the
>>>> same database in almost real time.
>>>>
>>>>
>>>>
>>>> -DP
>>>>
>>>>
>>>>
>>>> On Thu, May 27, 2010 at 12:17 PM, Yechiel Adar <adar666@xxxxxxxxxxxx>wrote:
>>>>
>>>>> What oracle version?
>>>>>
>>>>> IIRC, in 11g you can use standby for read only while the apply is
>>>>> working in the background.
>>>>> So, you can create a stand by database and let the other 2 users make
>>>>> reports from there.
>>>>>
>>>>> Adar Yechiel
>>>>> Rechovot, Israel
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Dhimant Patel wrote:
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> I have Oracle Standard Edition installed and have two schema in use
>>>>>> (call it prodA, prodB) in this database. I wanted to create two
>>>>>> additional
>>>>>> schema(s) (copyA and copyB) and want to maintain both in sync with
>>>>>> original
>>>>>> schema(s). I know streams can not be used since it is only Enterprise
>>>>>> version feature. I currently use datapump for schema duplication but
>>>>>> this is
>>>>>> little bit different - since downtime is not acceptable (hence both
>>>>>> should
>>>>>> be in sync, almost!).
>>>>>>
>>>>>> I thought of following:
>>>>>>
>>>>>> 1> Instead create new users and allow full access to prodA and prodB
>>>>>> via synonyms and hope all is ok - since we now have four users and could
>>>>>> later on face issues of objects and links all over the place.
>>>>>>
>>>>>> Didn't like this idea.
>>>>>>
>>>>>>
>>>>>> 2> Use replication for all objects and copy them over to copyA and
>>>>>> copyB. It still wont allow copying of stored procedure code, which is
>>>>>> large
>>>>>> in our case.
>>>>>>
>>>>>>
>>>>>> 3> Could proxy user can help? But I think they are for external users
>>>>>> like in the case of application servers etc.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Any other ideas?
>>>>>> -Thanks,
>>>>>> DP.
>>>>>>
>>>>> --
>>>>> //www.freelists.org/webpage/oracle-l
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
Other related posts:
