move AWR warehouse from Soalris Sparc to Linux x86_64
From: Ls Cheng <exriscer_at_gmail.com>
Date: Fri, 16 Mar 2018 18:35:12 +0100
Message-ID: <CAJ2-Qb_vuwPTEsFV6FTi81crDhZ7zAKj1+FRJe609i5xqCQ=3A_at_mail.gmail.com>
Hi
Date: Fri, 16 Mar 2018 18:35:12 +0100
Message-ID: <CAJ2-Qb_vuwPTEsFV6FTi81crDhZ7zAKj1+FRJe609i5xqCQ=3A_at_mail.gmail.com>
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!
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 16 2018 - 18:35:12 CET