RE: rman archivelog backup

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Wed, 6 Apr 2011 15:29:52 -0700
Message-ID: <>

OOPS! My previous example was 4 minutes.

Michael Dinh

NOTICE OF CONFIDENTIALITY - This material is intended for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this email (and attachments) is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Please notify the sender of the error and delete the e-mail you received. Thank you. From: [] On Behalf Of Robert Freeman Sent: Wednesday, April 06, 2011 3:12 PM
To:; Subject: Re: rman archivelog backup

The Oracle documentation talks about doing just that..... As does my RMAN book. Have a lookie at

See if you find your answer there. something along the line of backup archivelog from time 'sysdate - 4/24';

Note that this would get you all archived redo logs generated AFTER 4 hours ago. So if it was generated 4 hours ago or earlier you would not get it backed up, if it was generated 3:59:59 ago it would get backed up.



Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE Author of various books on RMAN, New Features and this shorter signature line. Blog: Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is just the opinion of one Oracle employee. I can be wrong, have been wrong in the past and will be wrong in the future. If your problem is a critical production problem, you should always contact Oracle support for assistance. Statements in this email in no way represent Oracle Corporation or any subsidiaries and reflect only the opinion of the author of this email.

From: K R <>
Sent: Wed, April 6, 2011 3:02:29 PM
Subject: rman archivelog backup


Is there a way to take the rman backup of archivelog for last 4 hours .

reason- sometimes we clone based on a full backup . but we dont always take rman backup of archivelogs . so idea is to just take the full backup + 4 hours of archivelog to make the duplicate run successfully. otherwise the duplicate fails and it is a mess to bring it up .

appreciate any suggestions


Received on Wed Apr 06 2011 - 17:29:52 CDT

Original text of this message