Solved

RMAN Backup Question

Posted on 2014-04-01
3
430 Views
Last Modified: 2014-04-01
Running RMAN online backup daily.  I have retention set to one day.  Currently i have a
DELETE NOPROMPT OBSOLETE at the end, but I would like to configure the script such that the backup pieces are deleted daily, but the archived logs are not.  I'd like to have logs deleted only every two or three days.  How do I do that?
0
Comment
Question by:xoxomos
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 300 total points
ID: 39970659
It's been a while since I played with RMAN once I got my scripts set up but I believe you just need to set the archived redo log deletion policy.

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#BRADV89439

They are not flagged as obsolete until the retention has been exceeded.
0
 

Author Comment

by:xoxomos
ID: 39970728
Thanks.  Looks like that would be MUCH cleaner once i work it out.
0
 

Author Closing Comment

by:xoxomos
ID: 39970729
Thanx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now