الانتقال إلى المحتوى

خطوات ال Dba


hossam_fared

Recommended Posts

السلام عليكم ورحمة الله وبركاته
لقد نجحت والحمد لله وأخذت شهادة ال OCP وأصبحت DBA
والأن سأبدأ العمل ان شاء الله فى شركة ومشروع جديد
فأرجو التكرم من الأخوة أن يدلونى ما هى الخطوات المبدئية التى يجب أن أقوم بها أو على الأقل يجب اتقانها الأن ،، حتى يتسنى لى مسايرة العمل وأخذ الخبرة اللازمة ، وأرجو عدم التجاهل ،

رابط هذا التعليق
شارك

السلام عليكم و رحمة الله و بركاته
أخي الكريم هذا ملخص لمهم DBA ويمكنك الرجوع الى Administrator's Guide in 9i documention


Tasks of a Database Administrator
The following tasks present a prioritized approach for designing, implementing, and maintaining an Oracle Database:

Task 1: Evaluate the Database Server Hardware

Task 2: Install the Oracle Software

Task 3: Plan the Database

Task 4: Create and Open the Database

Task 5: Back Up the Database

Task 6: Enroll System Users

Task 7: Implement the Database Design

Task 8: Back Up the Fully Functional Database

Task 9: Tune Database Performance

These tasks are discussed in succeeding sections.


--------------------------------------------------------------------------------
Note:
If upgrading to a new release, back up your existing production database before installation. For information on preserving your existing production database, see Oracle9i Database Migration.

--------------------------------------------------------------------------------


Task 1: Evaluate the Database Server Hardware
Evaluate how Oracle and its applications can best use the available computer resources. This evaluation should reveal the following information:

How many disk drives are available to Oracle and its databases
How many, if any, dedicated tape drives are available to Oracle and its databases
How much memory is available to the instances of Oracle you will run (see your system's configuration documentation)
Task 2: Install the Oracle Software
As the database administrator, you install the Oracle database server software and any front-end tools and database applications that access the database. In some distributed processing installations, the database is controlled by a central computer (database server) and the database tools and applications are executed on remote computers (clients). In this case, you must also install the Oracle Net components necessary to connect the remote machines to the computer that executes Oracle.

For more information on what software to install, see "Identifying Your Oracle Database Software Release".

See Also:
For specific requirements and instructions for installation, refer to the following documentation:

Your operating system specific Oracle documentation
Your installation guides for your front-end tools and Oracle Net drivers.


Task 3: Plan the Database
As the database administrator, you must plan:

The logical storage structure of the database
The overall database design
A backup strategy for the database
It is important to plan how the logical storage structure of the database will affect system performance and various database management operations. For example, before creating any tablespaces for your database, you should know how many datafiles will make up the tablespace, what type of information will be stored in each tablespace, and on which disk drives the datafiles will be physically stored. When planning the overall logical storage of the database structure, take into account the effects that this structure will have when the database is actually created and running. Such considerations include how the logical storage structure database will affect the following:

The performance of the computer executing Oracle
The performance of the database during data access operations
The efficiency of backup and recovery procedures for the database
Plan the relational design of the database objects and the storage characteristics for each of these objects. By planning the relationship between each object and its physical storage before creating it, you can directly affect the performance of the database as a unit. Be sure to plan for the growth of the database.

In distributed database environments, this planning stage is extremely important. The physical location of frequently accessed data dramatically affects application performance.

During the planning stage, develop a backup strategy for the database. You can alter the logical storage structure or design of the database to improve backup efficiency.

It is beyond the scope of this book to discuss relational and distributed database design. If you are not familiar with such design issues, refer to accepted industry-standard documentation.

Part II, "Oracle Server Processes and Storage Structure" and Part III, "Schema Objects" provide specific information on creating logical storage structures, objects, and integrity constraints for your database.

Task 4: Create and Open the Database
When you complete the database design, you can create the database and open it for normal use. You can create a database at installation time, using the Database Configuration Assistant, or you can supply your own scripts for creating a database.

Either way, refer to Chapter 2, "Creating an Oracle Database", for information on creating a database and Chapter 4, "Starting Up and Shutting Down" for guidance in starting up the database.

Task 5: Back Up the Database
After you create the database structure, carry out the backup strategy you planned for the database. Create any additional redo log files, take the first full database backup (online or offline), and schedule future database backups at regular intervals.

See Also:
For instructions on customizing your backup operations and performing recovery procedures see either of the following:

Oracle9i User-Managed Backup and Recovery Guide
Oracle9i Recovery Manager User's Guide


Task 6: Enroll System Users
After you back up the database structure, you can enroll the users of the database in accordance with your Oracle license agreement, create appropriate roles for these users, and grant these roles.

The following chapters will help you in this endeavor:

Chapter 23, "Establishing Security Policies"
Chapter 24, "Managing Users and Resources"
Chapter 25, "Managing User Privileges and Roles"
Task 7: Implement the Database Design
After you create and start the database, and enroll the system users, you can implement the planned logical structure database by creating all necessary tablespaces. When you complete this, you can create the objects for the database.

Part II, "Oracle Server Processes and Storage Structure" and Part III, "Schema Objects" contain information which can help you create logical storage structures and objects for your database.

Task 8: Back Up the Fully Functional Database
Now that the database is fully implemented, again back up the database. In addition to regularly scheduled backups, you should always back up your database immediately after implementing changes to the database structure.

Task 9: Tune Database Performance
Optimizing the performance of the database is one of your ongoing responsibilities as a DBA. Additionally, Oracle provides a database resource management feature that enables you to control the allocation of resources to various user groups.

The database resource manager is described in Chapter 27, "Using the Database Resource Manager".

See Also:
Oracle9i Database Performance Tuning Guide and Reference contains information about tuning your database and applications.

رابط هذا التعليق
شارك

السلام عليكم ورحمة الله وبركاته

شكرا يا أخ hkhalifa
انا بصراحة لسه لم أقرأ ردك ، ولكن جزاك الله خيرا على ردك أيا كان،، وان شاء الله هبقى أبلغك بعد القرأه ،، وشكرا مرة أخرى..

رابط هذا التعليق
شارك

  • بعد 1 شهر...

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
×
  • أضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية