From oracle-l-bounce@freelists.org Thu Sep 1 15:41:52 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j81KfqG0009541 for ; Thu, 1 Sep 2005 15:41:52 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j81KfeIP009513 for ; Thu, 1 Sep 2005 15:41:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F30AA1E8D87; Thu, 1 Sep 2005 15:08:48 -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 03007-04; Thu, 1 Sep 2005 15:08:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7081A1E8D88; Thu, 1 Sep 2005 15:08:48 -0500 (EST) From: "Ruth Gramolini" To: , Subject: RE: Duplicating 8.1.7 database to a scn Date: Thu, 1 Sep 2005 16:06:45 -0400 Message-ID: <00a501c5af30$ad70f7c0$6759000a@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A6_01C5AF0F.265F57C0" In-Reply-To: <5e317f31050831122614c94877@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-archive-position: 24928 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: rgramolini@tax.state.vt.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.1 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_00A6_01C5AF0F.265F57C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Pete, To do a point in time recovery, you need to set you NLS_DATE_FORMAN to mm-dd-yy:hh24:mi_ss in the OS before envoking rman. With the auxiliary database (clone) in nomount do a connect target..., connect auxiliary ..., connect rcvcat .. and then the first line in the run command should be set until time '09-02-2005:08:00:00'; for example. If you want to know what scn you should use for a set scn look at v$log. or v$archived_log (specify the date you want if you want to find the scn for or you will get a huge list). HTH, Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Peter Hitchman Sent: Wednesday, August 31, 2005 3:26 PM To: oracle-l@freelists.org Subject: Duplicating 8.1.7 database to a scn Hi, I need to duplicate an Oracle 8.1.7 database to a given point in time. I have seen problems when trying to do this with the set command specifying a date, but I have done it using an scn number when I got the scn number from a duplication that did a full recovery. If I stop all transactions in the database how do I find out what scn number to use? I have it in mind to archive the current log so that all of the changes are in the redo stream, will the most recent archive log give me the scn number and if so where do I get this information from. Thanks Pete ------=_NextPart_000_00A6_01C5AF0F.265F57C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Pete,

To do = a point in=20 time recovery, you need to set you NLS_DATE_FORMAN to = mm-dd-yy:hh24:mi_ss in the=20 OS before envoking rman. With the auxiliary database (clone) in = nomount do=20 a connect target..., connect auxiliary ..., connect rcvcat .. and then = the first=20 line in the run command should be set until time '09-02-2005:08:00:00'; = for=20 example.

If you = want to know=20 what scn you should use for a set scn look at v$log. or = v$archived_log=20 (specify the date you want if you want to find the scn for or you will = get a=20 huge list).

HTH,

Ruth

-----Original = Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf=20 Of Peter Hitchman
Sent: Wednesday, August 31, 2005 3:26=20 PM
To: oracle-l@freelists.org
Subject: Duplicating = 8.1.7=20 database to a scn

Hi,
I need to duplicate = an=20 Oracle 8.1.7 database to a given point in time. I have seen problems = when trying=20 to do this with the set command specifying a date, but I have done it = using an=20 scn number when I got the scn number from a duplication that did a full=20 recovery.

If I stop all transactions in the database how do I = find out=20 what scn number to use? I have it in mind to archive the current log so = that all=20 of the changes are in the redo stream, will the most recent = archive log=20 give me the scn number and if so where do I get this information=20 from.

Thanks

Pete ------=_NextPart_000_00A6_01C5AF0F.265F57C0-- -- http://www.freelists.org/webpage/oracle-l