Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 30972 invoked from network); 23 Nov 2007 03:39:21 -0600
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 23 Nov 2007 03:39:20 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 90A707BFEFB;
 Fri, 23 Nov 2007 04:39:20 -0500 (EST)
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 05344-09; Fri, 23 Nov 2007 04:39:20 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1725E7BFEE1;
 Fri, 23 Nov 2007 04:39:20 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 23 Nov 2007 03:52:53 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3A2E97C0388
 for <oracle-l@freelists.org>; Fri, 23 Nov 2007 03:52:53 -0500 (EST)
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 31158-09 for <oracle-l@freelists.org>;
 Fri, 23 Nov 2007 03:52:53 -0500 (EST)
Received: from gateway.bjss.co.uk (host29.bjss.co.uk [82.109.33.29])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D744D7C0385
 for <oracle-l@freelists.org>; Fri, 23 Nov 2007 03:52:51 -0500 (EST)
Received: from exchange.bjss.co.uk ([172.22.32.28]) by gateway.bjss.co.uk with Microsoft SMTPSVC(6.0.3790.3959);
	 Fri, 23 Nov 2007 08:52:50 +0000
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis
Subject: RE: about rman, recovery and date format
Date: Fri, 23 Nov 2007 08:52:50 -0000
Message-ID: <E02CB9B2777CF8459C86C49B48C48EC602B4D17A@exchange.bjss.co.uk>
In-Reply-To: <47453E4D.2080205@wp-sa.pl>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: about rman, recovery and date format
References: <47453E4D.2080205@wp-sa.pl>
From: "John Hallas" <john.hallas@bjss.co.uk>
To: <rems@wp-sa.pl>,
 <oracle-l@freelists.org>
X-NAIMIME-Disclaimer: 1
X-NAIMIME-Modified: 1
X-OriginalArrivalTime: 23 Nov 2007 08:52:50.0574 (UTC) FILETIME=[3A4CF2E0:01C82DAE]
X-archive-position: 3447
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: john.hallas@bjss.co.uk
Precedence: normal
Reply-to: john.hallas@bjss.co.uk
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

I have had problems in the past with setting the data format. I tend to
use the following method these days

run {
sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
set until time = '2004-03-01:09:00:00';
allocate channel ch_1 type 'SBT_TAPE' format 'full_1_%s_%p_%t';
restore controlfile;
}

-----Original Message-----
From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] On Behalf Of Remigiusz Sokolowski
Sent: 22 November 2007 08:31
To: 'ORACLE-L'
Subject: about rman, recovery and date format


  hi

lastly I've had to recover one of databases.
I use script below
----------
run {
allocate channel d1 device type disk format '<path>/%d/%d_%T_%U.bkp'
sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
set until time '2007-11-20 23:00:00';
restore database;
recover database;
}
---------
During recover operation I 've got  error


  ORA-01841: (full) year must be between -4713 and +9999, and not be 0





BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW.
Registered in England with company number 2777575.
http://www.bjss.co.uk

--
http://www.freelists.org/webpage/oracle-l