RE: RMAN backup all but delete n days old

From: <rajendra.pande_at_ubs.com>
Date: Tue, 17 Feb 2009 17:09:56 -0500
Message-ID: <5AA6C5BF38D0DA429D0D7B1A07B217480A52BC5C_at_NSTMC601PEX.ubsamericas.net>



See metalink note 274152.1

https://metalink2.oracle.com/metalink/plsql/f?p=130:3:124458895996708564 53::::p3_database_id,p3_docid,p3_show_header,p3_show_help,p3_black_frame ,p3_font:NOT,274152.1,1,1,1,helvetica

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

From: FMHabash [mailto:fmhabash_at_gmail.com] Sent: Tuesday, February 17, 2009 4:56 PM To: Pande, Rajendra; Roger.Xu_at_dpsg.com; oracle-l_at_freelists.org Subject: RE: RMAN backup all but delete n days old

Just to confirm.
With the first version, my experience has been that the time clause will apply on both the backup and delete. I have not found a way to separate them.
The nice thing is that this guarantees me no log will be deleted unless it is successfully backedup. I can always rely on the os to do that, but this negates the idea of using rman.
I will run a test and post back.

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

From: rajendra.pande_at_ubs.com
Sent: Tuesday, February 17, 2009 3:25 PM To: Roger.Xu_at_dpsg.com; fmhabash_at_gmail.com; oracle-l_at_freelists.org Subject: RE: RMAN backup all but delete n days old

I believe you can and RMAN has multiple options to do this. It can be a simple 1 step process or a 2 step process.

In a one step process you would code something like this. backup AS COMPRESSED BACKUPSET ARCHIVELOG ALL ARCHIVELOG UNTIL TIME 'SYSDATE - 1' delete input ;

Not very well documented but it works. Search metalink and you will find references to it.
Or you can do a second backup for the ones to delete. As for the standby question I think it is easier in 11G but in 10 you have to do some work up front and generate a script dynamically to do the stuff you want.

Hopefully I answered the right question :)

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Xu, Roger Sent: Tuesday, February 17, 2009 3:19 PM To: fmhabash_at_gmail.com; Oracle-L Group Subject: RE: RMAN backup all but delete n days old

I have a similar question - hope someone can answer both :)

Can we backup all offline redo logs and delete only the ones which have been successfully transferred to the standby?

TIA!
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of FMHabash Sent: Tuesday, February 17, 2009 1:36 PM To: Oracle-L Group
Subject: RMAN backup all but delete n days old

Is there away in rman to backup all logs on disk, but delete n days old ones.
 The backup ... Logs ... Delete input does not allow to have separate criteria for backup vs. Delete.

Thanks

--

http://www.freelists.org/webpage/oracle-l  

http://www.drpeppersnapplegroup.com/about/corporate to learn more about Dr Pepper Snapple Group's commitment to corporate social responsibility.

Please be conscious of the environment and print this email only if absolutely necessary.
This e-mail (including any attachments) is confidential and may contain privileged information of Dr Pepper Snapple Group, Inc. and/or its subsidiaries ("Dr Pepper Snapple Group"). If you are not the intended recipient or receive it in error, you may not use, distribute, disclose or copy any of the information contained within it and it may be unlawful to do so. If you are not the intended recipient, please notify us immediately by returning this e-mail to us at mailto:mailerror_at_dpsg.com and destroy all copies. Any views expressed by individuals within this e-mail do not necessarily reflect the views of Dr Pepper Snapple Group. This e-mail does not constitute a binding offer, acceptance, amendment, waiver or other agreement, unless the intent that an e-mail will constitute such is clearly stated in the body of the email. Recipients are advised to subject this e-mail and attachments to their own virus checking, in keeping with good computing practice. Please note that e-mail r
 eceived by Dr Pepper Snapple Group may be monitored in accordance with applicable law.
--

http://www.freelists.org/webpage/oracle-l

Please do not transmit orders or instructions regarding a UBS account electronically, including but not limited to e-mail, fax, text or instant messaging. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

UBS Financial Services Inc.

UBS International Inc.

UBS Financial Services Incorporated of Puerto Rico

UBS AG Please do not transmit orders or instructions regarding a UBS account electronically, including but not limited to e-mail, fax, text or instant messaging. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

UBS Financial Services Inc.

UBS International Inc.

UBS Financial Services Incorporated of Puerto Rico

UBS AG
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 17 2009 - 16:09:56 CST

Original text of this message