1 Reply Latest reply on Jul 28, 2020 11:34 AM by dan.smith@informatica.com

    PWX Express CDC transition from primary database to datagaurd standby

    vijay00u1efn99eu61Z7mS1d8 Seasoned Veteran

      Hi,

       

      Our current architecture is

       

      1) Logger and listener are running on PowerCenter machine

      2) Oracle database is on Exadata machine with ASM and 2 member RAC cluster.

       

      DBAs are recommending us to have PWX read logs from Datagaurd standby database rather than primary. Pls answer below questions

       

      1) After we switch to datagaurd standby database, does PWX talk to primary at all for anything(metadata, etc)?

      2) Is there a defined procedure for this transition?

      4) What is the maintenance procedure for any future schema changes to the primary database after the transition?

       

      Thank you.