Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 23369 invoked from network); 14 Sep 2007 03:13:38 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 14 Sep 2007 03:13:37 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09451742C7C;
 Fri, 14 Sep 2007 03:34:54 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 01796-03-17; Fri, 14 Sep 2007 03:34:53 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1FAA742910;
 Fri, 14 Sep 2007 03:34:52 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 14 Sep 2007 02:49:52 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6ECD5742AF3
 for <oracle-l@freelists.org>; Fri, 14 Sep 2007 02:49:52 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 17472-02 for <oracle-l@freelists.org>;
 Fri, 14 Sep 2007 02:49:52 -0400 (EDT)
Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.186])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BD6D474299B
 for <oracle-l@freelists.org>; Fri, 14 Sep 2007 02:49:51 -0400 (EDT)
Received: by rv-out-0910.google.com with SMTP id b22so583202rvf
        for <oracle-l@freelists.org>; Fri, 14 Sep 2007 00:28:34 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        bh=P2UIpXGBRKaG2eaCRo1l8cbGg6mBImF3GyYzHbMhInM=;
        b=BmJ/bhZUfP2XAVeiZLCgRnLksKvrkneb2GQLCj7mH0IiLab0i1fcjvu+mOhHC8K0vENm7xBYVSzE7K3yg90ZdfHOQoXh7f0brjrs9m3PJxxSPLouBOC/nnGUCSKfqcK5zfo45ppVrByW7N9pHgWlATdLpo6zMP3Mhds8/oJTWhw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=puHRMghBwBhvt9j1Uuqs6Xr9abhEfagnG9EOq5luVcFOyEKGkgq29KDVUy5Xe4+BESFH3PulvOa7jJXJPaMfdkbEpr1cDtS6Xgt7JOYRcG+F6QeGjDZpsB4p1sPETq51b9NeHZPZHldjo2Vho9kC1Vi8rtcosObyht8jTdPGpuA=
Received: by 10.114.14.1 with SMTP id 1mr1462997wan.1189754913750;
        Fri, 14 Sep 2007 00:28:33 -0700 (PDT)
Received: by 10.114.127.13 with HTTP; Fri, 14 Sep 2007 00:28:33 -0700 (PDT)
Message-ID: <7765c8970709140028p48e44a9fya195aa3110f6a13b@mail.gmail.com>
Date: Fri, 14 Sep 2007 08:28:33 +0100
From: "Niall Litchfield" <niall.litchfield@gmail.com>
To: hrishys@yahoo.co.uk, oracle-l@freelists.org
Subject: Re: RMAN-05019 Warning Oracle reccommended backup
In-Reply-To: <847617.2005.qm@web27808.mail.ukl.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <200709121242.l8CCg1Bf021731@smtp43.singnet.com.sg>
	 <847617.2005.qm@web27808.mail.ukl.yahoo.com>
X-archive-position: 1556
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: niall.litchfield@gmail.com
Precedence: normal
Reply-to: niall.litchfield@gmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain

Actually it looks like I might have missed the point a bit. Your title
talks about Oracle recommended backup and you do have automatic
channels configured for backupsets to disk. These however are datafile
copies - so not an Oracle recommended plan. I think therefore (not at
a pc so cannot test) that you'll want to manually allocate a channel
in your recovery script.

On 12/09/2007, hrishy <hrishys@yahoo.co.uk> wrote:
> Hi
>
> A friend of mine is using oracle suggested backup and
> he is running into
>
> RMAN-05019: WARNING: no channel of required type
> allocated to recover copy of datafile
>
> The doc says to use LIST command and then allocate the
> proper type
>
> SHow device type;
>
> RMAN configuration parameters are:
> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE
> TO BACKUPSET; # default
>
>
> RMAN> show datafile backup copies;
>
> RMAN configuration parameters are:
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK
> TO 1; # default
>
> Any ideas how we can help
>
> regards
> Hrishy
>
>
>
>
>       ___________________________________________________________
> Want ideas for reducing your carbon footprint? Visit Yahoo! For Good
> http://uk.promotions.yahoo.com/forgood/environment.html
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l


