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

Thread: Upgrade standby database

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Upgrade standby database

    Hi,

    In 10g, while upgrading a database which has one physical standby Oracle recommends the below process(high level steps)

    First in standby:

    1. stop all services & shut down all db instances running from the home
    2. upgrade binaries
    3. mount standby database

    In Primary:

    Repeat 1 & 2 steps then

    3. execute rdbms upgrade scripts
    4. enable log shipping
    5. start managed recovery in standby

    In this case I have to take the complete outage for application which is not possible for one of my applications. I am planning to follow the below steps to minimize application outage.

    1. cancel managed recovery and open standby in read-only
    2. route application traffic to standby db (application will have limited functionality which is okay)
    3. stop services, shutdown db and upgrade primary database binaries and run rdbms scripts
    4. start primary database and services
    5. route application traffic back to primary database
    6. upgrade standby database binaries
    7. mount and start managed recovery in standby database

    I would like to see some suggestions about the above approach. Appreciate your time.

    Regards,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Seems it might work!
    I was thinking about doing the same thing.
    Keep us posted.
    Good luck!
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Thanks LKB. Sure, I will update.

    Regards,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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