Re: Fwd: RE: convert big endian to medium endian

Hello Jonathan,

sorry for the confusion.

the productive db is about 16 TB (11.2.0.4 on AIX) and has about 4,5 Mio Partitions and every day come about 1000 partitions. And the metadata export takes 3 days 4 hours. The DBA I think is very experienced he had already find out that the export is slow because of known bug in 11.2.0.4 (he sent me the MOS ID and has mentioned that the problem is related to an x$k... view - Monday I will send the exact information). Unfortunately I haven't shown much interest to this information (big mistake) because I thought that the problem is because of our application design (and this is only my opinion as developer ) and also I thought that it should be possible somehow to convert the whole db without the need to use the datapump for the metadata (from the theory I think it is possible - but as I realized now it is in the practice tough )

And to check my assumption that we can convert all db datafiles (the datafiles for the metadata too) using c or c++ I use a 10GB big DB.

Thanks and regards
Ahmed

Am Sa., 8. Feb. 2020 um 16:16 Uhr schrieb Ahmed Fikri <gherrami_at_gmail.com>:

> Hi Mladen, Norm,
>
> thanks a lot. Our dba has also mentioned GG as possible solution and he is
> about to check how to realize this.
>
> I think changing the endian format of the whole DB should be an easy task
> for oracle to implement. But maybe oracle sees that there is no need for
> that no use case. And it is rare when the user need to migrate the db to
> another CPU architecture and even for that the user can use XTTS for the
> data + datapump for the metadata.
>
> Even this use case is rare i will try to write an converter, just to learn
> more about oracle.
>
> Thanks and regards
> Ahmed
>
>
>
>
> Am Sa., 8. Feb. 2020 um 16:00 Uhr schrieb Mladen Gogala <
> gogala.mladen_at_gmail.com>:
>
>> Hi Ahmed,
>>
>> Yes, Golden Gate can do that without RMAN. GG can do it even with
>> another DB, like SQL Server. Golden Gate is, in my humble opinion, the
>> best solution because it will minimize your downtime. So can SharePlex
>> from Quest. I am mentioning SharePlex because Quest has an option to
>> rent you a license for 6 months or a year, until you complete your
>> project. I am not sure that Oracle has such an option. I have very good
>> experience with SharePlex from few years ago.
>>
>> Regards
>>
>> On 2/8/20 5:07 AM, Ahmed Fikri wrote:
>> >
>> >
>> > We are also investigating goldengate possibly. But now just for my
>> > understanding I want to find a way to do that without rman. Only with
>> > the old things datafiles, linux, etc
>> >
>> > Thanks and regards
>> > Ahmed
>>
>> --
>> Mladen Gogala
>> Database Consultant
>> Tel: (347) 321-1217
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>

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