This discussion is archived
4 Replies Latest reply: Jan 23, 2013 5:32 AM by Sebastian Solbach (DBA Community) RSS

regarding rac data guard testing

user11221081 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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) Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points