RE: RMAN backup all but delete n days old

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@xxxxxxxxx] 
Sent: Tuesday, February 17, 2009 4:56 PM
To: Pande, Rajendra; Roger.Xu@xxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@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

--
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@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.
--
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


Other related posts: