Thank you all for your feedback. We'll dig into your suggestions.
In a related discussion, there was a mention of using GoldenGate to achieve the
transport from AIX to Linux.
Thoughts ?
On Tuesday, October 27, 2015 10:28 AM, Tim Gorman <tim@xxxxxxxxx> wrote:
Shameless plug follows, but hey! it's definitely relevant...
Delphix data virtualization also supports (and improves upon)
cross-platform provisioning (a.k.a. UNIX-to-Linux or "U2L").
Cross-platform provisioning has an initial validation step that requires
the use of the DBMS_TDB.CHECK_DB procedure against a READ ONLY
database. Since I'm betting that you can't set your production database
to READ ONLY even for a moment, this would necessitate creating a copy
of that 100TB database so that you can do so. Creating a 100TB virtual
database is a whole lot faster and easier than creating a 100 TB
physical database, and setting that virtual database to READ ONLY has no
impact on production.
In the same way, after the validation (presumably) succeeds and during
conversion, Delphix automates the steps of creating a virtual database
to act as a READ ONLY source and then also automates and orchestrates
the transportable tablespace (TTS) operations for the RMAN CONVERT
DATAFILE to create a virtual Linux database. Both virtual databases
(i.e. source and target) take up practically no space even with the
endian-conversion, but the two longest-running operations are the TTS
metadata export/import (which is single-threaded through Data Pump) and
the RMAN CONVERT DATAFILES themselves, which are parallelized but still
involve copying every bytes of database from source to target.
Data virtualization works really well for creating test images of the
converted Linux database to test the migrated application. For doing
the final cutover of AIX to Linux, data virtualization can also
"re-hydrate" a physical copy from the converted virtual copy, but for
some requirements this may be an overly lengthy process.
On 10/26/15 23:58, Oracle List (Redacted sender sharmakdeep_oracle for
DMARC) wrote:
What are some of the options of migrating version 11.2.0.4 DB, 100TB sized
database from AIX to Linux. This question relates to only Storage element,
like Endian conversion.
--
//www.freelists.org/webpage/oracle-l
