RE: DataGuard Question(s)

Richard Goulet
Senior Oracle DBA/NA TEAM Lead
PAREXEL International
T 978.495.4127  

This communication, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential material. Any review, retransmission, distribution or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  Thank you.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bill Zakrzewski Sent: Thursday, May 31, 2012 1:41 PM
To: oracle-l_at_freelists.org L
Subject: DataGuard Question(s)

Current Environment:
Oracle 10.2.0.5.0
RH 5

New Environment:
Oracle 11.2.0.3.0
RH 5

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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 31 2012 - 13:42:19 CDT