Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, suresh.

Asked: February 07, 2019 - 10:50 pm UTC

Last updated: February 08, 2019 - 7:11 am UTC

Version: RHEL 7

Viewed 1000+ times

You Asked

Hi All,

We have 70 TB Database sitting in Solaris Sparc . We are migrating oracle from Solaris to RHEL 7.

i am looking for best approach for moving data from Solaris to rhel with minimal downtime.

Could you please let me know what would be the best process achieve my goal.

Thanks for ur support.

and Connor said...

We have a feature called "cross-platform incremental backups". In a nutshell the process is:

- take a full backup of solaris db
- run a convert program which make the backup a linux backup
- restore the backup to your linux machine

Now before you panic, you do this *not* as part of your migration - it is a preliminary step. You are still running your solaris system and you didn't need to shutdown anything. You do all this live.

You now have a linux system but obviously its "stale". We now do this:

- take an incremental backup on solaris
- run a convert program which make the backup a linux incremental backup
- recovery the incremental to bring your linux db up to date

Same rules apply - you do all this live. No outage yet.

You can do this part as often as you like - at some stage you will decide on a "final" cutover which is:

- shutdown (or disable all access) to solaris
- take a FINAL incremental backup on solaris
- run a convert program which make the backup a linux incremental backup
- recovery the incremental to bring your linux db up to date
- switchover

To make a LOT of this easier, we have a suite of Perl scripts to manage a lot of this automatically. You can get them from MOS Note: 2471245.1 – V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.