And you what that DBA are you? Avoiding
Tuesday, July 13, 2010
Microfiber Vs. Microsuade
Rescue 
written by April Sims and published by Packt Publishing who lists the following activities rightly DBA should be met, taking into account of course the work environment as they do not all apply to all cases. For example, a person who was hired to be in charge of say 20 databases with which the company operates, has many more responsibilities that a consultant as-first-a consultant will charge to the extent of consumption of hours care and generally the cost of this service is not cheap. Of course, depending on the contract, the consultant may from diagnostics in this or that problem that the present database, to implement solutions to correct notable performance problems or implementing new functionality all in favor of organizational software process improvement. You could say that both have similar profiles but with different specializations. What does a DBA do all day? The responsibilities are , install, configure and administer the database, these responsibilities can be divided into scheduled tasks to run at certain intervals. This is a generalized list and depending on the workplace may or may not apply.
Tasks such as monitoring and log rotation can be done via Enterprise Manager, Grid Control, Unix shell scripts, DBMS_SCHEDULER, Perl, database tools, third-or combinations of some of these. Prioritizing activities, daily, weekly, monthly, quarterly or annual
Let's see what are the priority activities needed to cover. The schedule depends on the workplace needs of the application and having the weight activities in general.
Daily Backups - are usually incremental and cumulative, one full week and the logs are stored and mailed to the DBA in case of failure.
Alert Log database - such as ORA errors, automatic email notifications, messages to pagers.
Weekly Backups - usually the entire database.
database cloning for non-productive - or automated scripts. Growth
database cloning for non-productive - or automated scripts.
growth monitoring tablespaces - the weekly accumulated in a month.
Application CPUs (Critical Patch Upate) and PSUs (September Patch Updates) production planning in suspension of service. Application of CPUs, PSUs instances once unproductive.
growth monitoring tablespaces - the monthly accumulated in an annual update courses
Annual Growth tablespaces - annual report.
Sum of trends and forecasts.
If generalize several of the points mentioned above, we will apply not only to the Oracle platform but can also serve as a reference for managers manage other databases.
Tasks such as monitoring and log rotation can be done via Enterprise Manager, Grid Control, Unix shell scripts, DBMS_SCHEDULER, Perl, database tools, third-or combinations of some of these. Prioritizing activities, daily, weekly, monthly, quarterly or annual
Let's see what are the priority activities needed to cover. The schedule depends on the workplace needs of the application and having the weight activities in general.
Daily Backups - are usually incremental and cumulative, one full week and the logs are stored and mailed to the DBA in case of failure.
Alert Log database - such as ORA errors, automatic email notifications, messages to pagers.
- ADRCI - Automatic and Log Rotation Utility Repository.
- filesystem space, CPU statistics and I / O - Manager requires OS support.
- SQL statements - Statements that are among the top 5 and 10.
- Corruption - RMAN logs, logs of exports and / or DataPump, dbverify, v $ database_block_corruption
- .
- tablespaces Growth - grow them, partition management, temporary tablespaces, undo. Data Guard - check in the logs that the application / transport is in sync. Logs
- SQL * NET listener - intrusion detection.
- Audit logs and evidence - intrusion detection, removing unused accounts.
- Dumps core and user - space they occupy, Oracle bugs.
- Creating new accounts - should be at least partly automated.
- Update users about security - at least 24 hours in advance. Migrating
- diagrams and code changes or updates specific to SQL.
- Growth of large tables, uniform growth of tablespace.
- Keeping track of daily changes to the database - for some people post of IT staff.
Weekly Backups - usually the entire database.
database cloning for non-productive - or automated scripts. Growth
- tablespaces - the daily accumulated in a week.
- Improved version of Oracle or migration projects for patching - Updates significant.
- Test Data Guard site. Review
- updates My Oracle Support (MOS) - new patches, updates or new versions.
- Updates on local intranet on operational procedures.
- Monthly
database cloning for non-productive - or automated scripts.
growth monitoring tablespaces - the weekly accumulated in a month.
- Trends and Forecasts - CPU consumption, statistics I / O, access
- Change passwords in production - sys, system, wallet, schema, control grid, OAS. Licenses
- use Oracle and it covers. Implement
- recovery scenarios.
- Quarterly
Application CPUs (Critical Patch Upate) and PSUs (September Patch Updates) production planning in suspension of service. Application of CPUs, PSUs instances once unproductive.
growth monitoring tablespaces - the monthly accumulated in an annual update courses
- Oracle - Oracle University (online or classroom), books, informal meetings. Accumulation
- trends and forecasts.
Annual Growth tablespaces - annual report.
Sum of trends and forecasts.
- Oracle Go to conferences - groups of local or national users.
- Oracle Updates planned service suspended - version + patches + PSUs + application once.
- Software Licensing and renewal services.
- Evaluation and updating of hardware.
- SSL Certificate Renewal, Oracle Wallets.
- So, it looks like a bleak set of activities carried out, however, it has the support of tools such as OEM, Grid Control, third party monitoring or custom-made scripts. That is why it is the reiteration that the automation of these tasks is of great importance.
If generalize several of the points mentioned above, we will apply not only to the Oracle platform but can also serve as a reference for managers manage other databases.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment