5 Replies Latest reply: Sep 22, 2012 12:46 PM by Srini Chavali-Oracle RSS

    Moving a 10g database to 11g with rman backup

    user521219
      Hello,
      Following Doc ID 369644.1, I'm trying to restore a 10g database into a 11g database ( version 11.2.0.1.0), which is in other server.

      What I did on 11g server:
      - Generate full rman backup of 10g database
      - Copy pfile, control file and full rman backup from 10g to 11g
      C:\> oradim -new -sid BDSPROD -intpwd bdsprod
      C:\> SET ORACLE_SID=BDSPROD
      C:\> rman
      RMAN> connect target sys
      RMAN> SET DBID=367107039
      RMAN> STARTUP force nomount PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora
      RMAN> restore controlfile from 'C:\app\oracle\product\11.2.0\dbhome_1\database\CTRLFILE_BDSPROD.CTL';
      RMAN> alter database mount;
      RMAN> crosscheck backupset;
      RMAN> delete expired backupset;
      RMAN> catalog start with 'D:\RMAN_bdsprod\';
      RMAN> restore database;
      RMAN> recover database;
      After this step, I followed Doc ID 558408.1
      SQL> connect sys/bdsprod as sysdba
      Connected.
      SQL> alter database open resetlogs upgrade;
      Now, how can I startup database? It seems that only way is doing:
      SQL> STARTUP upgrade PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;
      In that way, only sysdba can connect to database.
      Other ways like just "startup" or "startup pfile=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;" it gets errors.
      Is there any way to start 11g database?
      SQL> startup PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;
      ORA-32006: BACKGROUND_DUMP_DEST initialization parameter has been deprecated
      ORA-32006: USER_DUMP_DEST initialization parameter has been deprecated
      ORACLE instance started.
      Total System Global Area 709836800 bytes
      Fixed Size 2179136 bytes
      Variable Size 201330624 bytes
      Database Buffers 499122176 bytes
      Redo Buffers 7204864 bytes
      Database mounted.
      ORA-01092: ORACLE instance terminated. Disconnection forced
      ORA-00704: bootstrap process failure
      ORA-39700: database must be opened with UPGRADE option
      Process ID: 12712
      Session ID: 5 Serial number: 3
      SQL> startup
      ORA-01078: failure in processing system parameters
      LRM-00109: could not open parameter file 'C:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\
      DATABASE\INITBDSPROD.ORA'
      Edited by: user521219 on 21-sep-2012 16:00
        • 1. Re: Moving a 10g database to 11g with rman backup
          sb92075
          ORA-39700: database must be opened with UPGRADE option
          • 2. Re: Moving a 10g database to 11g with rman backup
            EdStevens
            user521219 wrote:
            Hello,
            Following Doc ID 369644.1, I'm trying to restore a 10g database into a 11g database ( version 11.2.0.1.0), which is in other server.

            What I did on 11g server:
            - Generate full rman backup of 10g database
            - Copy pfile, control file and full rman backup from 10g to 11g
            C:\> oradim -new -sid BDSPROD -intpwd bdsprod
            C:\> SET ORACLE_SID=BDSPROD
            C:\> rman
            RMAN> connect target sys
            RMAN> SET DBID=367107039
            RMAN> STARTUP force nomount PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora
            RMAN> restore controlfile from 'C:\app\oracle\product\11.2.0\dbhome_1\database\CTRLFILE_BDSPROD.CTL';
            RMAN> alter database mount;
            RMAN> crosscheck backupset;
            RMAN> delete expired backupset;
            RMAN> catalog start with 'D:\RMAN_bdsprod\';
            RMAN> restore database;
            RMAN> recover database;
            After this step, I followed Doc ID 558408.1
            SQL> connect sys/bdsprod as sysdba
            Connected.
            SQL> alter database open resetlogs upgrade;
            Now, how can I startup database? It seems that only way is doing:
            SQL> STARTUP upgrade PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;
            In that way, only sysdba can connect to database.
            Other ways like just "startup" or "startup pfile=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;" it gets errors.
            Is there any way to start 11g database?
            SQL> startup PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;
            ORA-32006: BACKGROUND_DUMP_DEST initialization parameter has been deprecated
            ORA-32006: USER_DUMP_DEST initialization parameter has been deprecated
            ORACLE instance started.
            Total System Global Area 709836800 bytes
            Fixed Size 2179136 bytes
            Variable Size 201330624 bytes
            Database Buffers 499122176 bytes
            Redo Buffers 7204864 bytes
            Database mounted.
            ORA-01092: ORACLE instance terminated. Disconnection forced
            ORA-00704: bootstrap process failure
            ORA-39700: database must be opened with UPGRADE option
            Process ID: 12712
            Session ID: 5 Serial number: 3
            SQL> startup
            ORA-01078: failure in processing system parameters
            LRM-00109: could not open parameter file 'C:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\
            DATABASE\INITBDSPROD.ORA'
            Edited by: user521219 on 21-sep-2012 16:00
            after you do the startup upgrade, you are supposed to run some upgrade scripts. http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

            Edited by: EdStevens on Sep 21, 2012 6:08 PM
            • 3. Re: Moving a 10g database to 11g with rman backup
              kuljeet singh -
              SQL> alter database open resetlogs upgrade;
              Now, how can I startup database? It seems that only way is doing:
              after issue above cmd( open resetlogs upgrade) the database is open in upgrade mode and now you have to perform the manual upgrade.
              • 4. Re: Moving a 10g database to 11g with rman backup
                Veeresh.S
                After this step, I followed Doc ID 558408.1
                SQL> connect sys/bdsprod as sysdba
                Connected.
                SQL> alter database open resetlogs upgrade;
                Now, how can I startup database? It seems that only way is doing:
                SQL> STARTUP upgrade PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;
                In that way, only sysdba can connect to database.
                you have to run few scripts in upgrade mode like catupgrd.sql.
                refer this link http://taliphakanozturken.wordpress.com/2012/07/20/how-to-restore-10g-rman-backup-to-11g/ continue from 7th step

                also refer http://onlineappsdba.com/index.php/2009/01/22/upgrade-oracle-database-10g-to-11g-r1-111x/

                Edited by: Veeresh.S on Sep 22, 2012 11:52 AM
                • 5. Re: Moving a 10g database to 11g with rman backup
                  Srini Chavali-Oracle
                  Pl see the steps in this MOS Doc

                  RMAN Restore of Backups as Part of a Database Upgrade [ID 790559.1]

                  HTH
                  Srini