4 Replies Latest reply: Jan 23, 2013 7:32 AM by Sebastian Solbach -Dba Community-Oracle RSS

    regarding rac data guard testing

    user11221081
      Hello Gurus

      i have created a data guard in rac environment rac 2 node.Its successfully configured.Now i want to show a drill activity to customer.
      But as its a production database i am avoiding the risk of showing switchover switchback.

      Also the customer does not want to shutdown the database.So i want to know can i activate the standby database for testing.I know if i open it once it the standby database would be corrupted but it will be alright for me i would create it again.Also i dont want the transactions for which we test on standby to be there on primary.

      I mean we just want to test the standby.
      So if i defer the log_archive_dest2 parameter and open the standby and do some transactions on it.Would it be fine OR it would impact my primary database also and there may be some conflict.

      Please clear what are the best ways for testing.
        • 1. Re: regarding rac data guard testing
          Sunny kichloo
          Based on your requirement i think you have to test a failover in Oracle Dataguard

          http://jarneil.wordpress.com/2008/08/05/testing-failover-with-maximum-performance-dataguard/

          http://www.databasejournal.com/features/oracle/article.php/3840571/Performing-Database-Failover-with-Oracle-11g-Data-Guard.htm
          • 2. Re: regarding rac data guard testing
            user11221081
            Thanks sunny for your reply

            But i do not have a requirement to test on production.we just want to show the customer the standby database.

            Like i want to show that suppose at a point my data is upto level A ON MY PRIMARY now i open my standby database and do some transactions now my standby is corrupted fine but i want my primary database to be as it was on same point with level A data
            • 3. Re: regarding rac data guard testing
              Sunny kichloo
              The moment you activate the standby database there DR relation will be over.

              Once you test your standby database in read-write mode you can again convert it back in to standby database with the hep of Primary database backup.

              Also there will be no effect on data of Primary during this Operations.
              • 4. Re: regarding rac data guard testing
                Sebastian Solbach -Dba Community-Oracle
                Hi Sunny,

                you can convert a read/write opened standby datase back to a standby database, if you have opened it as a Snapshot Standby. This reduces the need to have a full primary db backup at hand (and the long time needed to recreate the standby):

                http://docs.oracle.com/cd/E11882_01/server.112/e25608/manage_ps.htm#SBYDB4802

                Regards
                Sebastian