469,150 Members | 1,988 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

rman backup - retention policy , archive logs

Hello

I have Oracle 10.2.0.1 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 2514
debasisdas
8,127 Expert 4TB
Hi
nevsoft
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

Post your reply

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

Similar topics

1 post views Thread by RYAN | last post: by
2 posts views Thread by Tho Nguyen | last post: by
3 posts views Thread by Almund Sebi | last post: by
3 posts views Thread by Raquel | last post: by
9 posts views Thread by Stanley Sinclair | last post: by
reply views Thread by gohel | last post: by
2 posts views Thread by clilush | last post: by
reply views Thread by gunsbong | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.