ADSM-L

[ADSM-L] tsm tdp oracle rman backups

2009-12-18 15:47:43
Subject: [ADSM-L] tsm tdp oracle rman backups
From: Tim Brown <tbrown AT CENHUD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 18 Dec 2009 15:46:52 -0500
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: tbrown AT cenhud DOT com <mailto:tbrown AT cenhud DOT 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.

<Prev in Thread] Current Thread [Next in Thread>