Re: Migrate from AIX to Linux

  • From: "Deepak Sharma" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "sharmakdeep_oracle" for DMARC)
  • To: "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>
  • Date: Sat, 12 Dec 2015 05:53:42 +0000 (UTC)

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.'

Other related posts: