RE: RMAN archived redo log backup

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 7 Jul 2005 10:29:10 -0400
Message-ID: <000401c58300$3d6f7340$8459000a@vttaxnet.tax.state.vt.us>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu
Sent: Wednesday, July 06, 2005 4:05 PM
To: Oracle-L_at_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_at_dp7uptx.com.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 07 2005 - 10:20:00 CDT