Docstoc

a PDF version of this - WordWonk

Document Sample
a PDF version of this - WordWonk Powered By Docstoc
					Charlotte/PNG Data Management Standards
SYSTEM AFFECTED:                All Systems
PROCEDURE NO.                   HS_038_01.00
AUTHOR:                         William Whiteside        TITLE:    Technical Writer
DATE:                           October 14, 2005



PURPOSE
The purpose of this document is to provide the baseline description of the database management
standards.


REFERENCE
Please contact the Champion Managed Services Operations Manager to clarify any process
within this procedure and for any concern beyond its scope.


OVERVIEW AND PROCEDURES
        SOFTWARE

           SERVER
                TIVOLI Storage Manager (TSM) 5.x

           CLIENT
                AIX, TSM Client Module 5.x.x
                HP-UX TSM Client Module 5.x.x
                HP-UX TSM TDPs (oracle)
                Windows TSM Client Module 5.x
                Windows TSM TDP’s (Domino, SQL)
           Licensed, installable physical media is REQUIRED for ALL of the above.

        POLICIES
        Policies are rules that are set at the IBM Tivoli Storage Manager server to manage client
        data. Policies control how and when client data is stored, for example:
            •    How and when files are backed up and archived to server storage
            •    How space-managed files are migrated to server storage
            •    The number of copies of a file and the length of time copies are kept in server
                 storage
        The standard policy consists of a standard policy domain, policy set, management class,
        backup copy group, and archive copy group. The standard backup policy is the generic
        backup policy offering to all customers. Custom policies are available at negotiated
        prices. Contact the IBM – Champion Project Manager for custom policies. The
        attributes of the default policy are as follows:


                                                                                                    1
Charlotte/PNG Data Management Standards


       Standard Backup Policy (no agents, no archiving)
          •    Daily incremental backups will be taken
          •    An incremental backup is performed only if the file has changed since the last
               backup.
          •    Up to two backup versions of a file on the client’s system are retained in server
               storage. The most recent backup version is retained for as long as the original
               file is on the client file system. All other versions are retained for up to 30 days
               after they become inactive.
          •    One backup version of a file that has been deleted from the client’s system is
               retained in server storage for 60 days.
       Standard DRM Policy
          •    Duplicate copies of daily backups will be sent to offsite storage.
          •    The offsite storage retention policy follows that standard retention policy
               described above.
       PNG Custom Backup Policies
              WINDOWS FILE AND PRINT SERVERS (Clustered Drives)
                 •    Daily incremental backups will be taken
                 •    Monthly/Annual archive backups will be taken
                 •    An incremental backup is performed only if the file has changed since the
                      last backup.
                 •    Up to 32 backup versions of a file on the client’s system are retained in
                      server storage. Extra versions are retained for 32 days. The most recent
                      backup version is retained for as long as the original file is on the client file
                      system. 1 version is retained after they become inactive.
                 •    The newest backup version of a file that has been deleted from the client’s
                      system is retained in server storage for 32 days.
                 •    Monthly Archive versions are retained for 13 months
                 •    Annual Archive versions are retained for 7 years
              WINDOWS LOTUS NOTES SERVERS (TDP)
                 •    Daily incremental backups will be taken
                 •    Monthly/Annual archive backups will be taken
                 •    An incremental backup is performed only if the file has changed since the
                      last backup.
                 •    Up to 32 backup versions of a file on the client’s system are retained in
                      server storage. Extra versions are retained for 32 days. The most recent
                      backup version is retained for as long as the original file is on the client file
                      system. 1 version is retained after they become inactive.
                 •    The newest backup version of a file that has been deleted from the client’s
                      system is retained in server storage for 90 days.
                 •    Monthly Archive versions are retained for 13 months
                 •    Annual Archive versions are retained for 7 years
              WINDOWS SQL SERVERS (TDP)


2
                                      Charlotte/PNG Data Management Standards


    •   Daily incremental backups will be taken
    •   Monthly/Annual archive backups will be taken
    •   An incremental backup is performed only if the file has changed since
        the last backup.
    •   Up to 32 backup versions of a file on the client’s system are retained in
        server storage. Extra versions are retained for 32 days. The most
        recent backup version is retained for as long as the original file is on the
        client file system. 1 version is retained after they become inactive for 32
        days.
    •   The newest backup version of a file that has been deleted from the
        client’s system is retained in server storage for 32 days.
    •   Monthly Archive versions are retained for 13 months
    •   Annual Archive versions are retained for 7 years
