DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: opening database in upgrade mode

  1. #1
    Join Date
    Oct 2008
    Posts
    69

    opening database in upgrade mode

    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 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 ;

    cancel

    alter database open resetlogs ;

    I get a disconnection forced, the alert log tells me
    Code:
    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 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?

    or after
    recover database using backup controlfile until cancel ;
    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.

  2. #2
    Join Date
    Oct 2008
    Posts
    69
    could it be that i do

    alter database open resetlogs upgrade

    ?

  3. #3
    Join Date
    Oct 2008
    Posts
    69
    Quote Originally Posted by philthee View Post
    could it be that i do

    alter database open resetlogs upgrade

    ?
    yes that works. I suppose i should RTFM before posting.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width