Saturday, 8 June 2013

Database Maintenance

What are the information i need to get for database maintenance from client?

 No of servers and how many databases in each server?
 How many production/test/development environments?
What kind of application  and how many tiers ?
   - please specify the softwares that were installed.
Is there any High Availability concepts implemented?
What is the backup strategy currently in place?
What is the size of databases?
Average number of issues per week?
p1 -
p2-
p3-
p4-


Do you have any ticketing systems
What type of  application?
tier 2,tier 3,tier n
application software?
Domain information
Do you have RAC database /Dataguard
database size
Can we have lease line
What is the backup strategy and backup duration?
Do you take backup for test environments
What is the storage type?


servers?
growth of the database.

OS version
Database version
webserver
application server