opening database in upgrade mode
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 10.2.0.4.0 oracle home.
I have a test oracle home on 10.2.0.5.0
My user wants a copy of the live database into the test environment.
The test environment is at 10.2.0.5 because they have upgraded their test system application version a few releases ahead of their live application version. The test version requires 10.2.0.5
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
fairly self explanatory i suppose.
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 ...
I had set compatible to be 10.2.0.4.0 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?
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.