This discussion is archived
5 Replies Latest reply: Sep 22, 2012 10:46 AM by Srini Chavali-Oracle RSS

Moving a 10g database to 11g with rman backup

user521219 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    ORA-39700: database must be opened with UPGRADE option
  • 2. Re: Moving a 10g database to 11g with rman backup
    EdStevens Guru
    Currently Being Moderated
    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
    KuljeetPalSingh Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    Pl see the steps in this MOS Doc

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

    HTH
    Srini

Legend

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