Computer problems,Computer help
*AX SOFT>>>Software

Anyone know what is fail over concept for a oracle server? what is resource group?


Anyone know what is fail over concept for a oracle server? what is resource group?

Hi -

For your first question: The concept of failover in Oracle is basically 2 things
1) A Real Application Cluster (RAC)
2) A Data Guard Configuration (DG)

RAC is the concept of having 2 or more Oracle instances accessing the same Oracle database and being able to work as one entity. If one of the nodes in the RAC fails, the remaining node(s) keep on working and users keep on working.
DG is the concept of having a "Standby" database, which is typically kept in "managed recovery mode" and just takes the online redo longs and/or archived logs from the Primary instance and applies them to the Standby Database. If the Primary database crashes or is lost, then the Standby database can be activated, rolled forward with any remaining logs available, and opened as a Primary database.

For additional inof, see here:

http://www.oracle.com/pls/db102/portal.p...

Resource Groups, one the other hand, really have nothing to do with failover. A Resource Group is an entity that you create (like a set of users in a particular department for example) and then you can define how much resources in the system that group can consume at any given point in time. For example, during the last 3-5 days of the month, you may assign the Payroll Resource Group a higher consumption rate on the system while reducing the Sales Resource Groups' consumption rate. Because at the end of the month, all the Sales info is in the database and the Payroll people need the computing power to spit out the pay checks.

Tags
  General - Computers & Internet   Software   Security   Programming & Design   Facebook
Related information
  • How wouldI reboot my computer?

    Reboot the computer, put in the cd and press any key when prompted. Then press enter at the blue screen, delete the partition that you want to install a new windows XP then press L to conform. ...

  • Text reading software?

    What you are talking about is OCR, or Optical Character Recognition, software. You can buy fully featured OCR software from many vendors. Or, if you want, try the freeware OCR software from ...

  • Kids' games CD's slowing down computer. Help?

    lol ... OK try to get a hard drive for your computer you will need a hard rive because those games are taking major space of your computer. if you cant afford one then delete some stuff on your co...

  • HAL! error for ubutu linux?

    first check forums for answers ...

  • Spell check Microsoft word 2007 not working?

    1. Verify settings in Word 2007: a. Open a document that has this problem, press Ctrl+A to select all of the text b. Click on Review tab | Proofing: Set Language | <choose your language> | ...

  • Is there a program like visual hub for windows, for burning multiple videos on one dvd?

    I would recommend you download ConvertXtoDVD. Ive been using it for a year now, on windows, never had a problem! It will convert your video files to the dvd format readable by all standard dvd p...

  • VirtualBox won't show my Service Pack 2 installation file...?

    If your 'host' can read all the files, try copying the contents of cd to the folder you use to share files with your "guest" os, the one one are trying to install sp2 on, and ru...

  • Picture help please on my computer?

    Eh sounds like a video card error,i get it sometimes if one of my computer games crashes. Update your video drivers.

    ...
  •  

    Categories--Copyright/IP Policy--Contact Webmaster