SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

DBA: Security and Backups

hina avatar
hina
19 diapositives · 424 Views · Aug 11, 2014

DBA: Security and Backups. Agenda. Understand the need for security. Learn about System Permissions and Object permissions. Understand the purpose of Roles. Explore Security-focused SQL. Explain backup and restore options. Data Admin –vs- DB Admin. Data Administration.

#dba: security and backups #dba: security and backups ppt #powerpoint #presentation
DBA: Security and Backups - slide 1
01 / 19DBA: Security and Backups
1 / 17

Télécharger la présentation

DBA: Security and Backups
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. DBA: Security and Backups Guide to Oracle 10g

  2. Agenda Understand the need for security. Learn about System Permissions and Object permissions. Understand the purpose of Roles. Explore Security-focused SQL. Explain backup and restore options.

  3. Data Admin –vs- DB Admin Data Administration Database Administration Owns the Database Technical function Policy &Procedure Enforcement DBMS dependent Tactical Carries out Security Plans • Owns the DATA • High-level function • Policy & Procedure Planning • DBMS independent • Strategic • Maps out Security Plans Guide to Oracle 10g

  4. Data Admin Matrix Data Security documentation tool. Crafted by DA, Carried out by DBA. Guide to Oracle 10g

  5. Security Explained SystemPrivilege User Object Role

  6. Specifying System Privileges • System privilege • Right to perform a specific action • DBA grants system privileges to users or roles • Use System Privileges page in Create User page • Object privilege • Associated permissions of an object • DBA or users grant to users or roles • Admin Option- gives user permissions to grant rights.

  7. System Privileges Reference http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9013.htm#sthref8513

  8. System Privileges Example Shots of sample SQL statements for privileges Guide to Oracle 10g

  9. Roles • Special database object • Represents collection of system privileges • Can be assign to multiple users • Create role • Can inherit privileges from other roles • Simpler than assigning system privileges to each user. Guide to Oracle 10g

  10. Role Examples Shots of sample SQL statements for Roles Guide to Oracle 10g

  11. Guide to Oracle 10g

  12. TODO Guide to Oracle 10g

  13. Database Backup and Recovery • Important database administration support tasks include: • Backup • Offline/cold • Online/hot • Recovery Guide to Oracle 10g

  14. Creating Offline (Cold) Backups • Shut down database instance • Copy specific database files to alternate disk location • Parameter file • Control files • Datafiles • Not redo logs • Restart database instance

  15. Creating Online (Hot) Backups • Create hot backup • Place database instance in ARCHIVELOG mode • Back up control file • Back up datafiles • Instruct database to write current contents of redo log files to archive files • Create backup copies of archive log files Guide to Oracle 10g

  16. Database Recovery • Process of restoring database from either cold or hot backup files • Necessary after database failure • Cold backup recovery: • Shut down database • Restore backed up control file and datafiles to database server • Restart database

  17. Database Recovery (continued) • Hot backup recovery: • Recover database to point at which last hot backup created • Use control trace file to generate new copy of control file • Restore backup copies of datafiles • Perform media recovery Guide to Oracle 10g

  18. Backup Strategies • Cold backups • Simplest to perform • Satisfactory for databases whose: • Contents do not change very much • Users can tolerate downtime while DBA creates cold backup files • Hot backups • Complex to perform • Better suited for dynamic, mission-critical databases

  19. Questions