Hi Folks.
Got myself into a little bit of a pickle here. Can anyone advise?
The following is on Solaris 10
I have a live database on oracle home.
I have a test oracle home on

My user wants a copy of the live database into the test environment.

The test environment is at because they have upgraded their test system application version a few releases ahead of their live application version. The test version requires

When i restore backup of live to the test box and try to

recover database using backup control file until cancel ;


alter database open resetlogs ;

I get a disconnection forced, the alert log tells me
ORA-00704: bootstrap process failure
   355  ORA-39700: database must be opened with UPGRADE option
   356  Mon Oct 03 10:29:57 BST 2011
   357  Error 704 happened during db open, shutting down database
   358  USER: terminating instance due to error 704
   359  Instance terminated by USER, pid = 16343
   360  ORA-1092 signalled during: alter database open resetlogs ...
fairly self explanatory i suppose.
I had set compatible to be in the pfile hoping it would work but it didn't.

How do i open in upgrade mode if i am at the point of re-creating database.

Do i just run startup upgrade once the controlfile is created?

or after
recover database using backup controlfile until cancel ;

should i shutdown immediate followed by startup upgrade?

never come across this but having had to restore from backup three times now it is getting quite time consuming so hoping someone can advise so i don't screw it up again and have to restore yet again.