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 AM
To: Multiple recipients of list ORACLE-L
Subject: kinda OT: veritas netbackupRESEND: 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
