RE: RMAN backup all but delete n days old
Date: Tue, 17 Feb 2009 15:58:56 -0500
To only delete archive logs that have been successfully transported/applied to the standby try:
Configure archivelog deletion policy to applied on standby;
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of 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 :)
[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?
[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
The backup ... Logs ... Delete input does not allow to have separate criteria for backup vs. Delete.
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
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.
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
http://www.freelists.org/webpage/oracle-l Received on Tue Feb 17 2009 - 14:58:56 CST