Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Moving a 10g database to 11g with rman backup

Posted on 2012-09-21
2
Medium Priority
?
2,721 Views
Last Modified: 2012-09-24
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;

Open in new window


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;

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\
DATABASE\INITBDSPROD.ORA'

Open in new window

0
Comment
Question by:miyahira
2 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 38423795
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:
http://taliphakanozturken.wordpress.com/2012/07/20/how-to-restore-10g-rman-backup-to-11g/
0
 
LVL 1

Author Comment

by:miyahira
ID: 38430682
Thanks , slightwv.

Just adding this:

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

580 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