3 Replies Latest reply: May 5, 2013 11:19 PM by Mahir M. Quluzade RSS

    Display Data Guard Configuration

    1002191
      Hi All,

      We have two Windows 2008 VMs with Oracle 11G configured as primary and standby.
      This configuration has been defined by a partner who is no longer working for us.

      We have broken the correct application of the redo log on the standby when we have not correctly restored some snapshots on those two VMs.

      I would like to create a new Oracle server that will become the new standby. For that, I need too :
      - Display the full dataguard configuration to reproduce it on the new server
      - Stop (delete ?) the configuration on the primary server.

      We also have the current problem that RMAN refuses to delete old archivelog since they have not been applied to the standby.

      Thanks for any help about those subjets,
      Eric FRIGOT
        • 1. Re: Display Data Guard Configuration
          Mahir M. Quluzade
          999188 wrote:
          Hi All,

          We have two Windows 2008 VMs with Oracle 11G configured as primary and standby.
          This configuration has been defined by a partner who is no longer working for us.

          We have broken the correct application of the redo log on the standby when we have not correctly restored some snapshots on those two VMs.

          I would like to create a new Oracle server that will become the new standby. For that, I need too :
          - Display the full dataguard configuration to reproduce it on the new server
          - Stop (delete ?) the configuration on the primary server.

          We also have the current problem that RMAN refuses to delete old archivelog since they have not been applied to the standby.

          Thanks for any help about those subjets,
          Eric FRIGOT
          Hi,

          Welcome to OTN Forums!

          Then, you must restore same time snapshots both machines.
          If not same time snapshots, then

          1. Restore primary server snapshot.
          2. Create a VM for standby again.
          3. Safety remove DG configuration from Primary server.
          4. Create new standby and DG configuration again.

          P.S Check this video : http://www.mahir-quluzade.com/2012/01/overview-data-guard-configuration.html

          Regards
          Mahir M. Quluzade
          • 2. Re: Display Data Guard Configuration
            1002191
            Hello Mahir,

            Thanks for your reccomandations and the linked video.
            I have succesfully restore the dataguard configuration on my two servers.

            Regards,
            Eric
            • 3. Re: Display Data Guard Configuration
              Mahir M. Quluzade
              You are welcome!