RE: RMAN backup all but delete n days old
- From: FMHabash <fmhabash@xxxxxxxxx>
- To: <rajendra.pande@xxxxxxx>, <Roger.Xu@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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.
-----Original Message-----
From: rajendra.pande@xxxxxxx
Sent: Tuesday, February 17, 2009 3:25 PM
To: Roger.Xu@xxxxxxxx; fmhabash@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Xu, Roger
Sent: Tuesday, February 17, 2009 3:19 PM
To: fmhabash@xxxxxxxxx; 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//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@xxxxxxxx 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.
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
