This discussion is archived
3 Replies Latest reply: Feb 6, 2013 8:54 AM by CKPT RSS

Upgrade StandBy to Primary Version.

Athurumithuru Newbie
Currently Being Moderated
Hi All,

Mistakenly I have configure dataguard on different versions. Primary is 11.2.0.3.0 and StandBy is 11.2.0.1.0.
Log shipping is perfectly working, but cannot put StandBy in read only mode.

Pls help me to upgrade StandBy to 11.2.0.3.0.

Rgds,
Athurumithuru.
  • 1. Re: Upgrade StandBy to Primary Version.
    CKPT Guru
    Currently Being Moderated
    Athurumithuru wrote:
    Hi All,

    Mistakenly I have configure dataguard on different versions. Primary is 11.2.0.3.0 and StandBy is 11.2.0.1.0.
    Log shipping is perfectly working, but cannot put StandBy in read only mode.

    Pls help me to upgrade StandBy to 11.2.0.3.0.

    Rgds,
    Athurumithuru.
    is it physical standby or logical standby database?
    Log ship will occur, can you confirm whether archives are applying ? i dont think so.

    Moreover you cannot upgrade standby system from 11.2.0.1 to 11.2.0.3 Whenever you perform ugprade the data dictionary will be modified and DML's are not allowed on standby either.

    If you have upgraded primary database, Start standby in mount status after installing 11.2.0.3 then start recovery. Whenever archives are applied the data dictionarly will be updated internally. You no need to perform any changes.
    So once standby is completely synchronized then you can open read only purpose.
  • 2. Re: Upgrade StandBy to Primary Version.
    Athurumithuru Newbie
    Currently Being Moderated
    Dear CKPT,

    Its physical StandBy. Pls inspect the verification script output of PrimaryDB and StandBY.


    SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 6 09:00:01 2013

    Copyright (c) 1982, 2011, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

    ==============
    At Production
    ==============

    Archive Log List - Production(Before Switch Logfile)
    ----------------------------------------------------
    Database log mode     Archive Mode
    Automatic archival     Enabled
    Archive destination     USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 712
    Next log sequence to archive 718
    Current log sequence     718

    Alter System Switch Logfile
    ---------------------------

    System altered.


    System altered.


    System altered.


    Archive Log List - Production(After Switch Logfile)
    ---------------------------------------------------
    Database log mode     Archive Mode
    Automatic archival     Enabled
    Archive destination     USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 715
    Next log sequence to archive 718
    Current log sequence     721

    View Archive Destinations - Production
    -------------------------

    ERROR                                        STATUS
    ----------------------------------------------------------------- ---------
                                            VALID
                                            VALID


    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 6 09:01:01 2013

    Copyright (c) 1982, 2011, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options


    ===========
    At Standby
    ===========

    Archive Log List - Standby
    --------------------------
    Database log mode     Archive Mode
    Automatic archival     Enabled
    Archive destination     USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 712
    Next log sequence to archive 0
    Current log sequence     721

    Select Archive Gap
    ------------------

    no rows selected


    View Archive Destinations - Standby
    -----------------------------------

    ERROR                                        STATUS
    ----------------------------------------------------------------- ---------
                                            VALID
                                            VALID



    SEQUENCE# APPLIED ARC
    ---------- --------- ---
    718 YES     YES
    717 YES     YES
    716 YES     YES
    715 YES     YES
    714 YES     YES
    713 YES     YES
    712 YES     YES
    711 YES     YES
    710 YES     YES
    709 YES     YES

    10 rows selected.


    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
  • 3. Re: Upgrade StandBy to Primary Version.
    CKPT Guru
    Currently Being Moderated
    >
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
    >

    Why you again connecting to 11.2.0.1 home? Once you installed and upgraded primary database, The next step is on standby is to start database in mount status of 11.2.0.3.0 home.
    Once you start MRP, Archives should apply without any issues.

    If once it is synchronized then you can open database for read-only.
    Hopt this clears

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points