Re: DataGuard Question(s)
Date: Thu, 31 May 2012 13:58:23 -0500
Message-ID: <CAH4ZrrvY_=Jvauenh=_QTedwZoNqxmEs4OZ7Z+9a=0650_mYbg_at_mail.gmail.com>
While Richard is right that you can't create a physical standby database running 11.2.0.3 off of a primary running 10.2.0.5, you can use it building a physical standby as part of an upgrade strategy.
Create a physical standby running 10.2.0.5.
(apply logs)
(stop applying logs)
Convert the physical standby to a logical standby.
(resume applying logs)
(stop applying logs)
Upgrade the physical standby to release 11.2.0.3.
(resume applying logs)
Switchover.
This is our current plan for upgrading a 10+ TB mission critical system, and we've successfully tested it in small scale. There's a white paper out there from Dell about how they did a RAC upgrade that using that strategy.
> We are migrating from one data center to another, all new equipment and the latest Oracle 11gR2 database. To minimize the migration window, I was thinking about using data guard to replicate the production database to the new data center prior to migration weekend.
>
> 1. Has anyone used data guard to create their new production database?
> Yes, works very nicely for moving things form one location to another provided the prerequisites are there.
>
> 2. Can data guard be used to create a standby database on a newer version of Oracle (source Oracle 10.2.0.5.0 - target Oracle 11.2.0.3.0)?
> No, one of the prereq's the operating system and database version MUST be the same.
>
> 3. Is anyone aware of the ports used by data guard so I can make sure the firewall is open between data centers?
> Up to you as it's all just SQL*Net
> Thanks in advance,
> Bill
-- Adam Musch ahmusch_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 31 2012 - 13:58:23 CDT