rman backup - retention policy , archive logs

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nevsoft
    New Member
    • May 2007
    • 1

    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?
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    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.

    Comment

    Working...