RE: DataGuard Question(s)
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: Ram Raman <veeeraman@xxxxxxxxx>, "ahmusch@xxxxxxxxx" <ahmusch@xxxxxxxxx>
- Date: Thu, 31 May 2012 19:45:30 +0000
You bet, consult the Data Guard reference manual. There is a query to tell you
what will not be supported.
Richard Goulet
Senior Oracle DBA/NA TEAM Lead
From: Ram Raman [mailto:veeeraman@xxxxxxxxx]
Sent: Thursday, May 31, 2012 3:21 PM
To: ahmusch@xxxxxxxxx
Cc: Goulet, Richard; bill@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx L
Subject: Re: DataGuard Question(s)
Can there be any data type that is not compatible with the logical standby.
On Thu, May 31, 2012 at 1:58 PM, Adam Musch
<ahmusch@xxxxxxxxx<mailto:ahmusch@xxxxxxxxx>> wrote:
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.
http://www.slideshare.net/dellenterprise/upgrade-and-migrate-on-multi-terabyte-mission-critical-rac-with-near-zero-downtime-5225479
> 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@xxxxxxxxx<mailto:ahmusch@xxxxxxxxx>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
