4 Replies Latest reply: Sep 13, 2013 3:10 AM by taohiko RSS

    How to activate Data Guard after test on standby database

    taohiko

      Hi All

       

           I have a plan for testing standby database and below is my plan

      1. Check archive log gap and transfer archive logs if necessary

      2. Stop Data Guard replication

      3. Shutdown Standby Database

      4. Backup Standby Database before testing

      5. Startup Standby Database to test (and Primay Database still using by user and has transactions during testing)

       

           After testing and will activate Data Guard

      1. Restore standby database from before backup set

      2. Startup Standby Database to Standby mode

      3. Activate Data Guard

       

           I have a question. Can I use archive log from Primary to apply on Standby before activate Data Guard? or Must re-configure Data Guard to activate Data Guard after testing ?

       

      Thank you

      Hiko