From oracle-l-bounce@freelists.org Fri Oct 22 07:05:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9MC5MD31373 for ; Fri, 22 Oct 2004 07:05:22 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9MC5JI31358 for ; Fri, 22 Oct 2004 07:05:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EC64C72CC42; Fri, 22 Oct 2004 07:11:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03486-06; Fri, 22 Oct 2004 07:11:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A73AD72CC4D; Fri, 22 Oct 2004 07:11:01 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: Peter.Hitchman@thomson.com X-Msg-Ref: server-12.tower-32.messagelabs.com!1098446937!23280965 X-StarScan-Version: 5.2.10; banners=.,-,- X-Originating-IP: [62.200.87.120] Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E4B8811@der-lon-msg-03.derwent.co.uk> From: "Hitchman, Peter" To: oracle-l@freelists.org Subject: rman backup to disk, mismatch in amount backed up to each channel Date: Fri, 22 Oct 2004 13:08:47 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 11419 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Peter.Hitchman@thomson.com Precedence: normal Reply-To: Peter.Hitchman@thomson.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, We back up an Oracle 8.1.7.4 database to disk using rman. Its about 900 Gb. It does work, but we find that much more data is getting sent to one channel than the other. So when its done, one filesystem is over 50% full and the other is only at 25%. I thought that rman automatically evened out the work done by each channel and that would result in an even (ish) amount of disk space being used in each filesystem. What we want is for the amount written to each channel to be about even, that way we can do a backup and then rename the directories the backup is in before we run another one, in case the next backup fails for some reason. We only two file systems available (and we had to beg for these) and managed to get enough space in each in theory to hold two disk backups. But its no good if one of the filesystems goes over 50% with the first backup, because it means the next one will fail because of lack of disk space. Does anyone know how we can control rman's behaviour in this case? (By the way, for reasons that are beyond me, it is not possible to change the disk space allocation so that the one of the filesystems is 25% bigger that the other). Here is the rman script:- connect target 'xxx/xxx@XXX'; connect catalog 'xxx/xxx@XXX'; run { allocate channel t1 type disk format '/rman1/backup/cms.%U'; allocate channel t2 type disk format '/rman2/backup/cms.%U'; set limit channel t1 kbytes 10000000; set limit channel t2 kbytes 10000000; set command id to 'rman_backup'; backup incremental level 0 cumulative skip readonly skip offline database; sql 'alter system archive log current'; change archivelog all crosscheck; backup filesperset 64 (archivelog all); backup current controlfile tag = ctrlfile_level0backup; release channel t1; release channel t2; change archivelog all crosscheck; } Thanks Pete [END] ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- http://www.freelists.org/webpage/oracle-l