Backup strategy for RAC is not different from non-RAC, except archive log
backuping (if they are not on the cluster or shared FS, then
you must be sure to copy them all).
You need full backup + all archive logs to restore the database to the
current state. I am not sure if Oracle incremental backups makes sense -
technically they are not necessary at all (because of archive logs), but
they can speed up recovery (I never tried myself).
If daily backups cause too much slowness and take too much space, then
weekly full backups + storing all archive logs (and incremental backups, if
archive log recovery takes too long - iit depends of your database) can be a
good strategy. I better be sure, that I have a 2 copies of archive logs, or
run daily backups (as we do now) and test recovery time to time on a third
server.
Main difference of RAC vs non RAC is that RAC will have less number of short
downtimes (up to zero), but have a higher probability of destructive failure
(when you will need to restore everything from the scratch) and require
better DBA and sysadmin skills to troubleshout.
If I need HA system, I would prefer to run DataGuard in parallel to the RAC
to ensure 0 downtime.
----- Original Message -----
From: "Bart Goossens" <bartg4@(protected)>
To: <suse-oracle@(protected)>
Sent: Sunday, February 04, 2007 10:48 PM
Subject: [suse-oracle] RAC-questions
Thank you all for your answers!
Now here's another one : in a high availability environement (24/7 uptime),
what do you use as backup strategy?
I was thinking of during the night when there is less load on the RAC making
an incremental backup and once a week during the weekend an incremental
backup level 0?
Kind regards,
Bart
>----- Oorspronkelijk bericht -----
>Van: Jean-Hilaire Yapi [mailto:jhyapi@(protected)]
>Verzonden: zaterdag, februari 3, 2007 09:19 PM
>Aan: 'Bart Goossens', suse-oracle@(protected)
>Onderwerp: RE : [suse-oracle] RAC-questions
>
>Hi Bart,
>
>> Is it necessary that the hardware of all nodes is identical? No. You can
use different makes (Dell, HP, IBM, ...) in your RAC.
> You just need to have the same architecture (32 or 64 bits) and the same
OS.
> And the different compouters can have more or less CPUs and RAM.
> Don't forget that with RAC, you can decide to dedicate one of your nodes
to run heavy jobs and the remaining to serve your connected users. And
depending on the load you need to support on each computer, you can add more
or less CPUs and RAM.
>
>> Can I have several versions of Oracle on one RAC?
> NO. All the instances of the same RAC database must be of the same
version of Oracle.
>
> But, you can run different versions of Oracle RAC on one computer.
>
> Regards,
>
> Jean-Hilaire
>
>Bart Goossens <bartg4@(protected) :
> Hello,
>
>I have some RAC questions :
>
>Is it necessary that the hardware of all nodes is identical? For the OS it
is clear, but for the machines I'm not certain? Can I for example have two
nodes with each 2 cpu's and a third node with 4 cpu's?
>
>Can I have several versions of Oracle on one RAC?
>
>Regards,
>
>Bart
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
