Restoration of 10gR2 RMAN backupset onto 11gR1 database
I am trying to restore my RMAN backupset from 10gR2 RAC database onto 11gR1 RAC database, both on HP Itanium v11.31. I was wondering if anyone has tried this before?
RMAN> alter database open resetlogs;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/17/2012 21:45:48
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 11201
Session ID: 1185 Serial number: 139
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: not connected to ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/17/2012 21:45:48
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 11201
Session ID: 1185 Serial number: 139
After I had encountered this, I tried to startup with upgrade option and the database could be opened. Am I supposed to do anything after this? I tried logging into the database as another user but I encountered the following error:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Am I supposed to run any utlrp.sql script or something?