Re: Redo logs only useful if archiving on

Yes. We have 4GB in our archive log directory. This is backed up and purged daily. Sometimes, we also get surprised by heavy updating and create more than 4GB in a day. We monitor the archive directory free space throughout the day (and night) and trigger extra jobs to backup and purge the archive directory.

Since we are using EBU with a third party network backup, sometimes we can't get the archive directory backed up and purged before it fills up! We have another directory that is reserved for export / import reorgs and we have a script that switches our archive destination to the reorg directory. This ends the archiver stuck condition immediately. After the normal archive directory is purged, we return to the original archive destination and mv the files.

#!/bin/ksh
. ~/obackup_deere/set_locale.sh
svrmgrl <<EOF
connect internal
archive log start to '${ORACLE_HOME}/sapreorg/${ORACLE_SID}arch'; exit
EOF shreterh_at_my-dejanews.com wrote:

> Having no trouble with archivelogging, except that we still need to work out
> archivelog space problems (need to adjust our scripts). Sometimes a large
> job takes us by surprise and creates tons of redo. As I say, we're still
> working it out. Anyone else have experience to share on archive log and
> large jobs?
>
> In article <358bebe7.39103848_at_192.86.155.100>,
> tkyte_at_us.oracle.com wrote:
> >
> > >For those of you running in archive log mode, is it working well or
> > >is it so cumbersome that its not worth the trouble? Would cold-backups
> > >be sufficient?
> >
> > It is not cumbersome at all, its pretty easy actually. It is *more then well
> > worth the trouble*. If you can afford to lose data, then you can skip using
> > archive log mode. If you cannot afford to lose data, then archive log mode is
> > the only way to go.
> >
> > Why do you think it is cumbersome?
> >
> > Thomas Kyte
> > tkyte_at_us.oracle.com
> > Oracle Government
> > Herndon VA
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sun Jun 21 1998 - 18:34:22 CDT