Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have RMAN backup from AIX server and want to restore on Linux OS. Could you please let me know if there is a way to do it?

Thanks a lot for help in this regard.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Query this table in order for you to see the platforms to which rman can convert your

SYS@EMR> select * from V$DB_TRANSPORTABLE_PLATFORM;

PLATFORM_ID PLATFORM_NAME                                                                                         ENDIAN_FORMAT
----------- ----------------------------------------------------------------------------------------------------- --------------
          7 Microsoft Windows IA (32-bit)                                                                         Little
         10 Linux IA (32-bit)                                                                                     Little
          5 HP Tru64 UNIX                                                                                         Little
         11 Linux IA (64-bit)                                                                                     Little
         15 HP Open VMS                                                                                           Little
          8 Microsoft Windows IA (64-bit)                                                                         Little
         13 Linux x86 64-bit                                                                                      Little
         12 Microsoft Windows x86 64-bit                                                                          Little
         17 Solaris Operating System (x86)                                                                        Little
         19 HP IA Open VMS                                                                                        Little
         20 Solaris Operating System (x86-64)                                                                     Little
         21 Apple Mac OS (x86-64)                                                                                 Little

Step by Step restore

  • Connect to the target database using rman and backup the database - Source Node/ System
  • copy following files to the Destination node ( backup pieces , control file backup and parameter file)

  • Perform the modificaiton on destionation node to parameter file - PFILE

  • Once the pfile is ready, set the environment parameter and connect to rman

  • connect to target - start up the db no mount mode

  • now restore the controlfile from the backup on destination node (which copied from source db )

Example :

restore controlfile from '/backup/file name'; 

once the restore is complete - mount the db.

  • now main step is backup prices which you copied from the source db to destination db catalog themcatalog the backup pieces.

  • Now, you need to recover the db - find he sequence number

    list backup of archivelog all;

  • Rename the Redologfiles

    alter database rename file

  • Now final step is you need to recover the db to the last sequence number

    Execute this series of statements:
    set until sequence 123456; -- sequence which you go previous. set newname for datafile 1 to '/node2/database/db1/system01.dbf'; -- data file paths modified

    restore database; 
    switch datafile all; 
    recover database; 
    alter database open resetlogs;
    

2 As a second approach this can be done using the Oracle Transportable Database - follow the link for great article form IBM guys !

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.