Matt,
Extra work? Not for the DBA, and not when you consider that the
"standard" RMAN approach requires three full copies (3x) of the database
being converted...
1. Original database in READ WRITE on UNIX (i.e. Solaris, HP-UX, AIX)
2. Copy of database in READ ONLY on UNIX (a.k.a. conversion "source")
* Creating this copy often needs to happen multiple times for TTS
and XPP "validation"
3. Copy of database in READ WRITE on Linux (a.k.a. conversion "target")
What Kyle describes uses about 1.3x of the size of the original
database, not 3.0x...
1. Original database in READ WRITE on UNIX (i.e. Solaris, HP-UX, AIX)
2. dSource of database (consuming 1/3rd the size of the original database)
* Copy of database in READ ONLY on UNIX (a.k.a. conversion
"source") consuming zero bytes and 5-10 mins to create
o Creating this copy often needs to happen multiple times for
TTS and XPP "validation"
* Copy of database in READ WRITE on Linux (a.k.a. conversion
"target") consuming less than 100 GB of storage
All of this may not matter when you're discussing cross-platform
migration of a small database, but small databases rarely cause
difficulties of any kind.
Besides, if you've done the process "manually", then having the whole
process employing TTS automated already should be very attractive.
I've also spent some time documenting the process online here
<https://community.delphix.com/delphix/topics/cross-platform-provisioning-xpp-or-unix-to-linux-u2l-is-the-first-step-to-migrate-to-the-cloud>,
if that helps?
Thanks!
-Tim
On 12/15/15 0:48, Dimensional DBA wrote:
Seems like extra unnecessary work Kyle, than just using the standard rman methodology proposed.
Deepak, what is your outage window allowed for this database?
*Matthew Parker*
*Chief Technologist*
*425-891-7934 (cell)*
*Dimensional.dba@xxxxxxxxxxx <mailto:Dimensional.dba@xxxxxxxxxxx>*
*View Matthew Parker's profile on LinkedIn* <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
*From:*oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *kyle Hailey
*Sent:* Monday, December 14, 2015 2:30 PM
*To:* Andrew Kerber
*Cc:* Deepak Sharma; ORACLE-L
*Subject:* Re: Migrate from AIX to Linux
Here is a blog post from last week of someone doing an AIX to Linux conversion as well as migrating the database to the cloud.
https://danielstolf.wordpress.com/2015/12/09/migrating-oracle-from-unix-to-linux-on-the-cloud-the-easy-way-3/
They used a free version of Delphix to do the conversion:
http://datavirtualizer.com/delphix-express-installation/
Delphix only has minimal impact on the time for conversion but does save the original and converted database in about 1/3 the size of the original database. For example if you had a 3 TB database, a copy of the original AIX database along with the converted LINUX database together would table up about 1 TB.
Best
Kyle
On Sat, Dec 12, 2015 at 7:39 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx <mailto:andrew.kerber@xxxxxxxxx>> wrote:
Sounds like it would work. I don't know how much time you have, but I would start with a small instance, even create one if necessary, and run through the initial, incremental, and final steps a few times to rehearse it before I tried it on your large instance. I have never found rehearsal time wasted on this type of project.
Sent from my iPad
On Dec 11, 2015, at 11:53 PM, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx <mailto:sharmakdeep_oracle@xxxxxxxxx>> wrote:
As I mentioned initially, we already do an RMAN IMAGE Copy backup
on regular basis. Fyi, the last time we may have done a fresh
Level-0 was a few years ago. Since then we've been applying the
daily incrementals to that Level-0, and moving it forward. So,
what that means is that the current Level-0 is a good Image Copy
backup that we can potentially use to create a brand new database
someplace else.
I looked at the FastXTTS method briefly (Doc 1389592.1) and it
says to take Image Copy backups of the Datafiles on the source
system.
So, seems like the following would be possible in our case:
1. Copy the RMAN Image Copy backup (latest) from Source to Dest
server's staging location (backup filesystems) - *stageondest
location*
2. Use the RMAN Convert command to convert all the datafiles. The
converted files would be copied to the real datafile locations on
destination server - *storageondest location*
"The convert datafiles step converts the datafiles copies in the
*stageondest*location to the endian format of the destination
system. The converted datafile copies are written in the location
specified by the xtt.properties parameter *storageondest*. This
is the final location where datafiles will be accessed when they
are used by the destination database."
Thoughts?
On Friday, December 11, 2015 3:38 PM, Andrew Kerber
<andrew.kerber@xxxxxxxxx <mailto:andrew.kerber@xxxxxxxxx>> wrote:
Nope. There is an endian conversion issue. However, Oracle does
now have a cross platform incremental backup option that you can
use, and if you have the licenses, you can do this with golden
gate also. Here is some information on the cross platform
incremental backup:
http://houseofbrick.com/fast-xtts-with-cross-platform-incremental-backup/
On Fri, Dec 11, 2015 at 3:20 PM, Deepak Sharma
<dmarc-noreply@xxxxxxxxxxxxx <mailto:dmarc-noreply@xxxxxxxxxxxxx>>
wrote:
We have a 11.2.0.4 DB on AIX and want to move it to HP Intel
Redhat Linux.
The new Linux server also has a new storage.
Currently we use RMAN Image Copy backups on the AIX server, do
incrementals every day and then merge those incrementals with the
previous Image, thereby moving the Image Copy current.
Question: Can we move the RMAN Image copy backup to the Linux
server, and convert it (endian conversion) using some RMAN command?
What I understand is that the RMAN "CONVERT TABLESPACE" on source
(AIX) and "CONVERT DATAFILE" on target (Linux), are the standard
method, but would require downtime on the source system (AIX).
I was wondering if the RMAN Image copy could somehow be used (as
described above), so we can still have the production system on
AIX up and running.
-thanks
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
