From oracle-l-bounce@freelists.org Thu Jul 7 10:20:00 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j67FK0ko012098 for ; Thu, 7 Jul 2005 10:20:00 -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 j67FJoIP012056 for ; Thu, 7 Jul 2005 10:19:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E08E1CA409; Thu, 7 Jul 2005 09:31:12 -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 24600-01; Thu, 7 Jul 2005 09:31:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C933E1CA405; Thu, 7 Jul 2005 09:31:11 -0500 (EST) From: "Ruth Gramolini" To: , "Oracle-L@Freelists. Org (E-mail)" Subject: RE: RMAN archived redo log backup Date: Thu, 7 Jul 2005 10:29:10 -0400 Message-ID: <000401c58300$3d6f7340$8459000a@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C582DE.B65DD340" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: X-archive-position: 22177 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=-2.9 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_0005_01C582DE.B65DD340 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit You can backup a range of archived logs by date and you could determine the date range by looking at the date and time the archivelogs are created by using OEM or querying the catalog or controlfiles. I have never tried to backup a range by sequence. HTH, Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Roger Xu Sent: Wednesday, July 06, 2005 4:05 PM To: Oracle-L@Freelists. Org (E-mail) Subject: RMAN archived redo log backup Hi List, Can I use the following to backup a range of archived redo logs? Thanks, Roger ------------------------------------------------------------------------ run { backup format '/oback/obckp/redo-logs/QS1_%s_%p.logs' archivelog from sequence 94 to 103 delete input; } ------------------------------------------------------------------------ This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@dp7uptx.com. ------=_NextPart_000_0005_01C582DE.B65DD340 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

You = can backup a=20 range of archived logs by date and you could determine the date range by = looking=20 at the date and time the archivelogs are created by using OEM or = querying the=20 catalog or controlfiles. I have never tried to backup a range by=20 sequence.

HTH,

Ruth

-----Original Message-----
From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org]On Behalf Of Roger=20 Xu
Sent: Wednesday, July 06, 2005 4:05 PM
To:=20 Oracle-L@Freelists. Org (E-mail)
Subject: RMAN archived redo = log=20 backup

Hi=20 List,

Can I = use the=20 following to backup a range of archived redo logs?

Thanks,

Roger

----------------------------------------------= --------------------------

run {

backup

format=20 '/oback/obckp/redo-logs/QS1_%s_%p.logs'

archivelog from=20 sequence 94 to 103 delete input;

}

----------------------------------------------------------------= --------

This=20 e-mail is intended solely for the person or entity to which it is = addressed and=20 may contain confidential and/or privileged information. Any review,=20 dissemination, copying, printing or other use of this e-mail by persons = or=20 entities other than the addressee is prohibited. If you have received = this=20 e-mail in error, please contact the sender immediately and delete the = material.=20
____________________________________________________________________<= BR>This=20 email has been scanned for all viruses by the MessageLabs Email Security = System.=20 Any questions please call 972-721-8257 or email your request to=20 tech_support@dp7uptx.com.
------=_NextPart_000_0005_01C582DE.B65DD340-- -- http://www.freelists.org/webpage/oracle-l