RE: DataGuard Question(s)
Date: Thu, 31 May 2012 19:45:30 +0000
Message-ID: <7642C3D639A75E4284658CAA38BF60A409D4DF52_at_US-BOS-VEX001.eu.pxl.int>
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_at_gmail.com]
Sent: Thursday, May 31, 2012 3:21 PM
To: ahmusch_at_gmail.com
Cc: Goulet, Richard; bill_at_intactus.com; oracle-l_at_freelists.org 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_at_gmail.com<mailto:ahmusch_at_gmail.com>> 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.
> 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<mailto:ahmusch_at_gmail.com> -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 31 2012 - 14:45:30 CDT