Oracle Database 10g/11g Core DBA Training Contents

Viewer
Transcript

https://sites.google.com/site/onlineoracledbatraining/

Oracle Database 10g/11g Core DBA Training Contents 1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) 13) 14) 15) 16) 17) 18) 19) 20) 21) 22) 23) 24) 25) 26) 27) 28) 29) 30) 31) 32) 33) 34) 35) 36) 37) 38) 39) 40) 41) 42) 43)

Introduction to DBA Relational Database Systems Integrity Constraints Structured Query Language Tasks of an Oracle Database Administrator Installation of Oracle Database Software Optimal Flexible Architecture (OFA) Oracle Universal Installer Prerequisite Checks Installation Configuration Assistants Creating an Oracle Database Database Architecture Exploring the Storage Structure Control Files Redo Log Files Tablespaces and Datafiles Segments, Extents, and Blocks Oracle Instance Management Oracle Memory Structures Oracle Processes Data Dictionary Database Control Grid Control Database Configuration Assistant (DBCA) Overview Creating a Database Passwords and Storage File Locations and Backup Recovery Content and Initialization Parameters Other Actions with DBCA Managing the Database Starting and Stopping iSQL*Plus Starting and Stopping Database Control Accessing Database Control SYSOPER and SYSDBA Database Home Page Changing the Listener Status NOMOUNT MOUNT OPEN States SHUTDOWN Options Initialization Parameter Files Viewing the Alert Log Net Services Oracle Net Services

44) 45) 46) 47) 48) 49) 50) 51) 52) 53) 54) 55) 56) 57) 58) 59) 60) 61) 62) 63) 64) 65) 66) 67) 68) 69) 70) 71) 72) 73) 74) 75) 76) 77) 78) 79) 80) 81) 82) 83) 84) 85) 86) 87) 88) 89) 90)

Oracle Net Listener Monitoring the Listener Listening Addresses Static Database Registration Listener Control Utility Oracle Net Connections Directory Naming Advanced Connections Oracle Net Manager Configuring Service Aliases with Net Manager Managing Schema Objects Schemas Accessing Schema Objects Schema Object Namespaces Specifying Data Types in Tables Other Data Types Creating and Modifying Tables Understanding Data Integrity Defining Constraints Viewing the Attributes of a Table Viewing the Contents of a Table Creating Indexes Creating Views Using a Sequence Storage Structures Tablespaces and Data Files Space Management in Tablespaces Storage for Locally Managed Tablespaces Altering a Tablespace Actions with Tablespaces Dropping Tablespaces Viewing Tablespace Information Administering Users Database User Accounts Creating a User Profiles and Users Authenticating Users Database Users and Schemas Privileges : System and Object Roles Assigning Quota to Users Assigning Roles to Users Managing Data Objectives Manipulating Data Through SQL The INSERT Command The UPDATE Command

91) The DELETE Command 92) The COMMIT and ROLLBACK Commands 93) Integrity Constraints and DML 94) Data Pump Export 95) Data Pump Import 96) DIRECTORY Objects 97) SQL*Loader 98) The SQL*Loader Control File 99) Control File Syntax Considerations 100) Input Data and Data Files 101) Loading Methods 102) Comparing Direct and Conventional Path Loads 103) Loading Data with SQL*Loader 104) External Tables 105) Transportable tablespace 106) Undo Management 107) Undo Data 108) Transactions and Undo Data 109) Storing Undo Information 110) Monitoring Undo 111) Administering Undo 112) Configuring Undo Retention 113) Guaranteeing Undo Retention 114) Sizing the Undo Tablespace 115) Using the Undo Advisor 116) Backup and Recovery Concepts 117) Backup and Recovery Issues 118) Categories of Failures 119) Instance Recovery 120) Phases of Instance Recovery 121) Tuning Instance Recovery 122) Using the MTTR Advisor 123) Configuring for Recoverability 124) ARCHIVELOG Mode 125) Configuring Backup Strategy 126) Scheduling Backups: Review 127) Backup Control File to Trace 128) Manage Backups 129) Database Recovery 130) Opening a Database 131) Changing Instance Status 132) Keeping a Database Open 133) Scenarios: 134) Loss of a Control File 135) Loss of a Redo Log File 136) Loss of a Data File in NOARCHIVELOG Mode 137) Loss of a Noncritical Data File in ARCHIVELOG Mode

138) 139) 140) 141) 142) 143) 144) 145) 146) 147) 148) 149) 150) 151) 152) 153) 154) 155) 156) 157) 158) 159) 160) 161) 162) 163) 164) 165) 166) 167) 168) 169) 170) 171) 172) 173) 174) 175) 176) 177) 178) 179)

Loss of a System-Critical Data File in ARCHIVELOG Mode Oracle Recovery Manager Oracle Recovery Catalog maintenance Backups using Oracle Recovery Manager Recovery using Oracle recovery manager Database Cloning using RMAN Tablespace Point in time recovery Incomplete recovery Monitoring and Resolving Lock Conflicts Locks Locking Mechanism Data Concurrency DML Locks Enqueue Mechanism Lock Conflicts Possible Causes of Lock Conflicts Detecting Lock Conflicts Resolving Lock Conflicts Deadlocks Performance Monitoring Performance Monitoring Monitoring Methodologies Database and Instance Metrics Data Dictionary Metrics Optimizer Statistics Schedule Optimizer Statistics Collection Dynamic Performance Views Viewing Metric Information Reacting to Performance Issues Reacting to Performance Issues Proactive Maintenance Server Generated Alerts Thresholds Setting Thresholds Baseline Measurements Tuning and Diagnostic Advisors SQL Tuning and Access Advisors Memory Advisors Segment Advisor Automatic Workload Repository (AWR) Managing the AWR Automatic Database Diagnostic Monitor (ADDM)