FW: kinda OT: veritas netbackup
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 SpearsSr. Oracle Database Administrator OCP -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: Re: kinda OT: veritas netbackup 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 AdarMehish - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Thursday, December 19, 2002 5:50 PM Subject: kinda OT: veritas netbackup 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
FW: kinda OT: veritas netbackup
Yes, we have coded it to do thisand it works but for many reasons.. including simplicitywe want to avoid thissolution for theentire12B enterprise solution... when it confuses others, and is much more vulnerable for screwups with Mount point management and recovery. Brian Spears -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: kinda OT: veritas netbackup How about running a script just before the backup that 1) Reads the current log number. 2) Forces a log switch. 3) Copies the logs to a seperate directory. 4) Backups up that seperate directory Leave the archive directory alone. Do not back it up. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: kinda OT: veritas netbackup 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
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 [EMAIL PROTECTED] 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 - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: FW: kinda OT: veritas netbackup
From an external perspective this is easy to say but... a) You've coughed up a whole lot of cash for NetBackup. b) You're looking for a good enterprise wide solution Seems like its time to go RMAN hth connor --- Spears, Brian [EMAIL PROTECTED] wrote: 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 - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] 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 = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).