RE: Testing backups ...
Posted in 2004
Topics: Backup & Restore, Platform-Specific Issues
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C47A25.A8744940
Content-Type: text/plain;
charset="ISO-8859-1"
Great idea,
At a minimum I would use archecker to validate the archive (and more often
than monthly), but if you have resources validating the entire process can
be a life(job) saver.
I do both where possible. Validating the UNIX level restore is much slower
and more painful, but still a good exercise.
I like to have a test system that is a true copy of production, and I
validate the restore process regularly (keeping the test system fairly in
sync with production).
I highly recommend automating it as much as possible.
Good luck.
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On
Behalf Of Dirk Moolman
Sent: Wednesday, August 04, 2004 4:09 AM
To: informix-list@iiug.org
Subject: Testing backups ...
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
_____
<< 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
<http://www.ellaforspam.com>
------_=_NextPart_001_01C47A25.A8744940
Content-Type: text/html;
charset="ISO-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 77.95pt 1.0in 77.95pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.MsoPlainText {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Courier New"
}
LI.MsoPlainText {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Courier New"
}
DIV.MsoPlainText {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Courier New"
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=122022013-04082004>Great
idea, </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=122022013-04082004>At a
minimum I would use archecker to validate the archive (and more often than
monthly), but if you have resources validating the entire process can be a
life(job) saver.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=122022013-04082004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=122022013-04082004>I do
both where possible. Validating the UNIX level restore is much slower and more
painful, but still a good exercise. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=122022013-04082004>I like
to have a test system that is a true copy of production, and I validate the
</SPAN></FONT><FONT face=Arial color=#0000ff size=2><SPAN
class=122022013-04082004>restore process regularly (keeping the test system
fairly in sync with production).</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=122022013-04082004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=122022013-04082004>I
highly recommend automating it as much as possible.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=122022013-04082004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=122022013-04082004>Good
luck.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=122022013-04082004></SPAN></FONT> </DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]<B>On Behalf Of </B>Dirk
Moolman<BR><B>Sent:</B> Wednesday, August 04, 2004 4:09 AM<BR><B>To:</B>
informix-list@iiug.org<BR><B>Subject:</B> Testing backups
...<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt"></SPAN></FONT> </P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt">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=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt"></SPAN></FONT> </P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt">How many of you currently do this
? Any good tips ?</SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt"></SPAN></FONT> </P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt"></SPAN></FONT> </P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt">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=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt"></SPAN></FONT> </P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt"></SPAN></FONT> </P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt">Dirk</SPAN></FONT></P></DIV><BR><!--Ella123-->
<HR>
<TABLE borderColor=#999999 cellSpacing=0 cellPadding=8 bgColor=#ffff99
border=1>
<TBODY>
<TR>
<TD align=middle><FONT face=Tahoma,Arial,San-Serif color=#999999
size=2><<</FONT><FONT face=Trebuchet,Arial,San-Serif color=#006600
size=2><B> ella for Spam Control </FONT></B><FONT
face=Tahoma,Arial,San-Serif color=#999999 size=2>>> </FONT><FONT
face=Trebuchet,Arial,San-Serif color=#333333 size=2>has removed
<B>816</B> Spam messages and set aside <B>156</B> Newsletters for
Related threads
- Conversion to differeent characters sets
- Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)
- Problem in changing locale via dbexport/dbimport
- Re: Matches not Work in 7.30
- DATABASE vs CONNECT TO: Invalid characters error?