DB policies and procedures

[iris]

any sample document/link for implementing database policies and procedures.


thanks,

[vnktummala]

Can you please tell us what exactly you are looking for?

Policies and procedures is generic to understand your requirement.

Thanks,

[iris]

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?


thanks,

[PAVB]

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.

[iris]

Thanks, your points have given me initiative to define the DB policies and procedures.

[PAVB]

Thanks, your points have given me initiative to define the DB policies and procedures.

Glad to help.

[aberub]

Hi Iris:

Could you give me the policies and procedures you defined for DBA
aberub@hotmail.com

thanks