Fwd: [Veritas-bu] oracle rman selective datafile restores

This is a multi-part message in MIME format.

--Boundary_(ID_hQwXoXhaYBToEzlXT9b2HQ)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline

more info:

here a sample of the script to restore two datafiles.  netbackup will restore 
the entire image related to this datafile which could be 10-30 gigs where as 
the datafile itself is only 1 gig.  Also even if the next datafile is in the 
same image it will have to restore that same image once again.  Is this 
expected behavior?


run{
 allocate channel t1 type 'sbt_tape';
 set until time "to_date('2005-03-17 02:00:00','YYYY-MM-DD HH24:MI:SS')";
 restore datafile 353;
 restore datafile 354;
}

--Boundary_(ID_hQwXoXhaYBToEzlXT9b2HQ)
Content-type: message/rfc822
Content-disposition: inline

Return-path: <veritas-bu-admin AT mailman.eng.auburn DOT edu>
Received: from ms-mta-02-eri0 (ms-mta-02-eri0 [10.25.8.235])
 by ms-mss-04.southeast.rr.com
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 with ESMTP id <0IDK0081E7B0BX AT ms-mss-04.southeast.rr DOT com> for
 listmail AT triad.rr DOT com; Fri, 18 Mar 2005 12:59:24 -0500 (EST)
Received: from ohmx01.mgw.rr.com (ohmx01.mgw.rr.com [65.24.0.111])
 by ms-mta-02.southeast.rr.com
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 with ESMTP id <0IDK00BTY7B0H0 AT ms-mta-02.southeast.rr DOT com> for
 listmail AT triad.rr DOT com (ORCPT listmail AT triad.rr DOT com); Fri,
 18 Mar 2005 12:59:24 -0500 (EST)
Received: from mailman.eng.auburn.edu (mailman.eng.auburn.edu [131.204.12.57])
        by ohmx01.mgw.rr.com (8.12.10/8.12.8) with ESMTP id j2IHxFsx007036      
for
 <listmail AT triad.rr DOT com>; Fri, 18 Mar 2005 12:59:20 -0500 (EST)
Received: from mailman.eng.auburn.edu (mailman@localhost [127.0.0.1])
        by mailman.eng.auburn.edu (8.12.3/8.12.3/Debian-6.6)
 with ESMTP id j2IHK4Ar008791; Fri, 18 Mar 2005 11:20:04 -0600
Received: from ms-smtp-02-eri0.southeast.rr.com
 (ms-smtp-02-lbl.southeast.rr.com [24.25.9.101])        by 
mailman.eng.auburn.edu
 (8.12.3/8.12.3/Debian-6.6) with ESMTP id j2IHI8Ar008731        for
 <veritas-bu AT mailman.eng.auburn DOT edu>; Fri, 18 Mar 2005 11:18:08 -0600
Received: from ms-mss-04-ce0-1 ([10.10.5.90])
        by ms-smtp-02-eri0.southeast.rr.com (8.12.10/8.12.7)
 with ESMTP id j2IHI50V002826   for <veritas-bu AT mailman.eng.auburn DOT edu>; 
Fri,
 18 Mar 2005 12:18:06 -0500 (EST)
Received: from southeast.rr.com (localhost [127.0.0.1])
 by ms-mss-04.southeast.rr.com
 (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep  8 2003))
 with ESMTP id <0IDK008XR5E5BX AT ms-mss-04.southeast.rr DOT com> for
 veritas-bu AT mailman.eng.auburn DOT edu; Fri, 18 Mar 2005 12:18:05 -0500 (EST)
Received: from [10.10.1.25] (Forwarded-For: [208.23.159.127])
 by ms-mss-04.southeast.rr.com (mshttpd); Fri, 18 Mar 2005 12:18:05 -0500
Date: Fri, 18 Mar 2005 12:18:05 -0500
From: listmail AT triad.rr DOT com
Subject: [Veritas-bu] oracle rman selective datafile restores
Sender: veritas-bu-admin AT mailman.eng.auburn DOT edu
To: veritas-bu AT mailman.eng.auburn DOT edu
Errors-to: veritas-bu-admin AT mailman.eng.auburn DOT edu
Reply-to: listmail AT triad.rr DOT com
Message-id: <c6aaadc6e775.c6e775c6aaad AT southeast.rr DOT com>
MIME-version: 1.0
X-Mailer: iPlanet Messenger Express 5.2 HotFix 1.21 (built Sep  8 2003)
Content-type: text/plain; charset=us-ascii
Content-language: en
Content-transfer-encoding: 7BIT
Content-disposition: inline
X-Accept-Language: en
Priority: normal
Precedence: bulk
X-BeenThere: veritas-bu AT mailman.eng.auburn DOT edu
X-Virus-Scanned: Symantec AntiVirus Scan Engine
X-Virus-Scanned: Symantec AntiVirus Scan Engine
X-Mailman-Version: 2.0.3
List-Post: <mailto:veritas-bu AT mailman.eng.auburn DOT edu>
List-Subscribe: <http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu>,
        <mailto:veritas-bu-request AT mailman.eng.auburn DOT 
edu?subject=subscribe>
List-Unsubscribe: <http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu>,
        <mailto:veritas-bu-request AT mailman.eng.auburn DOT 
edu?subject=unsubscribe>
List-Archive: <http://mailman.eng.auburn.edu/pipermail/veritas-bu/>
List-Help: <mailto:veritas-bu-request AT mailman.eng.auburn DOT 
edu?subject=help>
List-Id: Discussion of Veritas Inc. backup related products
 <veritas-bu.mailman.eng.auburn.edu>
Original-recipient: rfc822;listmail AT triad.rr DOT com

I've noticed today when restoring specific datafiles from a full RMAN backup, 
Netbackup seems to be restoring the entire image.  Although I cant seem to find 
where NB is storing the image after the restore (df -k isn't showing a large 
growth), according to the numbers I restoring far more than I need to.  Also 
the restore time is obviously way to long for the number/size of datafiles I 
picked.

My setsize in the RMAN script is 8g so I'm assuming I need to drop that around 
2-4gb.  Filesperset is 50 so maybe that will need to be reduce.  The database 
is around 100g total.

Are there any other options to consider for getting netbackup to restore as 
little as possible thus speeding up the restore times?

Thanks 

Solaris 8
NB Datacenter 4.5

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

--Boundary_(ID_hQwXoXhaYBToEzlXT9b2HQ)--