1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

How Do You Handle Your DB Backup Volumes ?

Discussion in 'Backup / Archive Discussion' started by buster99, Jan 27, 2017.

  1. buster99

    buster99 ADSM.ORG Member

    Joined:
    May 14, 2008
    Messages:
    124
    Likes Received:
    0
    Hello, I have an open PMR with IBM regarding a .DSS file issue and while researching the issue for us, the IBM Support Tech looked into our current tape volume setup and told us that we are handling our DBB and DBS tape volumes incorrectly. I wanted to check here and see if he is correct.

    We currently run a DBS backup to tape and send it offsite everyday with a 7 day retention.
    We also run a DBB backup daily that stays in our library with a 7 day retention.

    He says that we should be sending the DBB backup offsite and keeping the DBS backup onsite. Is that correct ?

    Thank you
     
  2.  
  3. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,814
    Likes Received:
    358
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Yes!!! IBM is correct. The DBB are the full backups and used for DR/BCP purposes.
     
  4. buster99

    buster99 ADSM.ORG Member

    Joined:
    May 14, 2008
    Messages:
    124
    Likes Received:
    0
    OK, we have been sending the daily DBS backup offsite for years and keeping the DBB onsite. We run a DBS and then a DBB daily

    This is from a TSM Disaster Recovery Manager Manual...


    There are two types of database backups that are typically used for recovery; full


    database backups and snapshot backups. Full database backups are typically done on a


    daily basis after all copy storage pools have been updated and they are stored on-site.


    Snapshot database backups are full database backups, but they do not reset the


    recovery log. Snapshot database backups are typically used for off-site disaster recovery


    purposes. They are made on a daily basis following production of a copy storage pool


    and are sent off-site with the rest of the daily tapes.
     
  5. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,814
    Likes Received:
    358
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    The key words here are:

    Snapshot database backups are full database backups, but they do not reset the recovery log.

    You can send them offsite if you wish but the FULL DB backup is the desired DR recovery mode. I never use snapshots as I see these as useless. I need the recovery logs reset.
     
  6. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,533
    Likes Received:
    354
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    But, if you do a DR at an alternate location because the primary location is down, you don't have the logs anyway, so backup or snapshot, both contain the same thing and both without the logs.
     
  7. Rigido

    Rigido ADSM.ORG Senior Member

    Joined:
    Apr 21, 2006
    Messages:
    103
    Likes Received:
    4
    Occupation:
    AIX, TSM and Storage specialist
    Location:
    Rome, Italy
    I remember when IBM introduced DBS on TSM and I'm pretty sure colleagues told me that it was introduced just for DR purposes. Some sort of a "different full db backup" (I always thought to a dump/export) that do not interfere with every day backup (incremental and full) activity, that's why it doesn't reset logs.
    Every DR test I did I always used DBS with no issues at all.
     
  8. buster99

    buster99 ADSM.ORG Member

    Joined:
    May 14, 2008
    Messages:
    124
    Likes Received:
    0
    Thank you all for the replies to my DB Backup question. For now we are going to keep our process steps the same...DBB onsite and DBS offsite since that has been working for us. I'm going to be making some changes that allow us to automatically delete the unnecessary .DSS files from our storage directories and volhist.

    Thanks again
     

Share This Page