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

2 Answers 2

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

Use datapump if you want platform independency (windows to linux and vice versa)

exdp imdp

I can send you my classnotes if you want. Today's lesson was about datapump lol.

share|improve this answer
    
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post. –  Colin 't Hart Nov 27 at 8:53
    
@Colin'tHart, seems like a legitimate answer - although not very well prepared. –  ypercube Nov 27 at 11:49
    
Well, my thinking was as follows: the first sentence is OK, but not an answer IMHO, just a comment that datapump is -- or might be possible to be run as -- platform independent, with no information as to how or why this is achieved. The second sentence adds nothing and is wrong. The third sentence is definitely a comment, but I don't know @Ahmed plans to send his classnotes. –  Colin 't Hart Nov 27 at 12:28
    
@ypercube yeah sorry for the nonthorough answer. I wasnt at my computer. –  Ahmed Nov 27 at 17:36
    
I thought if it was important he could look it up. RMAN according to my mentor isnt as platform independent.. Ill add the exdp and imdp code soon. –  Ahmed Nov 27 at 17:38

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.