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

From: <shirish_at_microexcel.com>
Date: Thu, 7 Jul 2005 10:23:56 -0700
Message-ID: <20050707172356.3474.qmail@webmail10.mesa1.secureserver.net>

logseq for 8i database

sequence is for 9i databases

so use the terms accordingly while doing it

further starting from 9i , you dont need to use place this command in a run block

--Shirish

-------- Original Message --------
Subject: RE: RMAN archived redo log backup (a range of sequences)
From: "Roger Xu" <roger_xu@dp7uptx.com>
Date: Thu, July 07, 2005 11:14 am
To: "Allen, Brandon" <Brandon.Allen@OneNeck.com>, "Oracle-L@Freelists.
Org (E-mail)" <oracle-l@freelists.org>

Thank you! It works perfectly.

-----Original Message-----
From: Allen, Brandon [mailto:Brandon.Allen@OneNeck.com]
Sent: Wednesday, July 06, 2005 5:24 PM
To: Roger Xu; Oracle-L@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Roger Xu
Sent: Wednesday, July 06, 2005 3:16 PM
To: Roger Xu; Oracle-L@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Roger Xu
Sent: Wednesday, July 06, 2005 3: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.

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

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.

For technical support please email tech_support@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 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.

-- http://www.freelists.org/webpage/oracle-l Received on Thu Jul 07 2005 - 12:25:53 CDT