Setting up Data Guard
JimboMar 12 2013 — edited Mar 13 2013Hi,
I am a newbie to data guard and was wondering what do I need to do to deploy it. So far I have an 11gR2 database up and running.
Q1. How do I create a standby database ( I have decided on a physical standby ) ?
Q2. Do I have to deploy anything other than 11gR2 Oracle Home on my primary and standby servers ?
Q3. I see from some documentation that primary / standby databases can be managed using either sqlplus or dgmgrl - which would be the norm ?
Q4. Presently I only have my primary and proposed standby server - I have also read that it is better to deploy Data Guard Broker on a separate server from these 2. If I only have 2 servers, is it therefore better just to manage Data Guard using sqlplus on each server ?
Q5. What's the most appropriate document to follow when I am trying to deploy Data Guard for the first time
any advice greatly appreciated,
Jim