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?
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?
Comment