9 Replies Latest reply: Nov 10, 2010 1:39 AM by 812128 RSS

    rman restore diffrent paltform

    694352
      Hi

      I know that I can transport tablespaces from diffrent platfoms (unix to windos etc..) (10g)

      Can I use rman backup of the database to restore entire database to diffrent platform(unix to windows) rather than copying tablespaces one by one?
      I know that I have to catalog backup piece first, but just wondering if it works
        • 1. Re: rman restore diffrent paltform
          591186
          Yes. You can.

          Check the following Metalink Notes:
          How To Use RMAN CONVERT DATABASE on Source Host for Cross Platform Migration - 413586.1
          Cross-Platform Migration on Destination Host Using Rman Convert Database - Note 414878.1

          [http://youngcow.net/doc/oracle10g/backup.102/b14191/dbxptrn002.htm]
          [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm]

          -Anantha
          • 2. Re: rman restore diffrent paltform
            Pavan Kumar
            Hi,

            Follow the steps :-

            - 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
            - Onace 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 destinaton db - catlog them
            catalog the backup pieces.

            - Now, you need to recover the db - find he sequence number
            list backup of archivelog all;

            - Rename the Redologfiles
            user - alter database rename file

            - Now final step is you need to recover the db - tp to the last seqeunce number

            execute the series of statements

            set until sequence 3434; -- sequence which you go previous.
            set newname for datafile 1 to '/node2/database/prod/sys01.dbf'; -- data file paths modified
            ... ... -- change the data file names
            ..
            .

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

            HTH

            - Pavan Kumar N
            • 3. Re: rman restore diffrent paltform
              EdStevens
              Pavan Kumar wrote:
              Hi,

              Follow the steps :-

              - 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
              - Onace 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 destinaton db - catlog them
              catalog the backup pieces.

              - Now, you need to recover the db - find he sequence number
              list backup of archivelog all;

              - Rename the Redologfiles
              user - alter database rename file

              - Now final step is you need to recover the db - tp to the last seqeunce number

              execute the series of statements

              set until sequence 3434; -- sequence which you go previous.
              set newname for datafile 1 to '/node2/database/prod/sys01.dbf'; -- data file paths modified
              ... ... -- change the data file names
              ..
              .

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

              HTH

              - Pavan Kumar N
              I don't see where you allowed for the 'cross-platform' issues -- the 'endian-ness' of the files themselves.
              • 4. Re: rman restore diffrent paltform
                694352
                Thanks chaps.
                I was not aware of the "convert issue"



                Cheers
                • 5. Re: rman restore diffrent paltform
                  Pavan Kumar
                  Hi Steve,

                  I went for from node 1 to node 2 - I missed out that cross platform buddy.
                  Fine.. I will write the steps for that too.. ;-)

                  - Pavan Kumar N
                  • 6. Re: rman restore diffrent paltform
                    812128
                    Noone told about how to restore rman backup on another platform with different endian issue WITHOUT going for Transportable Tablespace.
                    I just need to restore my r-man backup from AIX to Linux which dont share the same endian unfortunately :(

                    Please add some more steps in above workout if required for diff endian platform
                    • 7. Re: rman restore diffrent paltform
                      sybrand_b
                      Oracle is a documented product.
                      Please do not ask to abstract documentation.

                      -------------
                      Sybrand Bakker
                      Senior Oracle DBA
                      • 8. Re: rman restore diffrent paltform
                        812128
                        not abstracting the documentation.. as earlier post from "Pavan Kumar" said he missed out the steps and will post the remaining steps, so asking for the remaining steps which he missed..

                        Edited by: 809125 on Nov 9, 2010 11:40 PM
                        • 9. Re: rman restore diffrent paltform
                          812128
                          and all i need to know is " whether is there any possiblity to restore rman backup on cross platform that dont share same endian or not?" if i Convert my datafile on Target to match the endian and then Backup these datafiles through R-man will i be able to restore it or not?

                          please advise

                          thanks