11 Replies Latest reply: Jun 11, 2014 5:13 AM by tvCa-Oracle RSS

    Dataguard Switch-over

      Hi all,

       

      11.2.0.3

      aix 6

       

      We have configured DG physical standby. We want to switch to it to be able to test disaster scenarios.

      Our dbname at primary is PROD, and for our standby is it PRODDR

      The application is connecting via listener > IP:DBNAME:PORT.

      The IP and PORT can be the same at switchover, but how do I set static the DBNAME?

       

      How do I make at alias at listener level so that the connection parameters with not be changed?

      For example if the app is using the parameter dbname= PROD, then it will be redirected to PRODDR?

       

      Thanks,

      pK