This discussion is archived
4 Replies Latest reply: Jan 4, 2013 7:50 AM by 981071 RSS

How to Backup Database on Solaris and Restore to Windows

981071 Newbie
Currently Being Moderated
I have a database we're migrating to a new server. unfortunately, the server is Oracle 10.2 on a Windows Server and it originally was on a Oracle 10.2 Solaris OS. The size and production nature of the database does not allow us to take it offline for extended periods of time. The best option we see is to restore a full backup and use partial backups to keep it up todate inorder to facilitate a proper migration.

We're having problems restoring the database, I beleive that it was not properly prepared for the transition to the Windows OS platform. I'm at a loss of what to do at this point (lack of experience with this specifically).

Any suggestions?

Thank you.
  • 1. Re: How to Backup Database on Solaris and Restore to Windows
    mseberg Guru
    Currently Being Moderated
    Hello;

    This gives a good overview ( but moves from Windows )

    Database Migration From Windows to Linux Using RMAN

    https://blogs.oracle.com/AlejandroVargas/entry/database_migration_from_window

    This is another good one for starting your plan

    HOWTO: Oracle Cross-Platform Migration with Minimal Downtime

    http://www.pythian.com/news/3653/howto-oracle-cross-platform-migration-with-minimal-downtime/

    Best Regards

    mseberg
  • 2. Re: How to Backup Database on Solaris and Restore to Windows
    Victor Armbrust Oracle ACE
    Currently Being Moderated
    Since the platforms are different, You should use TDB ou TTS. Pay attention that Windows and Solaris (OE) have different endian format, so you'll need to use RMAN CONVERT.
    For Solaris (x86) you'll not need RMAN CONVERT.

    More information

    Platform Migration Using Transportable Database Oracle Database 11g and 10g Release 2
    http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-platformmigrationtdb-131164.pdf

    Platform Migration using Transportable Tablespaces: Oracle Database 10g Release 2
    http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-platformmigrationtts-129296.pdf


    How to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1]     
    SQL> COLUMN PLATFORM_NAME FORMAT A32
    SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM;
    
    PLATFORM_ID PLATFORM_NAME                    ENDIAN_FORMAT
    ----------- -------------------------------- --------------
              1 Solaris[tm] OE (32-bit)          Big
              2 Solaris[tm] OE (64-bit)          Big
              7 Microsoft Windows IA (32-bit)    Little
             10 Linux IA (32-bit)                Little
              6 AIX-Based Systems (64-bit)       Big
              3 HP-UX (64-bit)                   Big
              5 HP Tru64 UNIX                    Little
              4 HP-UX IA (64-bit)                Big
             11 Linux IA (64-bit)                Little
             15 HP Open VMS                      Little
              8 Microsoft Windows IA (64-bit)    Little
              9 IBM zSeries Based Linux          Big
             13 Linux 64-bit for AMD             Little
             16 Apple Mac OS                     Big
             12 Microsoft Windows 64-bit for AMD Little
             17 Solaris Operating System (x86)   Little
    att
    Victor
  • 3. Re: How to Backup Database on Solaris and Restore to Windows
    Mihael Pro
    Currently Being Moderated
    If endian of databases are the same (i.e. you use Solaris x86 platform), then you can upgrade source database to 11g and create standby database on Windows as 11g supports cross-platform standby. Then just move to stanby database.
  • 4. Re: How to Backup Database on Solaris and Restore to Windows
    981071 Newbie
    Currently Being Moderated
    This was great information. It gives me plenty of documentation to move forward. I had a few questions about TSPITR across platforms, but i think i'll RTFM first. This gives me hope that I can overcome this obstacle.

    Thank you for your help!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points