Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

upgrade from 10.2.0.4 to 10.2.0.4 with RMAN

marlisJun 3 2014 — edited Jun 4 2014

I have RMAN cold backup of 10.2.0.4 database (RAC).

I must to restore database in 10.2.0.5 RAC environment.

After restoring 10.2.0.4 database on the new server in 10.2.0.5 environment (open nomunt, restore controlfile, mount, restore database),

1. I tried to open database using resetlogs. But error occured

ORA-01139 RESETLOGS option only valid after an incomplete database recovery

2. Then shut down database and tried to open in UPGRADE MODE, but another error occured -

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

Error 39701 happened during db open, shutting down database

3. Then shut down database and tried to open in EXCLUSIVE UPGRADE MODE , but another error occured -

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

Error 39701 happened during db open, shutting down database

How can I open and upgrade 10.2.0.4 database in 10.2.0.5 environment on different server?

PLZ HELP... Thanks in advance.

P.S.: Used file system is ASM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 2 2014
Added on Jun 3 2014
#database-upgrade
1 comment
1,071 views