没有合适的资源?快使用搜索试试~ 我知道了~
Oracle Database 10g: Administration Workshop II
5星 · 超过95%的资源 需积分: 10 240 下载量 37 浏览量
2007-05-29
16:10:15
上传
评论
收藏 4.74MB PDF 举报
温馨提示
试读
604页
Oracle Database 10g: Administration Workshop II
资源推荐
资源详情
资源评论
Oracle Database 10g:
Administration Workshop II
Student Guide
D17092GC20
Edition 2.0
May 2004
D39448
®
Copyright © 2004, Oracle. All rights reserved.
This documentation contains proprietary information of Oracle Corporation. It is
provided under a license agreement containing restrictions on use and disclosure and
is also protected by copyright law. Reverse engineering of the software is prohibited.
If this documentation is delivered to a U.S. Government Agency of the Department of
Defense, then it is delivered with Restricted Rights and the following legend is
applicable:
Restricted Rights Legend
Use, duplication or disclosure by the Government is subject to restrictions for
commercial computer software and shall be deemed to be Restricted Rights software
under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013,
Rights in Technical Data and Computer Software (October 1988).
This material or any portion of it may not be copied in any formor by any means
without the express prior written permission of Oracle Corporation. Any other copying
is a violation of copyright law and may result in civil and/or criminal penalties.
If this documentation is delivered to a U.S. Government Agency not within the
Department of Defense, then it is delivered with “Restricted Rights,” as defined in
FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987).
The information in this document is subject to change without notice. If you find any
problems in the documentation, please report them in writing to Education Products,
Oracle Corporation, 500 Oracle Parkway, Redwood Shores, CA 94065. Oracle
Corporation does not warrant that this document is error-free.
Oracle and all references to Oracle Products are trademarks or registered trademarks
of Oracle Corporation.
All other products or company names are used for identification purposes only, and
may be trademarks of their respective owners.
Authors
Janet Stern
James Womack
Technical Contributors
and Reviewers
Lothar Auert
Dairy Chan
Gerlinde Frenzen
Joel Goodman
Christine Jeal
Martin Jensen
Susan Jang
Donna Keesling
Wolfgang Krueger
Roman Niehoff
Srinivas Putrevu
Andreas Reinhardt
Dr. Sabine Teuber
Chandru Venkatesan
John Watson
Editor
AtanuRaychaudhuri
Publisher
Poornima G
Preface
1 Introduction
Course Objectives 1-2
How DBAs Spend Their Time 1-3
Oracle Database 10g Manageability Goals 1-4
Database Management Challenges 1-5
Oracle Database 10g Solution: Self-Managing Database 1-6
How Oracle Database 10g DBAs Spend Their Time 1-7
Student Preface 1-8
2 Using Globalization Support
Objectives 2-2
Globalization Support Features 2-3
Encoding Schemes 2-4
Database Character Sets and National Character Sets 2-7
Datetimes with Timezones 2-9
Configuring the Database Local Timezone 2-10
Configuring Datetime Formats 2-11
Using Timezones 2-12
Specifying Language-Dependent Behavior 2-13
Specifying Language-Dependent Behavior for the Server 2-14
Language and Territory Dependent Parameters 2-15
Other NLS Server Parameters 2-17
Specifying Language-Dependent Behavior for the Session 2-18
Locale Variants 2-21
Using NLS Parameters in SQL Functions 2-22
Linguistic Sorting 2-25
Using Linguistic Sorting 2-27
Sorts That Are Not Case or Accent Sensitive 2-29
Linguistic Comparisons 2-30
Linguistic Index Support 2-31
Customizing Linguistic Sorting 2-32
Oracle Locale Builder 2-33
Character Set Scanner Utilities 2-34
Data Conversion Between Client and Server Character Sets 2-36
NLS Data Conversion with Oracle Utilities 2-37
NLS Data Conversion with Data Pump 2-39
Obtaining Character Set Information 2-40
Obtaining NLS Parameter Information 2-41
Summary 2-43
Practice 2 Overview: Using Globalization Support Features 2-44
Practice 2: Using Globalization Support Features 2-45
Practice 2: Globalization Support 2-46
Contents
iii
3 Controlling Access to the Oracle Listener
Objectives 3-2
Oracle Net Services Review 3-3
Listener Password Authentication 3-4
Setting Listener Password 3-5
Setting Listener Password with Net Manager 3-6
Set Password with lsnrctl Utility 3-7
Controlling Database Access 3-8
Oracle Net Services External Procedures 3-9
Overview of the EXTPROC Agent 3-10
PL/SQL Calling a C External Procedure 3-11
Default Configuration for External Procedure Calls 3-12
Modifying the Configuration for External Procedure Calls 3-14
Remove Default EXTPROC Entry 3-15
Configure a Dedicated Listener for External Procedure Calls 3-17
Summary 3-21
Practice 3 Overview: Controlling Access to the Listener 3-22
4 Configuring Recovery Manager
Objectives 4-2
Recovery Manager Features 4-3
Recovery Manager Components 4-5
Media Management 4-7
Using a Flash Recovery Area with RMAN 4-9
Setting Parameters for RMAN 4-10
RMAN Usage Considerations 4-12
Connection Types with RMAN 4-13
Starting RMAN 4-14
Additional RMAN Command Line Arguments 4-15
Configuring Persistent Settings for RMAN 4-16
Configuring RMAN Settings Using EM 4-17
Control File Autobackups 4-18
Retention Policies 4-20
Managing Persistent Settings 4-21
Channel Allocation 4-22
Automatic and Manual Channel Allocation 4-23
Channel Control Options 4-24
Summary 4-26
Practice 4 Overview: Configuring RMAN 4-27
5 Using Recovery Manager
Objectives 5-2
Issuing Recovery Manager Commands 5-3
RMAN Command Overview 5-5
RMAN Commands 5-6
Job Command: Example 5-7
iv
The BACKUP Command 5-8
Backup Constraints 5-9
Parallelization of Backup Sets 5-10
Compressed Backups 5-12
Image Copy 5-13
Tags for Backups and Image Copies 5-15
BACKUP Options 5-16
Backing Up Archived Redo Logs 5-18
Copying the Whole Database 5-19
Making Incremental Backups 5-20
Incremental Backup: Example 5-22
Block Change Tracking 5-23
Enabling Block Change Tracking 5-24
Incrementally Updating Backups 5-25
LIST Command Operations 5-26
The REPORT Command 5-27
The REPORT NEED BACKUP Command 5-28
REPORT NEED BACKUP: Examples 5-29
REPORT OBSOLETE and DELETE OBSOLETE 5-30
Managing Backups with EM 5-31
RMAN Dynamic Views 5-32
Monitoring RMAN Backups 5-34
Summary 5-36
Practice 5 Overview: Using RMAN 5-37
6 Diagnostic Sources
Objectives 6-2
Diagnostic Files 6-3
The Alert Log 6-4
What Is in the alert.log File 6-5
Viewing Recent Alert Log Entries 6-6
Alert Models Architecture 6-7
Server-Generated Alert Types 6-8
Viewing Alerts with Enterprise Manager 6-9
Alerts Notification 6-11
Alert Log Monitoring Configuration 6-12
Editing Thresholds 6-13
Viewing Initialization Parameters 6-14
Trace Files 6-15
Specifying the Location of Trace Files 6-16
Controlling Trace File Size 6-17
Controlling Trace File Writes 6-18
Using Enterprise Manager to Enable and View SQL Tracing 6-19
System Log Files 6-20
Summary 6-21
Practice 6 Overview: Diagnosing Problems 6-22
v
剩余603页未读,继续阅读
资源评论
- yaanzy2013-06-27这本Oracle10g管理员手册的下册,内容写得依然跟上册一样好
- worldren2013-04-17正在仔细研读中,谢谢楼主分享,正好需要。
- vogts2014-06-07好资料,不错.
- 甘甘2013-08-12终于找到这本书的英文版了,感谢楼主分享,而且还是免分下载的哦,楼主,我爱你
Gugu_Abrams
- 粉丝: 1
- 资源: 100
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功