RE: DataGuard Question(s)
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_at_gmail.com]
Sent: Thursday, May 31, 2012 3:21 PM
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 220.127.116.11 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.
(stop applying logs)
Convert the physical standby to a logical standby. (resume applying logs)
(stop applying logs)
Upgrade the physical standby to release 18.104.22.168. (resume applying logs)
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 22.214.171.124.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,
-- 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