3 Replies Latest reply: Mar 16, 2013 9:21 AM by mseberg RSS

    How to Syncronize data from new primary to old primary?

    879152
      Hi,

      I have installed oracle 11g r2 rac with asm in two nodes. OS is hp-Unix.

      I have installed oracle11g Active Data Guard using Single alone Database.

      Both RAc and Active Data Guard works fine.

      I have not configure Data Guard Broker.

      Suddendly RAC is down both node and not possible to Up, So to continue Client Transaction
      I have made Active Dataguard to Primary by using following Commend:

      SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

      Database altered.

      SQL> alter database recover managed standby database finish;

      Database altered.

      SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

      Database altered.

      SQL>

      SQL> shutdown immediate
      ORA-01109: database not open


      Database dismounted.
      ORACLE instance shut down.
      SQL> startup
      ORACLE instance started.

      Total System Global Area 1.5400E+10 bytes
      Fixed Size 2184872 bytes
      Variable Size 7717521752 bytes
      Database Buffers 7650410496 bytes
      Redo Buffers 29409280 bytes
      Database mounted.
      Database opened.
      SQL> select open_mode from v$database;

      OPEN_MODE
      --------------------
      READ WRITE

      SQL>

      SQL> select status from v$instance;

      STATUS
      ------------
      OPEN

      SQL>

      After that Client transanction occures 1 day in new primary DB. and by this time My previous RAc is UP.

      Now my question is :
      1. How I can Syncronize data from new primary to old primary?
      2. How to perform RAC and DataGuard configuration as before RAC was corrupted?




      please help.

      Thanks
      Solaiman
        • 1. Re: How to Syncronize data from new primary to old primary?
          Hungry DBA
          Hi,

          Here you have performed Failover and not Switchover hence your standby database is now activated and acting as indiviual (cannot be sync with old Primary)

          Answers to your questions,

          1. How I can Syncronize data from new primary to old primary? *(Not Possible as now SCN is different for both databases and cannot be sync. this you could have avoided if you would have taken snapshot for standby)*
          2. How to perform RAC and DataGuard configuration as before RAC was corrupted? *(here you have to again configure your standby)*

          what doest it means by RAC was corrupted. ??
          - as both Grid Infrastructue and Cluster database are separate entities. Here GI is intact, only thing you need to do is configuring standby once again and perform switchover/switchback instead failover.

          I hope this helps you :)

          Thanks,
          Manish Nashikkar
          • 2. Re: How to Syncronize data from new primary to old primary?
            879152
            Hi,
            Thanks for your comment.

            Then again:

            I have installed oracle 11g r2 rac with asm in two nodes. OS is hp-Unix.

            I have installed oracle11g Active Data Guard using Single alone Database.

            Both RAc and Active Data Guard works fine.

            I have not configure Data Guard Broker.

            If again RAC is down both node and not possible to Up, So to continue Client Transaction
            How I can perform switchover/switchback to convert Data Guard as Primary(new).

            So that when previous RAC is Up , I can sync previous primary and new primary(new)
            also can make new primary(new) as Data Guard?

            Thanks
            Solaiman
            • 3. Re: How to Syncronize data from new primary to old primary?
              mseberg
              Hello;

              Your question depends upon how the Primary site went down. If you need a planned outage you can do a switchover to the Standby and then keep Log_archive_dest_state_n set to defer.

              Log_archive_dest_state_n=defer;

              Once the outage is complete you can enable. In most cases Data Guard will SYNC and then you can switchover again to switch back.

              If the outage is unplanned you have to recover the old primary site ( flashback, RMAN) to the last SCN where the two databases where sync. Then in a Standby role bring the old primary back in sync.

              Here's a couple of short notes which may help :

              http://www.visi.com/~mseberg/data_guard/Data_Guard_switchover.html

              http://www.visi.com/~mseberg/data_guard/Data_Guard_Failover_Test_using_SQL.pdf



              Best Regards

              mseberg