夜归人

startup nomountalter database db01 mount;alter database db01 open read only    只能 nomount ->mount->open ， 不能反过来操作受限模式：STARTUP RESTRICTALTER SYSTEM ENABL RESTRICTED SESSION杀sessio

RMAN  ComponentsRepository1: Control File1.RAMN repository is metadata about targe database and backup and recovery operations2.RMAN repository is always stored in the control file of

Using RMAN in ARCHIVELOGrman target sys/sysRMAN> backup database format '/u01/app/oracle/flash_recovery_area/KING/wb_%u'; RMAN> sql 'alter system archive log current'; //这个不是必须但是是习惯这么做

The Listener ProcessThe Listener ProcessConnectionMethodsWhen a connection  request is made by a client to a server, the listener performs one of the following: 1.Spawns a server proce

Server Configurations1.Dedicated server process2.Shared server processDedicated Server ProcessesOracle Shared ServerBenefits of Shared Server1.Reduces the

Objectives After completing this lesson, you should be able to do the following:1.Identify key tuning components of the alert log file2.Identify key runing components of background trace files

Objectiveafter completing this lesson, you should be able to do the following:1.List the advantages of distributing different Oracle file types2.Diagnose tablespace usage problesm3.List reason

ORACLE体系架构分为两个部分： Database和Instance。Instance:连接到oracle数据库。由内存(SGA)和后台进程(Background process structures)构成oracle Database: 三种基本的文件类型 : 数据文件， 控制文件，重做日志文件 。(还包括 参数文件 归档日志文件)内存区域包含两个内存块：SGA（Syste

Performance Monitoring23132

Moving Data General Architecture

1231231231231231

Flashback TechnologyFlashback Database Architecture

１１１

ASM Key Features and Benefits1.文件条带2.磁盘动态均衡（加入新磁盘后，数据动态重新分布）3.调整均衡速度（动态分布的速度）4.冗余保护 ，文件级别镜像5.只能用在oracle之中6.拥有裸设备IO的效率7.动态数据库文件管理8.没有热点， 消除手动I/O调整

Trminology1.Whole database backup   a.Targt database may be open or closed   b. Backup of all datafiles and the control file2.Partial database backups   a.Tablespace   b.Data file   c.

Globalization Support Features1.Language support2.Terriroty support3.character set support4. Linguistic sorting5. Message support6. Date and time formats7.Numeric formats8.Monetary for

Online Redo Log FilesOnline Redo log files have the following characteristics:Record all changes made to dataProvide a recovery mechanismCan be organized into groupsAt least two groups requi

Tablespaces & DataFilesOracle stores data logically in tablespaces and physically in data filesTablespaces:   1.Can belong to only one dataase at a time   2. Consist of one or more data files

Creating a DB ManuallyStep1:Specify an Instance Identifier(SID)Step2: Ensure That the Required Environment Variables Are SetStep3: Choose a Database Administrator Authenticatio MethodStep4:Cre

Multiple Block Size Support1.a database can ben created with a standard block size and up to four nonstandard block sizes.2.Block sizes can have any power-of-two value between 2KB and 32KB

Auto Undo Mgmt: Concepts1.Undo data is managed using an UNDO tablespace.2.You allocate one UNDO tablespace per instance with enough space for the workload of the instance.3.The Oracle server aut

Other object created with the database:   Data dictionary   Performance tabes   PL/SQL packages   Database event triggersThe data dictionary contains two parts:Base tables    Stores de

Database SchemeChecklist for Creating UsersDatabase AuthenticationOS Authenticationshow parameter authCREATE USER OPS$bbker INDENTIFIED EXTERNALLY default tablepa

Profiles1.A pfofile is a named set of password and resource limits2.Profile are saaigned to users by the CREATE USER or ALTER USER command3.Profiles can be enabled or disabled4.Profiles can re

NOARCHIVELOG MdeARCHIVELOG ModeChangng the Archiving Mode第五部 全备是  恢复的起始点Auto And Manual archivingSpecify Multi-ARCn Process1. The dynamic parameter

Object1.Employ  the buffer cache sizing advisor2.Describle how the buffer cache is used by different Oracle processes3.Create and manage different buffer caches4.Monitor the use of the buffer

Categories of Failures1.Statement failure2.User process failure3.User error4.Instance failure5.Media failureCauses of Statement Failures1.Logic errr in an application2. attempt to

Two  types of Oracle user privileges:1.System: Enable users to perform particular actions in the dtabase2.Object : Enables users to access and manipulate a specific objectSystem privileges

Direct LoadOracle Database inserts data into a table in one of two ways:1.During cnventional INSERT operations the database reuses free space int he table, interleaving newly inserted, data with e

Granule1.SGA components are allocated and deallocated in units of contiguous memory called granules2.The size of a granule depends on the estimated total SGA, If the estimated SGA size if

Choosing Database Duplication Techniquescreating a duplicate database  for active database duplication  (oracle 11g 功能)Duplicating an Active DatabaseDuplicating a Database with a