Steps for Windows on the example of upgrading from 11.2.0.2.0 to 11.2.0.4.0. For other OS need to make amendments to the specific features, such as: names of environment variables, file paths, operating system commands, etc.

  1. Make a backup.
  2. Perform, for example, in sqlplus ( ” sqlplus / as sysdba“) as follows:
    • Optionally, it is possible:
      alter system switch logfile;
    • In fact, we get a team creating control-file only in one version – a RESETLOGS:
      alter database backup controlfile to trace as 'c: \ control.bkp' resetlogs;
    • Create init.ora is ORACLE_HOME to be able to start a new instance with the old settings, for example:
      create pfile = 'C: \ INIT <sid> .ORA' from spfile;
  3. Copy alert.log. He will need in the future to find “sequence #”.
  4. Copy the directory with data files, including redo-logs. You can not copy a file / s temporary tablespace data. If space is insufficient, you can instead copy, move the directory inaccessible for the “Oracle Universal Installer” place (outside the ORACLE_HOME and ORACLE_BASE).
  5. Remove the installed software Oracle.
  6. Install the new version without creating a database.
  7. Create a database manually:
    • The ‘c: \ control.bkp’ find all the mentioned directories and, if necessary, create them.
    • The ‘c: \ INIT <sid> .ORA’ find all the mentioned directories and, if necessary, create them.
    • Copy the init.ora obtained, for example, as follows:
      copy C: \ INIT <sid> .ORA% ORACLE_HOME% / database /
    • Copy the contents of the directory with data files (except the file / s temporary tablespace data) in% ORACLE_BASE% / <sid>.
    • Next, at the command prompt:
      • Expose the environment variable:
        set oracle_sid = <sid>
      • Create an instance:
        oradim -new -sid% ORACLE_SID% -syspwd qwerty123 -startmode auto -srvcstart system

        Where:
        % ORACLE_SID% – variable created in the preceding paragraph;
        qwerty123 – password to access the database.

      • Connect to the newly created instance, for example, using sqlplus:
        sqlplus / as sysdba
    • in sqlplus:
      • If the instance is started, stop:
        shutdown immediate;
      • Raise the instance without mounting:
        startup nomount;
      • You will create a control-file from the c: \ control.bkp (performs part of the text, beginning with the “CREATE CONTROLFILE SET” and up to the first occurrence of “;” inclusive).
      • Perform instance recovery:
        RECOVER DATABASE USING BACKUP CONTROLFILE

        What we find most likely a similar message:

        ORA-00279: change 31413210566 generated at 07/15/2013 17:55:31 needed for
        thread 1
        ORA-00289: suggestion:
        D: \ ORACLE \ FAST_RECOVERY_AREA \ SID \ ARCHIVELOG \ 2013_07_15 \ O1_MF_1_69238_% U_.ARC
        ORA-00280: change 31413210566 for thread 1 is in sequence # 69238
        
        
        Specify log: {<RET> = suggested | filename | AUTO | CANCEL}

        The argument should be the full name (including the path) redo-file. For example, ‘D: \ oracle \ oradata \ sid \ redo01.log’ (redo-file can be a different number – sequence # and the file in which it is housed, can be found in the copied earlier alert.log, a simple enumeration names redo-log command again.). After that will appear:

        Log applied.
        Media recovery complete.
      • Open the database:
        ALTER DATABASE OPEN RESETLOGS UPGRADE;
      • Execute the command ” ALTER TABLESPACE TEMP ADD TEMPFILE…” (can be found in the ‘c: \ control.bkp’).
      • Perform update:
        @? / Rdbms / admin / catupgrd.sql
      • Re-connecting to the database and run it, because script from the previous paragraph and stopped the instance sqlplus closed the session.
      • We provide:
        @? / Rdbms / admin / utlu112s.sql
        @? / Rdbms / admin / utlrp.sql
      • Create spfile from the existing pfile:
        create spfile from pfile;
      • Restart instance, that he began to use the spfile:
        shutdown immediate;
        startup;
  8. We set up the listener and check the operation.
(Visited 29 times, 1 visits today)
adminOracleTips
Steps for Windows on the example of upgrading from 11.2.0.2.0 to 11.2.0.4.0. For other OS need to make amendments to the specific features, such as: names of environment variables, file paths, operating system commands, etc. Make a backup. Perform, for example, in sqlplus ( ' sqlplus / as sysdba') as follows: Optionally,...

Do you want to be notified about new DBA updates, releases, jobs and free tips? Join our email newsletter. It's fast and easy. You will be among the first to know about hot new DBA updates and stuff, it will help you enhance your DBA skills.
We take your privacy very seriously