Using 'delete obsolete' command

[dzunic]

I have 2 databases and for one I have to make full online backup every day and for second incremental backup which starts on Friday (full backup) and every day of the week goes incremantal backup.

Question are:

Is it possible to specify above mentioned scenario with 'retention policy'? (to delete old backups and keep one backup per week, month ...)
How can I delete old backups? Is it possible to do that with 'delete obsolete' command? Does this command phisycaly delete old backups from disk if the retention policy is well specified.


Also is it possible to maintain backup and recovery of more databases on diferent servers using one rman on one database server ?

Thanks

[ebrian]

Sure, you can configure your retention policy based on a recovery window or a redundancy factor. Once you have a retention policy configured, RMAN will physically remove any obsolete backups from disk or tape that exceed the retention policy.

If you have a central server accessible to the various databases you need to backup, you can configure a recovery catalog in the central server to serve as the RMAN repository for the various databases.

[yxez]

Hi friend,

What if your rman repository crahed, does rman rman take a
backup of itself?

[ebrian]

The database that maintains the recovery catalog is just another database. If it crashes, you have to recover it just like any other database. You should safeguard it as you would any other database. You could backup the recovery catalog database with a user-managed cold or hot backup.

[dzunic]

Does anybody have idea for creating retention policy configure from first post (keep 3 last backups, one per week, one per month and one in last 3 months)