Re: move AWR warehouse from Soalris Sparc to Linux x86_64

ok so I have to use the same scripts we used to move production AWR to this warehouse...

Thanks all

On Fri, Mar 16, 2018 at 7:53 PM, Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> wrote:

> What you need to use are the awrextr.sql and awrimp.sql scripts in the
> Oracle home /rdbms/admin directory to move the data across. You'll have to
> do this after building a new warehouse, post setting it up and then disable
> the jobs while you update the Metadata that supports the jobs, retention,
> etc.
> One the data is imported and Metadata matching, then you can turn the jobs
> back on.
>
> A move simply want built into the design, so it's not easy.
>
> Thanks
> Kellyn
>
> On Fri, Mar 16, 2018 at 1:35 PM Ls Cheng <exriscer_at_gmail.com> wrote:
>
>> Hi
>>
>> I have an AWR Warehouse setup in Solaris Sparc storing 50 production
>> databases AWRmetrics retaining for a year. I need to move this database to
>> Linux and here is the dilemma, everything in AWR Warehouse is under SYS and
>> stored in SYSAUX, AFAIK SYS and SYSAUX are not exprtable neither with Data
>> Pump nor TTS, so I wonder what is the best way to move this database from
>> Solaris Sparc Big Endian to Linux x86_64 Small Endian?
>>
>> Running 11.2.0.4
>>
>> TIA!
>>
>>
>> --
>
>
> [image: Kellyn Pot'Vin on about.me]
>
> *Kellyn Pot'Vin-Gorman*
> DBAKevlar Blog <http://dbakevlar.com>
> President Rocky Mtn. Oracle User Group <http://www.rmoug.org/>
> President Denver SQL Server User Group <http://denversql.org/>
> about.me/dbakevlar
>
>

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