472,353 Members | 1,384 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

rman backup - retention policy , archive logs


I have Oracle on Solaris 10g.

I want to make level0 incremental backup every night and level1 incremental backup during the day.
Each level0 backup will be copied over network to machine with tape and will be moved to the tape.
Because there is need to be able to restore database to any point in time I have to retain all archive logs
from the start (database will be used for about 1 month). At the beginnig I will take full backup of database
and store it at the tape.

I'm dealing with problem how to set up proper retention policy.
1. I would like to store on disk 3 recent backups (no room for more)
2. I would like to have all archive logs from the beginnig.

The problem is that if I set up retention policy in rman to 3 then when I execute
'delete obsolete' command older archive logs will be deleted.

Can You help me with this situation?
May 31 '07 #1
1 2610
8,127 Expert 4TB
Welcome to TSDN
Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.
It will help Experts in the forum in solving/underestanding your problem in a better way.
May 31 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: RYAN | last post by:
Hi All, I am new to Oracle and I have some question that I hope that someone out there can help me. I have heard the Oracle Rman can do...
by: Tho Nguyen | last post by:
Hi, folks! I am new to RMAN and now trying to configure it. There is one issue concerning me. Let's say I backup the target database every 6:PM...
by: Almund Sebi | last post by:
(Using UDB 7.2 FP11). Given this output from LIST BACKUP HISTORY FOR MYDB: (It's an online backup image) > Op Obj Timestamp+Sequence Type Dev...
by: Raquel | last post by:
I am a newbie to UDB and reading the backup processes on UDB which look pretty good to me. Now, if these good backup and recovery procedures are...
by: Stanley Sinclair | last post by:
I just brought a new small server online. It has two disks in RAID1 (mirrored) for the operating system and logs and DB2 DBMS. DB2 data on a...
by: Konstantin Andreev | last post by:
Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with...
by: gohel | last post by:
I have cofigured rman on linux with oracle 9i (catdb) as revecory catalog db and target db is on win XP with oracle 9i in archive log mode , Now...
by: clilush | last post by:
I've been working with db2 8.2fp14 for over a year now and was wondering what is a "standard" way of doing a backup to provide 24/7 operations with...
by: gunsbong | last post by:
hello again everybody.. i just copied the backup file from production to another server with the same config with the production...when i restore...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.