WINDOWS SQL SERVERS (Not in above policies)
    •   Daily incremental backups will be taken
    •   Weekly archive backups will be taken
    •   An incremental backup is performed only if the file has changed since
        the last backup.
    •   Up to 32 backup versions of a file on the client’s system are retained in
        server storage. Extra versions are retained for 32 days. The most
        recent backup version is retained for as long as the original file is on the
        client file system. 1 version is retained after they become inactive.
    •   The newest backup version of a file that has been deleted from the
        client’s system is retained in server storage.
    •   Monthly Archive versions are retained for 13 months
    •   Annual Archive versions are retained for 7 years
HP-UX Servers
    •   Daily incremental backups will be taken
    •   Weekly archive backups will be taken
    •   An incremental backup is performed only if the file has changed since
        the last backup.
    •   Up to 32 backup versions of a file on the client’s system are retained in
        server storage. Extra versions are retained for 32 days. The most
        recent backup version is retained for as long as the original file is on the
        client file system. 1 version is retained after they become inactive.
    •   The newest backup version of a file that has been deleted from the
        client’s system is retained in server storage for 32 days.
    •   Monthly Archive versions are retained for 13 months
    •   Annual Archive versions are retained for 7 years
HP-UX Servers (TDPO)
    •   Daily incremental backups will be taken.



                                                                                       3
Charlotte/PNG Data Management Standards


                 •   An incremental backup is performed only if the file has changed since
                     the last backup.
                 •   Up to 32 backup versions of a file on the client’s system are retained in
                     server storage. Extra versions are retained for 32 days. The most
                     recent backup version is retained for as long as the original file is on the
                     client file system.
                 •   The newest backup version of a file that has been deleted from the
                     client’s system is retained in server storage for 32 days. (the retention is
                     controlled by Oracle)
            HP-UX Servers (Oracle Cold Backups)
                 •   Weekly archive backups will be taken
                 •   Up to 32 backup versions of a file on the client’s system are retained in
                     server storage. Extra versions are retained for 32 days. The most
                     recent backup version is retained for as long as the original file is on the
                     client file system. 1 version is retained after they become inactive.
                 •   The newest backup version of a file that has been deleted from the
                     client’s system is retained in server storage for 32 days.
                 •   Monthly Archive versions are retained for 13 months
                 •   Annual Archive versions are retained for 7 years
            VOIP Environment (data files)
            – VOIP environment (6 Servers) to be backed up to dedicated TSM Backup
              STG POOL
                 •   Daily incremental backups will be taken. (14,000 new VOIP files/8GB of
                     data are expected to be created daily)
                 •   An incremental backup is performed only if the file has changed since
                     the last backup.
                 •   Up to 1 backup version of a file on the client’s system is retained in
                     server storage. Backup versions are retained for 7 years (both active
                     and inactive).
                 •   The newest backup version of a file that has been deleted from the
                     client’s system is retained in server storage for 7 years.
            VOIP Environment
                 •   Backup/Archive Client only resides on (5)Witness Servers, and (1)ISI
                     Call Accounting Server.
                 •   SQL exports will be dumped for SQL databases.
                 •   Application backup outputs from (3)Call Manager Servers, (3)Unity
                     Servers, (8)IPCC Servers are re-directed to Witness Balance Server
                     shared SAN attached drive. The Application backup utilities will write to
                     the shared drive paths F:\CCM, F:\Unity, F:\IPCC respectively.
                 •   Daily incremental backups will be taken.
                 •   An incremental backup is performed only if the file has changed since
                     the last backup.
                 •   Up to 2455 backup versions of a file on the client’s system is retained in
                     server storage. Backup versions are retained for 7 years (both active


4
                                     Charlotte/PNG Data Management Standards


        and inactive). This will accommodate backups of the same filename
        over-written daily by the Unity Application. All other Application Backup
        Utilities maintain unique filenames. Only 1 file from each Application
        Backup Program will be written per day.
    •   The newest backup version of a file that has been deleted from the
        client’s system is retained in server storage for 7 years.
    •   Champion Managed Services Contact number: 888.997.7789 (for Tivoli
        Backup Support)
    •   eLoyalty Support contact number: TBD nnn.nnn.nnnn (for Application
        Backup Support)
PNG Custom DRM Policy
    •   Duplicate copies of daily backups will be sent to offsite storage.
    •   The offsite storage retention policy follows that custom retention policies
        described above.
    •   VOIP environment will be sent offsite once per month (due to 8GB of
        new data per day)




                                                                                    5

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:4/12/2013
language:Latin
pages:5