Does any of your application tables have longs, clobs or blobs in them?
Matthew Parker
Chief Technologist
425-891-7934 (cell)
Dimensional.dba@xxxxxxxxxxx
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's
profile on LinkedIn
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Deepak Sharma (Redacted sender "sharmakdeep_oracle" for DMARC)
Sent: Tuesday, December 15, 2015 9:53 PM
To: Dimensional DBA; kylelf@xxxxxxxxx; 'Andrew Kerber'
Cc: 'ORACLE-L'
Subject: Re: Migrate from AIX to Linux
We are still trying to see what the options are, but I would say about 48hrs
(over a weekend).
-thanks
On Tuesday, December 15, 2015 1:49 AM, Dimensional DBA
<dimensional.dba@xxxxxxxxxxx> 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
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's
profile on LinkedIn
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> 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>
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>
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>
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.'
