RE: RMAN archived redo log backup (a range of sequences)

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Thu, 7 Jul 2005 10:14:07 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C965C@irv2kexch01.tx.bg.corp>

Thank you! It works perfectly.

-----Original Message-----

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Wednesday, July 06, 2005 5:24 PM
To: Roger Xu; Oracle-L_at_Freelists. Org (E-mail) Subject: RE: RMAN archived redo log backup

I believe you could use something like this:

run{
backup archivelog from logseq = 94 until logseq = 103 thread 1; }

Regards,
Brandon

-----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 3:16 PM
To: Roger Xu; Oracle-L_at_Freelists. Org (E-mail) Subject: RE: RMAN archived redo log backup

No, you can not. I had to do:

backup format '/oback/obckp/redo-logs/QS1_%s_%p.logs' archivelog sequence 94;
backup format '/oback/obckp/redo-logs/QS1_%s_%p.logs' archivelog sequence 95;
backup format '/oback/obckp/redo-logs/QS1_%s_%p.logs' archivelog sequence 96;
backup format '/oback/obckp/redo-logs/QS1_%s_%p.logs' archivelog sequence 97;

.. .. ..

-----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 3: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.

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.

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.

For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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 - 11:12:01 CDT