3 Replies Latest reply: Jun 11, 2014 11:41 AM by CKPT RSS

    Real Time Backup of Database

    jaimohan

      Hi

       

      Excuse,,if the question seems to be foolish. It is because I am quite new to Oracle and at present not aware of the full

      possibilities.

       

      We have Oracle 8.0 Database running on Windows 2003 Server. I know that this version is pretty old and need to be updated.

      Presently I've set up auto backup at specific intervals, but this also would be not enough in case of a sudden server crash.

      Hence, I would like to know whether it is possible to do real time backing up of the oracle database to another machine. The

      intention here is to create high availability. I read something about Data Guard but don't know whether it will meet my

      requirement.

       

      Kindly advise what are the alternatives?

       

      Regards

       

      jaimohan

        • 1. Re: Real Time Backup of Database
          mseberg

          Hello;

           

          The term Data Guard came along with Oracle version 9 ( completely obsolete too ). In Oracle 8 it was called "Standby database".

           

          You should upgrade to at least Oracle 11 and then consider using Data Guard. Trying to use Oracle 8 will give you nothing but headaches and you will have learn a ton of things which are no longer true.

           

          Best Regards

           

          mseberg

          • 2. Re: Real Time Backup of Database
            FreddieEssex

            Hi,

             

            Dataguard is typically used for DR and not HA.

             

            Oracle RAC is used for HA but was only introduced in 9i.

             

            For 8i Oracle Parallel Server was used but I'll be surprised if you can even get the software for that let alone any kind of support.

            • 3. Re: Real Time Backup of Database
              CKPT

              Hi,

               

              Yeah its too old era, There are changes from version to version and release to release..

              As said by mseberg Data Guard there is no concept in 8i where it is called simple standby database and you cannot avail high availability features with this version of course still you can manage standby with manual recovery. But lot of manual tasks has to be performed such as copying archive files, recovery stop and start so on.

              So very very limited in terms of high availability instead of that you can say alternate database which is available to you in case of primary is unavailable.