RE: Testing backups ...
So far this sounds like the best idea. To do a restore, I need the same
version for backup & restore. Has anyone tried restoring to the same
version, but different platforms ?
If I can do this, I can get a cheap linux box, with enough disk space,
and this could be my little test server ...
...... oh sh1t, just remembered, the tape library won't work on the
linux box .... :-(
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Brice Avila
Sent: Wednesday, August 04, 2004 7:31 PM
To: informix-list@iiug.org
Subject: Re: Testing backups ... (spare server)
I think it's a great idea. Too many find that their backups are bad
when they need it most. It's also helpful just to keep your
backup/restore skills fresh.
The best way to verify your backups is to perform a restore. Find a
spare server and practice restoring to it. Then run onchecks on it
(i.e. "oncheck -cc", "oncheck -cr", "oncheck -ce", "oncheck -cD" and
"oncheck -cI") to check the consistancy, and then have your DBA and/or
developer check to see if all the data is there.
Another option is to run archecker on the ontape backup. Archecker is
not discussed in the Backup and Restore Guide because it is not
supported, but there are some documents floating on the web on how to
use archecker. While this produces a report on the consistency of the
backup, it is not as good as an actual restore.
Hope this information helps.
Brice Avila
Minneapolis, Minnesota
"Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message
news:<ceq7b2$6dh$1@news.xmission.com>...
> This is a multi-part message in MIME format.
>
> ------_=_NextPart_001_01C479FA.5B19E47F
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> =20
>
> My company wants me to test my backups once a month, to verify that
they =
> still work and can be restored.
>
> =20
>
> How many of you currently do this ? Any good tips ?
>
> =20
>
> =20
>
> We use IDS7.31FD3, on Solaris 9, and the backups are done using ontape
=
> (for Informix), and ufsdumps for Unix (filesystems)
>
> =20
>
> =20
>
> Dirk
>
>
> ________________________________
>
> << ella for Spam Control >> has removed 816 Spam messages and set
aside =
> 156 Newsletters for me
> You can use it too - and it's FREE! www.ellaforspam.com=09
>
> ------_=_NextPart_001_01C479FA.5B19E47F
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <html>
>
> <head>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Dus-ascii">
>
>
> <meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
>
> <style>
> <!--
> /* Style Definitions */
> p.MsoNormal, li.MsoNormal, div.MsoNormal
> {margin:0in;
> margin-bottom:.0001pt;
> font-size:12.0pt;
> font-family:"Times New Roman";}
> a:link, span.MsoHyperlink
> {color:blue;
> text-decoration:underline;}
> a:visited, span.MsoHyperlinkFollowed
> {color:purple;
> text-decoration:underline;}
> p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
> {margin:0in;
> margin-bottom:.0001pt;
> font-size:10.0pt;
> font-family:"Courier New";}
> @page Section1
> {size:8.5in 11.0in;
> margin:1.0in 77.95pt 1.0in 77.95pt;}
> div.Section1
> {page:Section1;}
> -->
> </style>
>
> </head>
>
> <body lang=3DEN-US link=3Dblue vlink=3Dpurple>
>
> <div class=3DSection1>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'> </span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'>My company wants me to test my backups once a month, to verify
=
> that
> they still work and can be restored.</span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'> </span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'>How many of you currently do this ?
Any =
> good tips ?</span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'> </span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'> </span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'>We use IDS7.31FD3, on Solaris 9, and the backups are done
using =
> ontape
> (for Informix), and ufsdumps for Unix (filesystems)</span></font></p>>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'> </span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'> </span></font></p>
>
> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
> style=3D'font-size:
> 10.0pt'>Dirk</span></font></p>
>
> </div>
>
> </body>
>
> </html>
> <br><!--Ella123--><hr><table border=3D"1" cellpadding=3D"8" =
> cellspacing=3D"0" bgcolor=3D"#FFFF99" bordercolor=3D"#999999"><tr><td
=
> align=3D"center"><font face=3D"Tahoma,Arial,San-Serif" size=3D"2" =
> color=3D"#999999"><<</font><font
face=3D"Trebuchet,Arial,San-Serif" =
> size=3D"2" color=3D"#006600"><b> ella for Spam Control
</font></b><font =
> face=3D"Tahoma,Arial,San-Serif" size=3D"2" color=3D"#999999">>> =
> </font><font face=3D"Trebuchet,Arial,San-Serif" size=3D"2" =
> color=3D"#333333">has removed <b>816</b> Spam messages and set aside =
> <b>156</b> Newsletters for me<br> You can use it too - and it's =
> FREE!</font>  <font size=3D"2" face=3D"Tahoma,Arial,San-Serif"
=
> color=3D"#333333"><a =
>
href=3D"http://www.ellaforspam.com">www.ellaforspam.com</a></font></td><;
/=
> tr></table>=00
> ------_=_NextPart_001_01C479FA.5B19E47F--
> sending to informix-list
sending to informix-list