10 Replies Latest reply: Nov 6, 2009 4:13 AM by Nicolas.Gasparotto RSS

    ORA-00704: bootstrap process failure ORA-39700: database must be opened wit

    615123
      Hi,

      I have oracle 10.2.0.1.0 installed on redhat 4 linux i take cold backup of my database and want to copy it on windows 2008 server 64 bit having oracle 10.2.0.3.0 installed.

      i recreate my controlfiles but when i start database i got this error i need to upgrade. i do it.
      SQL> CREATE CONTROLFILE REUSE DATABASE "NEO" RESETLOGS  ARCHIVELOG
        2      MAXLOGFILES 16
        3      MAXLOGMEMBERS 3
        4      MAXDATAFILES 100
        5      MAXINSTANCES 8
        6      MAXLOGHISTORY 292
        7  LOGFILE
        8    GROUP 1 (
        9      'C:\oracle\product\10.2.0\oradata\neo\redo01.log',
       10      'C:\oracle\product\10.2.0\oradata\neo\redo01_1.log'
       11    ) SIZE 50M,
       12    GROUP 2 (
       13      'C:\oracle\product\10.2.0\oradata\neo\redo02.log',
       14      'C:\oracle\product\10.2.0\oradata\neo\redo02_1.log'
       15    ) SIZE 50M,
       16    GROUP 3 (
       17      'C:\oracle\product\10.2.0\oradata\neo\redo03.log',
       18      'C:\oracle\product\10.2.0\oradata\neo\redo03_1.log'
       19    ) SIZE 50M
       20  -- STANDBY LOGFILE
       21  DATAFILE
       22    'C:\oracle\product\10.2.0\oradata\neo\system01.dbf',
       23    'C:\oracle\product\10.2.0\oradata\neo\undotbs01.dbf',
       24    'C:\oracle\product\10.2.0\oradata\neo\sysaux01.dbf',
       25    'C:\oracle\product\10.2.0\oradata\neo\users01.dbf'
       26  CHARACTER SET WE8ISO8859P1
       27  ;
      
      Control file created.
      
      SQL> shutdown immediate
      ORA-01109: database not open
      
      
      Database dismounted.
      ORACLE instance shut down.
      SQL> startup upgrade resetlogs;
      SP2-0714: invalid combination of STARTUP options
      SQL> startup upgrade;
      ORACLE instance started.
      
      Total System Global Area  289406976 bytes
      Fixed Size                  1290184 bytes
      Variable Size              96469048 bytes
      Database Buffers          184549376 bytes
      Redo Buffers                7098368 bytes
      Database mounted.
      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
      
      
      SQL> alter database open resetlogs;
      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01092: ORACLE instance terminated. Disconnection forced
      This is my alert log file

      rrors in file c:\oracle\product\10.2.0\admin\neo\udump\neo_ora_2860.trc:
      ORA-00704: bootstrap process failure
      ORA-39700: database must be opened with UPGRADE option

      Fri Nov 06 00:15:42 2009
      Error 704 happened during db open, shutting down database
      USER: terminating instance due to error 704
      ARC1 started with pid=17, OS id=7264
      Fri Nov 06 00:15:43 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_pmon_6268.trc:
      ORA-00704: bootstrap process failure

      Fri Nov 06 00:15:44 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_reco_5760.trc:
      ORA-00704: bootstrap process failure

      Fri Nov 06 00:15:44 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_lgwr_3900.trc:
      ORA-00704: bootstrap process failure

      Fri Nov 06 00:15:44 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_dbw0_7956.trc:
      ORA-00704: bootstrap process failure

      Fri Nov 06 00:15:44 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_ckpt_3192.trc:
      ORA-00704: bootstrap process failure

      Fri Nov 06 00:15:44 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_smon_7112.trc:
      ORA-00704: bootstrap process failure

      Fri Nov 06 00:15:45 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_mman_6644.trc:
      ORA-00704: bootstrap process failure

      Fri Nov 06 00:15:46 2009
      Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_psp0_5708.trc:
      ORA-00704: bootstrap process failure

      Instance terminated by USER, pid = 2860
      ORA-1092 signalled during: alter database open resetlogs...



      Please suggest how to upgrade and open database with resetlogs.

      Thanks
      umesh
        • 1. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
          Nicolas.Gasparotto
          You'er doing
          1. database move across plateform
          2. an upgrade
          That cannot work so simple as you did.
          Please, read carefully the following thread :
          Database Migration

          You should :
          1. manage a database conversion (if possible regarding the endianess of your both OS)
          2. an upgrade

          Nicolas.
          • 2. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
            615123
            Thanks for you reply

            But i did it on two local servers one is redhat 4 another windows xp both have oracle 10.2.0.1.0 and it is done that's why i am doing to for live.

            Here the only difference is My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0. If i install oracle 10.2.0.1.0 on destination will it work.

            please suggest.

            Thanks
            umesh
            • 3. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
              Nicolas.Gasparotto
              Umesh Sharma wrote:
              Thanks for you reply

              But i did it on two local servers one is redhat 4 another windows xp both have oracle 10.2.0.1.0 and it is done that's why i am doing to for live.
              That is wrong way to move database across plateform.
              Here the only difference is My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0. If i install oracle 10.2.0.1.0 on destination will it work.

              please suggest.
              I already suggested.

              As I said in the thread I linked above, check the DATABASE CONVERT doc :
              http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDCFFDI

              Nicolas.
              • 4. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
                Niall Litchfield
                N. Gasparotto wrote:
                Umesh Sharma wrote:
                Thanks for you reply

                But i did it on two local servers one is redhat 4 another windows xp both have oracle 10.2.0.1.0 and it is done that's why i am doing to for live.
                That is wrong way to move database.
                Here the only difference is My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0. If i install oracle 10.2.0.1.0 on destination will it work.

                please suggest.
                I already suggested.

                Nicolas.
                To do what you are trying to do you should perform the upgrade first on the source and only then do the cross platform move. It's likely that this isn't the best way of achieving your business goals though, but you haven't told us what those are. (or if both servers are running 64bit Oracle).

                Niall Litchfield
                http://www.orawin.info/
                • 5. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
                  615123
                  Thanks for reply.

                  If i use RMAN Cross-Platform Transportable Databases then is it ok to have two different oracle versions on source or destination like

                  My source server have oracle 10.2.0.1.0 and destination have oracle 10.2.0.3.0.
                  • 6. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
                    Nicolas.Gasparotto
                    Could you manage an upgrade on source ? Probably the simplest way.
                    Or you could try to upgrade the database once it is converted and up on target OS.

                    Nicolas.
                    • 7. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
                      615123
                      Thanks for your reply

                      Actually i don't have license for oracle 10g. than can you please tell me the process of upgrade.
                      • 8. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
                        Nicolas.Gasparotto
                        Umesh Sharma wrote:
                        Thanks for your reply

                        Actually i don't have license for oracle 10g. than can you please tell me the process of upgrade.
                        http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

                        Nicolas.
                        • 9. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
                          615123
                          Thanks for your support

                          i do it using RMAN RMAN Cross-Platform Transportable Databases and facing the same problem i.e. main issue is different version of oracle .

                          have a look.
                          SQL> startup nomount
                          ORACLE instance started.
                          
                          Total System Global Area  289406976 bytes
                          Fixed Size                  1290184 bytes
                          Variable Size              96469048 bytes
                          Database Buffers          184549376 bytes
                          Redo Buffers                7098368 bytes
                          SQL> CREATE CONTROLFILE REUSE DATABASE "NEO" RESETLOGS  NOARCHIVELOG
                            2      MAXLOGFILES 16
                            3      MAXLOGMEMBERS 3
                            4      MAXDATAFILES 100
                            5      MAXINSTANCES 8
                            6      MAXLOGHISTORY 292
                            7  LOGFILE
                            8    GROUP 1 (
                            9      'C:\oracle\product\10.2.0\oradata\neo\redo01.log',
                           10      'C:\oracle\product\10.2.0\oradata\neo\redo01_1.log'
                           11    ) SIZE 50M,
                           12    GROUP 2 (
                           13      'C:\oracle\product\10.2.0\oradata\neo\redo02.log',
                           14      'C:\oracle\product\10.2.0\oradata\neo\redo02_1.log'
                           15    ) SIZE 50M,
                           16    GROUP 3 (
                           17      'C:\oracle\product\10.2.0\oradata\neo\redo03.log',
                           18      'C:\oracle\product\10.2.0\oradata\neo\redo03_1.log'
                           19    ) SIZE 50M
                           20  -- STANDBY LOGFILE
                           21  DATAFILE
                           22    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-SYSAUX_F
                          NO-3_0skt4iua',
                           23    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-SYSTEM_F
                          NO-1_0rkt4ith',
                           24    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-UNDOTBS1
                          _FNO-2_0tkt4iv3',
                           25    'C:\oracle\product\10.2.0\oradata\neo\data_D-NEO_I-1778762914_TS-USERS_FN
                          O-4_0qkt4irg'
                           26  CHARACTER SET WE8ISO8859P1
                           27  ;
                          
                          Control file created.
                          
                          SQL> ALTER DATABASE OPEN RESETLOGS;
                          ALTER DATABASE OPEN RESETLOGS
                          *
                          ERROR at line 1:
                          ORA-01092: ORACLE instance terminated. Disconnection forced
                          alert log file
                          ORA-00704: bootstrap process failure
                          ORA-39700: database must be opened with UPGRADE option
                          
                          Fri Nov 06 01:36:00 2009
                          Error 704 happened during db open, shutting down database
                          USER: terminating instance due to error 704
                          Fri Nov 06 01:36:00 2009
                          Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_pmon_7244.trc:
                          ORA-00704: bootstrap process failure
                          
                          Fri Nov 06 01:36:01 2009
                          Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_reco_1128.trc:
                          ORA-00704: bootstrap process failure
                          
                          Fri Nov 06 01:36:01 2009
                          Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_smon_4080.trc:
                          ORA-00704: bootstrap process failure
                          
                          Fri Nov 06 01:36:01 2009
                          Errors in file c:\oracle\product\10.2.0\admin\neo\bdump\neo_ckpt_4256.trc:
                          ORA-00704: bootstrap process failure
                          Finally i need to upgrade my source database.

                          Thanks
                          umesh
                          • 10. Re: ORA-00704: bootstrap process failure ORA-39700: database must be opened wit
                            Nicolas.Gasparotto
                            Without being licensed, and without access to Metalink, you cannot get the patchset 10.2.0.3 to manage the upgrade on RHEL.
                            So, you probably should think about an other way, like export/import.

                            Nicolas.