2 Replies Latest reply: Apr 26, 2013 1:12 AM by Aman.... RSS

    rman clone ? duplicate database ? data guard ? standby database?

    newbieDBA
      hey there !!
      What is the difference between Rman clone , duplicate database , data Guard , standby db?
      1 more thing , standby database and duplicate database are same??
        • 1. Re: rman clone ? duplicate database ? data guard ? standby database?
          Aman....
          newbieDBA wrote:
          hey there !!
          What is the difference between Rman clone , duplicate database , data Guard , standby db?
          1 more thing , standby database and duplicate database are same??
          All of these are very well documented in the documentation of your unmentioned db version. Search for them under http://tahiti.oracle.com .

          Aman....
          • 2. Re: rman clone ? duplicate database ? data guard ? standby database?
            swapnil kambli
            RMAN Clone : you take backup of a database on one server ,then take it to other server ,again use RMAN to restore the database,A lot manual intervention is needed in this method
            RMAN DUPLICATE: same as above just that manual intervention is less. With 11gR2 there active database duplication in which you can clone your test database directly from production database without taking and then transferring the backup to test server.

            Standby Database :they are of two types Physical and logical.The setup is done using RMAN with any of the above methods.Standby is the in-sync (can have some delay) version of primary database either block by block which is physical standby configuration or SQL statment wise which is logical standby.

            Data Guard:This is also a standby configuration.Here the failover and switchover are automated with the help of DGMGRL utility.In manual standby this same can be done via SQL*PLUS using sql commands