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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can Log Files Be Archived To The Bit Bucket?

RE: Can Log Files Be Archived To The Bit Bucket?

From: Pal, Raj <Raj.Pal_at_echostar.com>
Date: Thu, 5 Apr 2007 14:07:15 -0600
Message-ID: <9B03F5DB6F5FAB42B13504933E0070AC08CE0314@MER2-EXCHB3.echostar.com>


>On Behalf Of jim.silverman_at_thomson.com
>Sent: Thursday, April 05, 2007 1:11 PM
>To: oracle-l_at_freelists.org
>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_at_EchoStar.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 05 2007 - 15:07:15 CDT

Original text of this message

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