TAILIEUCHUNG - Oracle Database Administration for Microsoft SQL Server DBAs part 2

Oracle Database Administration for Microsoft SQL Server DBAs part 2 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | vi Oracle Database Administration for Microsoft SQL Server DBAs 3 Oracle Installation . 43 Operating Systems . 44 Windows Setup . 46 Useful Linux Unix Commands . 48 Linux Setup . 50 Storage Requirements . 55 Disk Storage . 56 Storage Management with ASM . 57 Oracle Files . 61 Oracle Database Components . 63 Oracle Software Installation . 64 Using a Response File . 67 Removing Software . 68 Upgrading the Database . 68 Applying Patches . 70 Summary . 71 4 Database Definitions and Setup . 73 Servers Databases Instances and Schemas . 74 SQL Server Setup Versus Oracle Setup . 77 Creating Databases . 79 Using the DBCA . 79 Duplicating Databases with Templates and Scripts . 83 Creating the Listener . 85 Choosing a Character Set . 89 Security . 94 Permissions for the Server . 95 Permissions for Schemas . 98 DBA Roles and Responsibilities Revisited . 101 Summary . 102 5 DBA Tools . 103 Overview of Tools for Typical Database Tasks . 104 Oracle Enterprise Manager . 105 OEM Navigation . 105 Storage Management . 107 Database Configuration . 108 Oracle Scheduler . 109 Statistics and Resource Management . 109 Contents vii Security . 109 Enterprise Manager Configuration . 111 SQL Plus . 112 SQL Developer . 117 Client Connections . 119 Client Connection Configuration . 120 JDBC Connections . 123 Aliases . 123 My Oracle Support . 124 Summary . 125 6 Database Backup Restore and Recovery . 127 Backing Up Databases . 128 Backup Strategies . 128 Backup and Restore Commands . 129 RMAN Configuration for Backups . 131 Backup Options . 135 Backup Examples . 137 OEM Backup Jobs . 137 Restoring and Recovering Databases . 141 What Can Go Wrong . 141 Restore and Recover Options . 143 Data Recovery Advisor . 147 Copying the Database . 149 Managing Backups . 152 Viewing Backups . 152 Purging Obsolete Files . 155 Backing Up and Restoring Objects . 156 Copying Objects at the Table and Schema Level . 156 Using Data Pump . 157 Protecting Users from Users . 161 Recycle Bin . 161 Flashback . 164 .

• Chứng chỉ quốc tế
• Học Oracle
• quản lý cơ sở dữ liệu
• luyện thi chứng chỉ quốc tế
• môi trường SQL Server
• cơ sở dữ liệu oracle
• Đề cương môn Chuyên đề Oracle
• Chuyên đề Oracle
• Quản trị cơ sở dữ liệu
• Biện pháp bảo vệ cơ sở dữ liệu
• Cấu trúc lưu trữ
• Tin học thực dụng
• Thực hành ORACLE 11g
• Lý thuyết ORACLE 11g
• Ngôn ngữ lập trình PL SQL
• Lập trình nâng cao với PL SQL
• Thư viện Java
• Topic Focused
• Multi document Summarization
• Approximate Oracle Score
• báo cáo khoa học
• mô hình ngôn ngữ
• xử lý ngôn ngữ tự nhiên