Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backup

Re: Backup

From: Kelterere Raimund Paul <raimund.kelterer_at_dlb1.siemens.de>
Date: 1998/03/10
Message-ID: <35050A2E.1391@dlb1.siemens.de>#1/1

Andreas Moroder wrote:
>
> Hello all,
>
> i want to compress my archive-log files before backing up, but how do i
> know
> if the archive has finished to write the last file. If i begin to compress
> or even to backup the last file while it is being written by the archiver,
> i get only a partial backup of this file
>
> amoroder_at_se-nord.provinz.bz.it

I'm using a perl-script, which cron starts every 10 minutes. First the script copies the archived_log_files to a secondary disk drive, checking wether the size is equal. Then both of them are gzip-ed and the gzip-ed files are compared and errors are evaluated. Finaly gzip-ed files older than a limit (in days) are deleted on both directories (drives).

All in all this is very stable, if you do not have jobs, producing lot of redo information. It happend that a job produced redo faster than the perl-script can pack old redo information. In the past it happened that more than ones 'instance' of the script were running due to too any redo information within 10 minutes. my current version exits immediatly, if a process whith the same name is running.

raimund Received on Tue Mar 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US