Moving a 10g database to 11g with rman backup

Posted on 2012-09-21
Last Modified: 2012-09-24
Following Doc ID 369644.1, I'm trying to restore a 10g database into a 11g database ( version, 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:\> 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;

Open in new window

After this step, I followed Doc ID 558408.1
SQL> connect sys/bdsprod as sysdba
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;

Open in new window

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

Open in new window

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\

Open in new window

Question by:miyahira
    LVL 76

    Accepted Solution

    When following note 558408.1 did you see the last line:
    4) Now follow the patchset upgrade steps.

    If "startup upgrade" works, now you need to actually perform the upgrade.

    I used the Migration assistant to move from 10g to 11g but I believe you now need to run catupgrd.sql.

    Then you can create an spfile from the pfile used to open the database.

    Check out:
    LVL 1

    Author Comment

    Thanks , slightwv.

    Just adding this:

    SR to Oracle just confirms that the direct upgrade from to is not possible. The minimum version required to upgrade to 11.2.0.X.X is
    As my Oracle source is and I don't want to touch it, it won't be possible for me to direct upgrade using rman.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now