This discussion is archived
7 Replies Latest reply: Apr 17, 2013 11:58 PM by gopal RSS

rman 10g to 11g?

538368 Newbie
Currently Being Moderated
Can one duplicate a 10.2.0.3 instance on AIX (6.1-03) to a 11.2.0.1 instance on AIX (6.1-04) using RMAN. I don't the copy to be consistent,
just want to test some stuff in 11g...
  • 1. Re: rman 10g to 11g?
    538368 Newbie
    Currently Being Moderated
    found a note in metalink, but is for 9i to 10g.. Not sure about 10g to 11g..
    anyone try it?


    ID 369644.1

    1) Can I restore or duplicate my previous version database using a later version of Oracle?

    For example, is it possible to restore a 9i backup while using the 10g executables?

    It is possible to use the 10.2 RMAN executable to restore a 9.2 database even if the restored datafiles will be stored in ASM. RMAN is configured so that a higher release is able to restore a lower release, but it is strongly suggested you use only the same version. In this scenario for a restore (not RMAN duplicate) you will be using the restored 9.2 database against 10.2 binaries. If you intend to run the restored 9.2 database against the 10.2 binary files you need to run the upgrade steps to make the restored 9.2 database a 10.2 database, but understand that the pre-upgrade checklist which you may have submitted against the source 9.2 database does NOT apply to this restored 9.2 database.

    Once the restore / recovery is completed you will need to open the database with a combination of the resetlogs option and the upgrade option. For example:
    SQL> alter database open resetlogs upgrade;

    After the database is opened in this fashion run the upgrade steps for the higher version. If you have any problems with any part of this process please open a service request. If you are restoring using backups created by an earlier release, some time after you have upgraded the database, then media recovery will re-play the changes that were made during the upgrade, and you do not need to run the upgrade scripts again.

    Because RMAN "duplicate" attempts to automatically open the database you may not use it for this case.
  • 2. Re: rman 10g to 11g?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Yes, you can restore a 10g RMAN backup into 11gR2

    See the documentation on compatibility :

    http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/compat003.htm#i634479


    Hemant K Chitale
  • 3. Re: rman 10g to 11g?
    Suddhasatwa_Bhaumik Newbie
    Currently Being Moderated
    Thanks for the info. I understand 10g RMAN backup can be used in 11g, but after the full backup restore of the DB running in 11g, do we have to upgrade the database once again ? Please advice.
    Thanks.
  • 4. Re: rman 10g to 11g?
    KuljeetPalSingh Guru
    Currently Being Moderated
    we can restore 10g database into 11g software home as we recently did same activity for upgrade.
    Please note database need to open like alter database open resetlogs upgrade; after recovery.


    yes,after restoration ,we've to upgrade this database into 11g by catupgrd.sql script.
  • 5. Re: rman 10g to 11g?
    993159 Newbie
    Currently Being Moderated
    Hi,

    Yes u can duplicate 10g RMAN backup to 11g . But remember below points

    1. db_name & undo parameter should be same in init.ora
    2. RMAN DUPLICATE wont work in this case as RMAN version will be different
    3. Open the database with resetlogs and run catupgrd.sql



    Thanks
  • 6. Re: rman 10g to 11g?
    Talip Hakan Ozturk Oracle ACE
    Currently Being Moderated
    Please follow the following steps

    http://taliphakanozturken.wordpress.com/2012/07/20/how-to-restore-10g-rman-backup-to-11g/

    Talip Hakan Ozturk
  • 7. Re: rman 10g to 11g?
    gopal Newbie
    Currently Being Moderated
    Check the below link. It worked for me.
    http://taliphakanozturken.wordpress.com/2012/07/20/how-to-restore-10g-rman-backup-to-11g/

Legend

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