Very Computer

We have two Sun Fire 280R and one Sun v890. We've installed Oracle
Financials + Oracle Database at v890 and we hava a "hot" backup onto one of
the Fire 280R. We do the "hot" backup with a snap shot and doing rsync
later. We must change this because "it's not all secure that we wants"

My question is:

1.- Can we do than the two 280R act as a single computer (Cluster)
2.- Can we do Hot backup with Oracle implementing Clustered or with
replication, load balancing, ...

What are your recomendations?

Thank,
Urko

--
??????????????????????????????????????????????????
Urko Benito Mateo
Master-D
Tecnologas de la Informacin
Ctra. de Madrid, N-IIa, Km. 314,8
Tlf: (+34) 976-76.41.00  Ext: 4328
Fax: (+34) 976-76.41.10

www.opositor.com <http://www.opositor.com/>
www.masterd.es <http://www.masterd.es/>
??????????????????????????????????????????????????

El presente correo electrnico puede contener informacin privilegiada o
confidencial. Si usted no es el destinatario del mismo o ha recibido el
mensaje por error, por favor informe al emisor a la mayor brevedad posible y
elimine el mensaje. Queda estrictamente prohibida la copia no autorizada,
as como la distribucin del material contenido en el presente correo.
Las opiniones expresadas en el presente correo son del autor y Master
Distancia no se responsabiliza de las mismas.

I've modificated, now it have only four lines, its ok?

Thanks, but i want some reply for my question
Urko

... here some scripts command ....

/usr/sbin/fssnap -F ufs -o
maxsize=1000m,bs=/opt/scrach1.bck,unlink  /oracle/prod/proddata

.... some scripts commands ...

/usr/local/bin/rsync -arpog /mnt/backup_prod/. /mnt/v280_proddata/.

But we have "some errors" when the backup script end, like Oracle file
inconsistences, so, thats is "unsecure".

We are planing to mount "parallel oracle" or "replicate" onto v280R, but we
are "a bit loss"

Thanks,
Urko

Dragan

--
Dragan Cvetkovic,

To be or not to be is true. G. Boole      No it isn't.  L. E. J. Brouwer

!!! Sender/From address is bogus. Use reply-to one !!!

Regards,

        Frank

Urko Benito top-posts : <

Quote:> Well, we have been doing
> ... here some scripts command ....
> /usr/sbin/fssnap -F ufs -o
> maxsize=1000m,bs=/opt/scrach1.bck,unlink  /oracle/prod/proddata
> .... some scripts commands ...
> /usr/local/bin/rsync -arpog /mnt/backup_prod/. /mnt/v280_proddata/.
> But we have "some errors" when the backup script end, like Oracle file
> inconsistences, so, thats is "unsecure".

Quote:> We are planing to mount "parallel oracle" or "replicate" onto v280R, but we
> are "a bit loss"

Quote:> > What's insecure about using rsync exactly ??

przemol

What i'm asking is:

If i put the two solaris 280R onto a cluster can i obtain a "redundant"
enviroment or not.

And, how can i put the two 280 into a cluster? I've a Sun Storage A1000
connected to one 280, can i connect two 280 to the A1000 and then mount a
cluster to install oracle as a secondary server?

I have the main server onta Sun 890 and we need to we up 24x7 and when we
put into "backup mode" it take a lot o time to backup, so if we put the
oracle into a cluster (made with solaris cluster) or made Oracle in
parallel mode without solaris cluster, this is my questions

What is the better solution?
Solaris Cluster or Oracle Parallel?

Thanks everybody,
Urko

According to Sun's documentation, you need at least 2 A1000's to do
what you're asking, but yes, you can use two 280R's
and use them as a basis for a cluster.

http://docs.sun.com/app/docs/doc/817-0171/6mg06p96s?a=view

I'm hearing you say two different things.

1) It takes a long time to backup.
2) I want redundancy.

Which leads me to the conclusion that you're *really* asking:

3) If I use OPS/RAC or Solaris clustering, can I make my backups go faster?

You're not going to like this answer:

probably not.

The OPS/RAC solution ends up with the bottleneck at the disks. This is
because both nodes share the same disk subsystem that is where your
database datafiles live. I'm not enough of an Oracle guy to tell you how
well a node serving queries and a node doing backups is going to work.

The Solaris Cluster ends up with the bottleneck at the server, because you
only run the DB on one cluster node.

You may be better off in doing something along the lines of using Veritas'
FlashSnap or mirroring + short hot backup to ensure consistency to backup
the database essentially offline from your main IO activity (which is what
will be slowing down your current backup).

Chris

--

Unix/CCNA/CCDA Guy           Powered by Linux and the Orb.