Networker

[Networker] networker/oracle bug

2002-09-10 02:58:35
Subject: [Networker] networker/oracle bug
From: "Peter D. Gray" <pdg AT UOW.EDU DOT AU>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Tue, 10 Sep 2002 16:58:25 +1000
I have a problem and I am not sure if
it is networker or oracle or both.

I am using snapshots to back up oracle databases
on a procom filer.

The problem is that the actual database files are not being
picked up in incremental backups. The problem appears to
be that oracle updates the atime and mtime timestamps
when it writes to the database, but does not update the
ctime.

According to the man pages, both the ctime and mtime are
updated when a write occurs to a file, so it is likely
that oracle is playing dirty pool by not updating the
ctime.

However, it seems to me that networker is also
playing dirty by not taking account of the mtime
timestamp when determining if it needs to back
up a file.

My networker version is 6.1.2 (rebadged as solstice backup via
SUN).

Not that this is based on my research so far, I still need to
do more testing but I hope someone can at least enlighten
me as to the algorithm networker uses to determine when to
backup a file when doing incremental backups.

Regards,
pdg

--

See mail headers for contact information.

--
Note: To sign off this list, send a "signoff" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>