Alejandro Vargas' Blog

Great Stuff.

Just a suggestion

Go over a STEP by STEP applying a "patch or patch set" to a dataguard systems. look at metalink note : 187242. I think it is "lacking" information about systems using a DG broker..

anyway..great stuff

Nice!

Hi, thanks for sharing info on standby DGMGRL configuration, we are going to using FF feature of DG but have one security issue

to start observer we need to supply uid with sysdba and password in clear which is security concern.

any idea how can we supply encrypted password and start observer? something similar to rexp?

thanks
Manoj

Hi,

Nice way to give understanding about DataGuard Broker. I am not much aware about the broker. so can u pl. let me know that whaterver the parameter we are setting for primary and standby database and the requried file configuration is done by SQL prompt only or with in broker this is available?

- we can use broker just for easiest way to failover and switchover...

give me some ideas...
Regards,
Suchi

Thanks for a wonderful post.
I indeed used it to install my Oracle Dataguard on Solaris.

My next task is to test the switchover and failover scenarios without using the Broker. I mean just using sqlplus

Can you pls provide me with simple instructions to do these 4 scenarios
1) Switchover primary to standby and standby to primary

2) Once the scheduled maintenance on (originally) primary and now standby, Restore their original roles, i.e Make the status of the servers as it was before the switchover in step 1)

Failover scenarios
1) Failover Primary , check data appearing in Standby ( now promoted to primary)

2) Once the Dead Primary is restored, Restore their original roles, i.e Make the status of the servers as it was before the switchover in step 1)

Thanks in advance
Regards
Dharmesh

Hi Alejandro,

I am following all the steps on this document and I would like to comment on the GLOBAL_DBNAME=whiteowl_DGMGRL setting on the LISTENER.ORA file. I tried to follow that setting but I can't get it to work, instead I used whiteowl_DGB and blackowl_XPT for the GLOBAL_DBNAME on the LISTENER.ORA and everything is working fine. Any idea why?
Thanks in advance.

Regards,
Lloyd

make sure that you login as this
DGMGRL> connect sys/@whiteowl
GLOBAL_DBNAME=whiteowl_DGMGRL setting on the LISTENER.ORA file
SERVICE_NAME = whiteowl_DGMGRL) setting on the TNSNAMES.ORA file

ALTER SYSTEM SET LOCAL_LISTENER='LISTENER_VMRACTEST' SCOPE=BOTH;

when switchover or failover to complete oeration without errors