RE: RMAN backup all but delete n days old
Date: Tue, 17 Feb 2009 16:55:44 -0500
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.
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 - 15:55:44 CST