Anyone performing full and incrmental backups of Oracle We run a level 0 on Friday night and a combination of level 1's and 2's the othter nights.
We just started inc backups, prior to that we were doing fulls each night. We would run a delete obsolete rman command after the full backps to keep 3 levels This wasnt changed when we went to incremental. I noticed in one of the log files this morning that rman deleted one the backup pieces created during the level 0 backup I dont think this should be the case. If we wanted to restore the level 0 we would be missing files What are the optimum RMAN retention policies and TSM retention policies for Oracle They must be different between using always full backups or a combination of full and inc RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 3 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Backup Set 31844 12-DEC-09 Backup Piece 31844 12-DEC-09 df_705420601_31958_1 <=full Backup Set 32011 15-DEC-09 Backup Piece 32011 15-DEC-09 bul0ucfs_1_1 <== inc deleted backup piece backup piece handle=df_705420601_31958_1 recid=31844 stamp=705420603 deleted backup piece backup piece handle=bul0ucfs_1_1 recid=32011 stamp=705638909 Deleted 2 objects Tim Brown Systems Specialist - Project Leader Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com <mailto:tbr...@cenhud.com> Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, please notify the sender immediately by replying to this note and deleting all copies and attachments. Thank you.
