Re: Triple Mirroring vs. Hot backups + Double mirroring
Date: 1995/12/12
Message-ID: <4ak5ji$gra_at_inet-nntp-gw-1.us.oracle.com>#1/1
badri_at_cc.gatech.edu (badri) writes:
>Hi:
>
> We have a Sequent SE70 with ORACLE 7.2.2.3. We also have
>an 8mm 6-tape stacker. Our database is 16Gb and we are currently
>triple mirroring it. We currently detach a mirror after shutting
>the instance down and back it up, followed by resynch of that
>mirror.
>
>I would like to invite comments/suggestions on the following:
>
> Instead of using up 16Gb per mirror and triple mirroring,
>why not double mirror and use hot backups? What are the trade-offs?
>On one side, it saves us 16Gb of disk space. I understand that
>recovery is more tedious with hot backups. Any other problems?
>
>Any and all help would be greatly appreciated,
>
>thanks a lot,
>
>-Badri
Triple mirroring is actually an overkill. Hot backups are not tedious. The
database needs to be running in archivelog mode. Since you have the luxury
of shutting down the instance ( not a 7*24 shop ), you can explore other
options like copying the database files onto a disk array and then backing
up the array.
You can automate the hot backups using UNIX scripts. Look at the book "Oracle backup and Recovery handbook" by Rama Velpuri. This is definitely a good starting point for exploring options.
Thanks
Mahesh Vallampati
DBA consultant from Oracle Corp.
713-750-5002
Oracle Houston
Received on Tue Dec 12 1995 - 00:00:00 CET