DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: DB policies and procedures

Threaded View

  1. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by iris View Post
    Hi, iam working with a client for which a new OLTP application is under development, for this application we are having oracle 10g rac database.


    I have been told to prepare database policies and procedures for this new environment.

    My question is, what could be the DB policies and procedures?
    For starters I would work on five chapters:
    1- Brief description of database objective, size, etc.
    2- Document Infrastructure - hardware, OS, RDBMS & Connectivity
    3- Backup/Recovery Strategy
    4- Security Strategy
    5- Document development model, like Three Tier development model including how to proceed to get code and objects created/compiled into Test and Production.

    Hope this helps.
    Last edited by PAVB; 12-08-2010 at 05:48 PM. Reason: typo
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width