Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: FW: kinda OT: veritas netbackup
Holiday Greetings,
We use NetBackup Exec on a Novell network and the backup manual say's
that it can backup open files and not hamper the operation of the
system. Horse pucky.
When a file is open by Oracle the tape backup "backs up the file
without a lock" but if Oracle needs to use the file for read/write it
finds the file in use by another and places the file in an offline mode
and requires recovery to bring it back into the sanity mode.
According to oracle no backup program other than their own should be
used. There is no support guarantee from Oracle if the backup is taken
when the database is open. St. Bernard software disagrees but I still
only trust the Oracle solutions. Cold backups or hot backups or RMAN
backups only.
Ron
>>> BSpears_at_Limitedbrands.com 12/19/02 12:49PM >>>
Hi,
I am the other guy involved in this issue of Not backing up OPEN
files on
Unix with Netbackup.
We are keeping 2 days of logs on disk up to 60gig of logs.. The
tape
backup people are not happy about us
backing this up often to provide extra redundancy especially as we
implement this for every oracle system we
have.
Yes, we have considered running other backups but we really wanted to
see
if Veritas could close this logic hole
for us because we have a directive to keep our solution simple and
secure.
I know on windows its no problem and veritas squawks when the files
are in
use... Anyone know if the "only
BACKUP close files" feature exists in Unix.
Brian Spears
Sr. Oracle Database Administrator OCP
-----Original Message-----
Sent: Thursday, December 19, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L
Hello Joe
Just schedule another backup of the archive logs 1 hour (or 5 minutes)
after
the regular backup. NetBackup will take a second (complete) backup of
the
archive file and when you want to restore , restore the last copy of
the
files.
Yechiel Adar
Mehish
Sent: Thursday, December 19, 2002 5:50 PM
RESEND: never saw it get posted:
Can we force veritas netbackup (HPUX) to NOT backup open files?
Here is the problem: while arch process is writing out archive logs,
the
netbackup script that backs up the arch directory will write a
partially
written log to tape, we're trying to avoid that.
is our only alternative determine(out of data dictionary) how many log
groups we have and assuming 3, that if we take the max log seq# minus
the
numebr of groups we have, gives us the oldest log that we can be sure
is
complete?
ie: current log is 543, we have 3 log groups, 543-3 = 540, since
oracle
wouldnt start overwriting # 540 until it was successfully archived,
that we
can back up, up thru log seq# 540 and can be sure # 540 is complete?
thanks, joe
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Dec 19 2002 - 13:29:53 CST
![]() |
![]() |