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

Home -> Community -> Usenet -> c.d.o.misc -> Re: RMAN Log Analyzer

Re: RMAN Log Analyzer

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 12 Sep 2007 09:18:00 -0700
Message-ID: <1189613872.599557@bubbleator.drizzle.com>


Kake.gdp_at_gmail.com wrote:

>> Prepare yourself for disappointment.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

>
> Yeah I do...
>
> Well I did one little grep script and now got atleast the full backup
> time. That would include backup and validation.
> 2004 avg backuptime was ~ 4 hours 20 min
> 2007 avg is 37 hour 45 min and peak is 42 hours
>
> Problems 15 since Feb 07, caused by file being used by File Backup
> which is asumed reason for carshing the validation. Without validation
> files backed to tape are not removed thus making the drive full.
>
> Now I don't know how much more data this would be. But avg filebackup
> in 2004 was 100+ GB now it is 600+ GB
> Now that I know atleast some facts. I can ask money for example
> checking the network to see if it no longer can support such traffic.

What version of Oracle?
Most people run full backups once a week or once a month using incremental backups in between. With Block Change Tracking enabled (http://www.psoug.org/reference/block_change_tracking.html) backups should not take that long.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Sep 12 2007 - 11:18:00 CDT

Original text of this message

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