Testing backups ...

Posted in 2004

Topics: Backup & Restore, Platform-Specific Issues

Dirk Moolman — Wed, 4 Aug 2004 10:09:25 +0200 — source: Usenet: comp.databases.informix

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> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1>   My company wants me to test my backups once a month, to verify = that they still work and can be restored.   How many of you currently do this ?     Any = good tips ?     We use IDS7.31FD3, on Solaris 9, and the backups are done using = ontape (for Informix), and ufsdumps for Unix (filesystems)     Dirk </div> </body> </html> <hr><table border=3D"1" cellpadding=3D"8" = cellspacing=3D"0" bgcolor=3D"#FFFF99" bordercolor=3D"#999999"><tr><td = align=3D"center">&lt&lt ella for Spam Control &gt&gt = has removed 816 Spam messages and set aside = 156 Newsletters for me You can use it too - and it's = FREE!&nbsp&nbsp<a = href=3D"http://www.ellaforspam.com">www.ellaforspam.com</a></td></= tr></table>=00 ------_=_NextPart_001_01C479FA.5B19E47F-- sending to informix-list

↪ replying to Dirk Moolman

Brice Avila — 4 Aug 2004 10:30:51 -0700 — source: Usenet: comp.databases.informix

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> > > </head> > > <body lang=3DEN-US link=3Dblue vlink=3Dpurple> > > <div class=3DSection1> > > style=3D'font-size: > 10.0pt'>  > > 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. > > style=3D'font-size: > 10.0pt'>  > > style=3D'font-size: > 10.0pt'>How many of you currently do this ?     Any = > good tips ? > > style=3D'font-size: > 10.0pt'>  > > style=3D'font-size: > 10.0pt'>  > > 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)> > style=3D'font-size: > 10.0pt'>  > > style=3D'font-size: > 10.0pt'>  > > style=3D'font-size: > 10.0pt'>Dirk > > </div> > > </body> > > </html> > <hr><table border=3D"1" cellpadding=3D"8" = > cellspacing=3D"0" bgcolor=3D"#FFFF99" bordercolor=3D"#999999"><tr><td = > align=3D"center"> color=3D"#999999">&lt&lt size=3D"2" color=3D"#006600"> ella for Spam Control face=3D"Tahoma,Arial,San-Serif" size=3D"2" color=3D"#999999">&gt&gt = > color=3D"#333333">has removed 816 Spam messages and set aside = > 156 Newsletters for me You can use it too - and it's = > FREE!&nbsp&nbsp color=3D"#333333"><a = > href=3D"http://www.ellaforspam.com">www.ellaforspam.com</a></td></= > tr></table>=00 > ------_=_NextPart_001_01C479FA.5B19E47F-- > sending to informix-list

Related threads

Glossary

ontape