RE: Can Log Files Be Archived To The Bit Bucket?
- From: "Pal, Raj" <Raj.Pal@xxxxxxxxxxxx>
- To: <jim.silverman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Apr 2007 14:07:15 -0600
>On Behalf Of jim.silverman@xxxxxxxxxxx
>Sent: Thursday, April 05, 2007 1:11 PM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: Can Log Files Be Archived To The Bit Bucket?
>We manage several non-production 10g databases that are currently shut
>...
>Thanks in advance for any suggestions.
>=====================================
>Jim Silverman
Jim,
You'll need archives for the duration of the level0 and level1 backups
at a minimum, so I don't think you should be trying to archive them to
the "bit bucket". My assumption here is that you'll have the instance
open for the backups. And you already said this... but to restate...
you'd never do this with a prod instance.
That said, one idea is to write a dance around rman arch backups that
names the backupsets something like %d_%s_%p_%c_%t.delete in the same
directory as log_archive_dest_1. Make sure you include a 'delete input'
clause and conclude the script with a `rm <log_archive_dest_1>*.delete`.
Run it often enough to not run out of the small amount of space you
allocate for it. How much space do you need? You'll need ~2x the
amount of space that gets used in the time it takes to backup via
level0. The 2x is the worst case scenario for arch backupsets to get
created before they get deleted by the 'delete input' option.
This will keep your controlfile with consecutively backed up arch
sequences and removes the backupsets fairly quickly.
During your level0 & level1 backups, be sure to not have this arch
backup/delete script run. Note the system time before starting the
level0/1 backup. Backup your datafile backupsets, then run an arch
backup that backs up all arch's since the time you noted before the
level0/1. Save the arch backupsets with the data backupsets and
controlfiles, etc... Once complete, startup your backup/delete script
again.
I sort of rambled... let me know if it needs clarification.
---------------------------------------------------
RAJ@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
